Question: Write a SAS DATA step to read the following data. The data is separated by the commas. The list of variables is ID, GENDER, SCORE,

Write a SAS DATA step to read the following data. The data is separated by the commas. The list of variables is ID, GENDER, SCORE, DATE (mmddyyyy), AMOUNT and PROFIT(dollar). (Note that the variable AMOUNT is a four-digit integer with a comma format. e.g: 1,000=1000). (hint: column input is not proper.)

001,M,98,10/11/1981,1,000,$7.81

002,F,100,03/13/1986,9,999,$17.91

003,M,89,04/11/1979,1,200,$1.42

004,M,77,02/13/1985,5,300,$9.26

Write a SAS PROC step to print out the observations on condition that the AMOUNT is greater than 1100 and the PROFIT is greater than $2. Please keep the format for DATE, AMOUNT and PROFIT.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!