topic Re: Macro code in SAS Programming

Macro code

deleted_user — Wed, 01 Dec 2010 21:25:35 GMT

Hi,

I need to create a monthly report. For that i have created a macros,

data _null_;
call symput ('begindt',intnx('MONTH',today(),-4));
call symput ('enddt',intnx('MONTH',today(),-3));
call symput ('rdate',put(today(),date9.));
run;

If run this code , %put &begindt ; am getting SAS date.
If i want to see in ddmmyyyy means how to convert the code ?

Pls anyone let me know..

Thanks,
sudha

Re: Macro code

ArtC — Wed, 01 Dec 2010 21:48:40 GMT

Use %SYSFUNC with the PUTN function.
[pre]
%let begindt = 18234;
%put %sysfunc(putn(&begindt,ddmmyy10.));[/pre]

Re: Macro code

deleted_user — Wed, 01 Dec 2010 22:04:14 GMT

Hi ,

Thanks for your reply...
But if i ran that syntax

%put %sysfunc(putn(&begindt,ddmmyy10.));

am getting an output as 01/01/1960..

But i need to get an output as 09/01/2010.

please let me know..

Thanks,
sudha

Re: Macro code

SPR — Wed, 01 Dec 2010 22:16:08 GMT

Hello Sudcha,

I tried ArtC's suggestion on my computer. This code works as expected:
[pre]
data _null_;
call symput ('begindt',intnx('MONTH',today(),-4));
run;
%put begindt=%trim(&begindt);
%put %sysfunc(putn(&begindt,ddmmyy10.));
[/pre]
Sincerely,
SPR

Re: Macro code

deleted_user — Wed, 01 Dec 2010 22:27:20 GMT

Yes am getting an exact output what am expecting !!

Thank you !!!

Re: Macro code

PatrickG — Mon, 13 Dec 2010 14:09:35 GMT

You can find out more about using SAS dates here. I hope this helps.

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a002200738.htm