Fermé

SAS programmer

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

Compétences : Statistiques, SAS, Science des données, Analyses statistiques, Computer Science

en voir plus : 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, create csv email list, javascript create csv file form, hyderabad sas programmer, php create csv php, python query results create csv file, create csv utility

Concernant l'employeur :
( 0 commentaires ) Toronto, Canada

Nº du projet : #28344727

5 freelances font une offre moyenne de 90 $ pour ce travail

(35 Commentaires)
6.0
anef12

Hi, I am a SAS programmer with 5 years experience with SAS. Please reach out if you need help. Regards, Aida

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(4 Commentaires)
4.0
muralikrishnaee

Experienced sas professionals with more than 13 years of experience in coding and good with explanations

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(0 Commentaires)
0.0
Shweta1112

Hello, I have read your job posting and I am interested in the same. I have a B. Tech (Computer Science) and MBA from the very best universities in the country with an acceptance rate of 0.01% of the applicants. I ha Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 7 jours
(0 Commentaires)
1.7
Phily00

asking 90 cad for this.. 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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(0 Commentaires)
0.0