Dear SAS Community:
Dataset T created by submitting following SAS code.
data T; acnum=5041; min_ac_dt='01Jan2000'd; max_ac_dt='01Jun2010'd; format min_ac_dt max_ac_dt DATE9.; run;
I need to create additional column "Range_Values" as shown in the attached "sample_output.png" file.below.
I am trying with this macro...no luck yet:
%macro date_loop(start,end); %let start=%sysfunc(inputn(&start,anydtdte9.)); %let end=%sysfunc(inputn(&end,anydtdte9.)); %let dif=%sysfunc(intck(month,&start,&end)); %do i=0 %to &dif; %let date=%sysfunc(putn(%sysfunc(intnx(month,&start,&i,b)),yymmp10.)); %put &date; %end; %mend; %date_loop(01jan2000,01jun2010);
... View more