Use SAS coding and don\'t use Proc SQL: 2-) Write a code to create separate data
ID: 3595384 • Letter: U
Question
Use SAS coding and don't use Proc SQL:
2-) Write a code to create separate data field for First Name, Last Name, Address and Email for the data below
John Smith Jr, 34 Hudson Street, Union, NJ 82834, js@yahoo.com
Mary Jane Junior, 56 Mountain St. Maplewood New Jersey 34509, MJ@yahoo.com
3-) Write a SAS code that simulates 10,000 numbers from the normal distribution and calculate the mean and standard deviation
4-) Write a code that simulates 10, 20,....,100 numbers from the normal distribution and calculate mean and standard deviation for each run
5-) Run the code below, and by using the arrays. When test values less than 3000, replace the test values with missing
input famid test1-test12 ;
cards;
1 3281 3413 3114 2500 2700 3500 3114 3319 3514 1282 2434 2818
2 4042 3084 3108 3150 3800 3100 1531 2914 3819 4124 4274 4471
3 6015 6123 6113 6100 6100 6200 6186 6132 3123 4231 6039 6215
;
run;
Explanation / Answer
1.
The separate data fields can be created as follows:
data person;
a $ 5;
b $ 2;
LastName = a||b;
c $ 6;
d $ 6;
e $ 5;
f $ 2;
Address = c||d||e||f||e
input FirstName $ 4 LastName Address Email $ 12;
datalines
John Smith Jr 4 Hudson Street Union NJ 82834 js@yahoo.com
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.