Question

1. Copy/paste this data on online orders into SAS. Write a program that will

• read it including date informats;
• create a variable, called WaitTime, that is the number of days between Order and Delivery. Use an IF statement to give a value of 0 if the Delivery date is missing;
• recode the categories of method of payment, changing C to Credit and P to Paypal;
• print the data set using a different date format than the informat; and
• do proc means for number of items ordered, amount, and the days until delivery computed above.

ID    Nitems   Method   Amount   Order Delivery

A44730 5 C 140 10SEP18 14SEP18

B41373 1 C 35 08OCT18 17OCT18

A20919 12 P 220 18OCT18 25OCT18

C00099 2 C 47 30OCT18 03NOV18

B21013 4 P 82 11JAN19

D82908 6 P 168 11JAN19 15JAN19

Answer 1

Sol:

Requirement:

1. Copy/paste this data on online orders into SAS. Write a program that will

• read it including date informats;

Solution:

use infile with cards to read data.

lists the varibales in input statement

use dlm option and set dlm as space

use truncover to read missing value

SAS code:

data orders;

infile cards dlm=' ' truncover;

input ID $ Nitems Method $ Amount Order:date9. Delivery:date9.;

format Order:date9. Delivery:date9.;

cards;   

A44730 5 C 140 10SEP18 14SEP18

B41373 1 C 35 08OCT18 17OCT18

A20919 12 P 220 18OCT18 25OCT18

C00099 2 C 47 30OCT18 03NOV18

B21013 4 P 82 11JAN19

D82908 6 P 168 11JAN19 15JAN19

;

run;

Requirement2:

create a variable, called WaitTime, that is the number of days between Order and Delivery. Use an IF statement to give a value of 0 if the Delivery date is missing.

Recode the categories of method of payment, changing C to Credit and P to Paypal;

S0lution:

modifying the above program

use intck function in sas to get the difference in days.

and if function to set the waittime is 0 if delivery is missing

SAS Code:

data orders;

infile cards dlm=' ' truncover;

input ID $ Nitems Method $ Amount Order:date9. Delivery:date9.;

format Order:date9. Delivery:date9.;

WaitTime=intck('days',Order,Delivery);

if Delivery in ('') then WaitTime = 0;

else WaitTime = WaitTime;

IF (Method= 'C') THEN Method = 'CREDIT';

IF (Method= 'P') THEN Method = 'PAYPAL';

cards;   

A44730 5 C 140 10SEP18 14SEP18

B41373 1 C 35 08OCT18 17OCT18

A20919 12 P 220 18OCT18 25OCT18

C00099 2 C 47 30OCT18 03NOV18

B21013 4 P 82 11JAN19

D82908 6 P 168 11JAN19 15JAN19

;

run;

Requirement 3:

• print the data set using a different date format than the informat; and

Solution:

use procedure print in sas to print the dataset

use format mmddyy10.

SAS program:

proc print data=orders;
format Order mmddyy10. Delivery mmddyy10.;
run;

Requirement4:

• do proc means for number of items ordered, amount, and the days until delivery computed above.

Solution:

use procedure means and list the variables in var statement.

SAS Code:

PROC MEANS DATA=orders;
var Nitems WaitTime;
run;

ENTIRE SAS SCRIPT IS

data orders;

infile cards dlm=' ' truncover;

input ID $ Nitems Method $ Amount Order:date9. Delivery:date9.;

format Order:date9. Delivery:date9.;

WaitTime=intck('days',Order,Delivery);

if Delivery in ('') then WaitTime = 0;

else WaitTime = WaitTime;

IF (Method= 'C') THEN Method = 'CREDIT';

IF (Method= 'P') THEN Method = 'PAYPAL';

cards;   

A44730 5 C 140 10SEP18 14SEP18

B41373 1 C 35 08OCT18 17OCT18

A20919 12 P 220 18OCT18 25OCT18

C00099 2 C 47 30OCT18 03NOV18

B21013 4 P 82 11JAN19

D82908 6 P 168 11JAN19 15JAN19

;

run;

proc print data=orders;

format Order mmddyy10. Delivery mmddyy10.;

run;

PROC MEANS DATA=orders;

var Nitems WaitTime;

run;