Correction
I would prompt for a date, PromptDate, default today, then use it to build StartDate in the code:
%let StartDate="%sysfunc(
putn(%sysfunc( intnx(month,&PromptDate,-1,end) ),date9.)
)"d;
%put StartDate=&StartDate;
Colin
... View more
I would prompt for a date, DefaultDate, default today, then use it to build StartDate in the code:
%let StartDate="%sysfunc(
putn(%sysfunc( intnx(month,&PromptDate,-1,end) ),date9.)
)"d;
%put StartDate=&StartDate;
Colin
... View more
If your client is version 9 then you can use DUPOUT
data in;
do x=1 to 6; output; end;
do x=1 to 2; output; end;
run;
proc sort data=in out=out nodupkey dupout=dupes;
by x;
run;
Colin
... View more