hi all, The dataset orders gets created ,nothing's wrong my infile but my micro code not working.Anyone knows why,please? PS.at least for sysday=wed should work but it doesnot. And in additon to this can i use the second code below for the same purpose.Will it work.Can i use automatic macro variables within a sas code? options mprint; DATA orders; INFILE 'C:\Users\Trajce\Contacts\Desktop\Orders.txt'; INPUT CustomerID $ 1-3 OrderDate DATE7. Model $ 13-24 Quantity; RUN; %MACRO reports; %IF &SYSDAY = Monday %THEN %DO; PROC PRINT DATA = orders NOOBS; FORMAT OrderDate DATE7.; TITLE "&SYSDAY Report: Current Orders"; %END; %ELSE %IF &SYSDAY = WEDNESDAY %THEN %DO; PROC TABULATE DATA = orders; CLASS CustomerID; VAR Quantity; TABLE CustomerID ALL, Quantity; TITLE "&SYSDAY Report: Summary of Orders"; %END; %MEND reports; RUN; %reports RUN; second code: DATA orders; INFILE 'C:\Users\Trajce\Contacts\Desktop\Orders.txt'; INPUT CustomerID $ 1-3 OrderDate DATE7. Model $ 13-24 Quantity; IF &SYSDAY = Monday THEN DO; PROC PRINT DATA = orders NOOBS; FORMAT OrderDate DATE7.; TITLE "&SYSDAY Report: Current Orders"; END; ELSE IF &SYSDAY = WEDNESDAY THEN DO; PROC TABULATE DATA = orders; CLASS CustomerID; VAR Quantity; TABLE CustomerID ALL, Quantity; TITLE "&SYSDAY Report: Summary of Orders"; END; RUN;
... View more
