SAS programmer -- 2
$10-30 CAD
Pago na entrega
You are provided with the raw data (in four CSV files). An included README file describes the data set in detail, which includes information on troop size, location, temperature and dates.
Your job will be to manipulate the Napolean data in the ways described below, using SAS code only.
You will also be required to produce a single graphic and a short report, as described below.
Requirements:
• prep the original three data sets and create a SAS dataset for each csv file
• merge the three data sets (using SAS code) into a single data set for the purposes of analysis, where each observation corresponds to a date in the campaign, and has the following variables:
o date
o longitude
o latitude
o city
▪ the name of the city, when the troops are in that city; should have the form "City1-City2" when the troops are in between City1 and City2
o troops
▪ number of troops
o temperature
▪ temperature in degrees Celsius
o latitude
▪ degrees latitude from Kowno (the starting point)
o longitude
▪ degrees longitude from Kowno
o x
▪ kilometres latitude from Kowno:
▪ calculate this by converting degrees latitude to kilometre: 1 degree latitude is about 111 km.
o y
▪ kilometres longitude from Kowno:
▪ calculate this by converting degrees longitude to kilometre: 1 degree longitude is about 63.5 km (at the approximate latitudes relevant here).
o distance
▪ distance from last site (0 at start of campaign in Kowno) in kilometres.
▪ positive for advance, negative for retreat
▪ calculate using the following formula:
• ????????= √(?2−?1)2+(?2−?1)2
• where
o ?1 is ? for the previous observation
o ?2 is ? for the current observation
o ?1 is ? for the previous observation
o ?2 is ? for the current observation
o velocity
▪ velocity (km/day)
▪ calculate using the following formula:
• ????????=????????# ?? ???? ????? ???? ???????????
• Include as many dates as you have information about in the data.
• You may calculate or extrapolate (guess) missing dates if necessary, but missing temperatures should be left as missing (the dataset only has temperature data for the retreat).
ID do Projeto: #28344804
Sobre o projeto
4 freelancers estão ofertando em média $77 nesse trabalho
i will do this task properly according to your wish kindly message me I am ready to work with you right now I am waiting for your response
I am certified SAS expert with experience in renowned fonancial companies in india. So, I think I can do this job.
Hi, I am an experienced data analyst with an expertise in SAS of more than 10 years. I can deliver this project as per your requirements. Waiting to hear from you. Regards, Sneha Srivastava
For past 3 years doing the same job for different clients as primary occupation. Has good knowledge of base and advance sas and merges and joins.
