topic Re: plz cnvrt into days in SAS Programming

plz cnvrt into days

anitapamu2 — Wed, 08 Apr 2015 10:37:51 GMT

data _null_;
td=today();
*td='18jul2014'd;
bgn_date=intnx('month',td,0,'b');
end_date=intnx('month',bgn_date,0,'e');
prev2mth=intnx('month',td,-2,'s');
call symput('As_of_dte',put(td,yymmdd8.));
call symput('As_of_dt',put(td,yymmdd10.));
call symput('As_of_dte1',put(td-1,yymmdd8.));
call symput('month_begin',put(bgn_dte,yymmdd10.));
call symput('month_end',put(end_dte,yymmdd10.));
call symput('month_stamp',put(bgn_date,yymmn6.));
call symput('prev2mth',put(prev2mth,yymmddn8.));
run;

Re: plz cnvrt into days

RW9 — Wed, 08 Apr 2015 10:41:38 GMT

Hi,

Sorry, am not following. Please provide test data, as a datastep, and required output.

Re: plz cnvrt into days

ballardw — Wed, 08 Apr 2015 15:45:10 GMT

Note: All SAS date values are days since 1 Jan 1960. So they are already "days".

You can get day of the month with the DAY function.

You can get day of the year using Juldate and Mod functions.