SAS programmer -- 2

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.


• 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).

Skills: Statistics, SAS, Data Science, Statistical Analysis, Computer Science

See more: phone number information csv, create csv file dts sql server 2005, create csv pdf php, php create csv, create csv file, create csv files utility, php mysql create csv file, create csv file complete day, program create csv access database, php create csv godaddy database email, create csv php page, create csv php web form, python create csv, create csv file excel, excel number format csv, create csv email list, javascript create csv file form, hyderabad sas programmer, igt sas simulator download

About the Employer:
( 0 reviews ) Toronto, Canada

Project ID: #28344804

4 freelancers are bidding on average $77 for this job


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

$167 CAD in 7 days
(0 Reviews)

I am certified SAS expert with experience in renowned fonancial companies in india. So, I think I can do this job.

$45 CAD in 5 days
(0 Reviews)

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

$50 CAD in 2 days
(0 Reviews)

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.

$45 CAD in 3 days
(0 Reviews)