Read the following data into SAS: ID, name, gender, DOB, score1,
score 2. Do not do any
change for the data. Print the data to verify.
001 John Adams M 10/10/1976 100.3 99.0
002 Sarah White F 01/01/1960 89.5 97.7
003 Steven Cook M 05/07/2001 90.9 98.6
2. Read the following data into SAS: ID, name, Gender, ssn,
taxdate, income. Do not do any
change for the data. Print the data to verify.
001 John Adams M 086-59-9054 04/12/2001 59,365
002 Sarah White F 405-65-0987 03/05/2002 26,925
003 Steven Cook F 212-44-9054 04/15/2003 44,999
Solution1:
SAS code
data ds1;
infile datalines;
input ID $ name $11. gender $ DOB:ddmmyy10. score1 score2;
format DOB:ddmmyy10.;
datalines;
001 John Adams M 10/10/1976 100.3 99.0
002 Sarah White F 01/01/1960 89.5 97.7
003 Steven Cook M 05/07/2001 90.9 98.6
;
run;
proc print data=ds1;
run;
SAS screen shots:
Read the following data into SAS: ID, name, gender, DOB, score1, score 2. Do not do...
Write MySQL query statements for the questions below including
the output that proves the accuracy of your solution. Your answers
should be stored in a text file that captures your interaction with
MySQL.
1. Find the movieID, title, year and DVDPrice of all movies
where the DVD-Price is equal to the discountPrice.
2. Find the actorID, lastName, firstName, middleName, and suffix
of all actors whose middleName is not NULL.
3. Suppose you remember a movie quote as “Play it again,...
Write a python code using pandas for this following
problem and do not forgot to add comments in your
code.
Suppose you have a text file called “President.txt” (which is
shown below), you have to import this text file in code and using
the data of this file, you have to create a new file called
“NewPreFile.txt” where you will only show the only selected data of
old “president.txt” file. In “NewPreFile.txt” file you need to show
the presidents name,...
Database Design Problem You have been hired to review the accuracy of the books of Northeast Seasonal Jobs International (NSJI), a job broker. NSJI matches employers whose business is seasonal (like ski resorts) with people looking for part time positions at such places. Employers are located in the Northeast (New England), but recently expanded to include parts of Canada. NSJI maintains all of this information in a flat file spreadsheet (see attached layout of the spreadsheet structure). Required: 1) From...
23:01 4G Midterm Econometrics II Semester 1 2.. 1 You are given data on price and quality of cocaine. You believe that the quality of cocaine affects the price, so you ran the following regression: The STATA output storage display valuc name type foemat l label variable label flat %9.0g float %9.0g float %9.0g float %9.0g peice per gram in dollars foe a cocaine number of grams of cocaine in a give quality of the cocaine expressed as a time...