topic Assign date9. to macro var in SAS Programming

Assign date9. to macro var

Dwight09 — Tue, 15 Nov 2011 22:14:47 GMT

%let dsin = test;

%let rc = %sysfunc(open(&dsin, I));

%if &rc % then %do;

%let cdate = %sysfunc(attrn(&rc, crdte));

%end;

Question is: How to get cdate in date9. format? This can be done using data null and call symput but I would like to know if can be done in above method?

Assign date9. to macro var

ballardw — Tue, 15 Nov 2011 22:49:19 GMT

What result are you currently getting for CDATE? That is likely to be OS dependent so we need to see what you have.

The likely solution will involve some form of %sysfunc(inputn or inputc depending, with a date informat. That would be inside a %sysfunc(putn({long expression},date9.)0;

Assign date9. to macro var

Peter_C — Tue, 15 Nov 2011 23:16:33 GMT

assuming internal value of &crdte is a sas date (#days since 1/1/1960)

%let date_constant = %sysfunc( putn( &crdte, date11 )) ;

* date11 looks even better than date9, and works just as well in:

where date_var <= "&date_constant"d

Assign date9. to macro var

Dwight09 — Tue, 15 Nov 2011 23:43:41 GMT

crdate value is 1636523977. Tried %sysfunc(putn(&crdate, date9.)) but not working. I get ********* [all asteriks]

Assign date9. to macro var

Reeza — Wed, 16 Nov 2011 01:09:45 GMT

You can do it with nested functions. sysfunc has a put by default so you don't need a putn either.

However your variable is actually a datetime variable not a date variable so you need to take the datepart of the datetime variable first, then do the format.

%let cdate=%sysfunc(datepart(%sysfunc(attrn(&rc, crdte))),date9.);

Assign date9. to macro var

Peter_C — Wed, 16 Nov 2011 10:52:04 GMT

at some point SAS formats were extended with a few prefixed DT - these are designed for datetime values.

When extracting just the date part of "created date", we don't need the datepart() function, just DTDATE9

%let cdate= %sysfunc(attrn(&rc, crdte),DTdate9 );

Assign date9. to macro var

ballardw — Wed, 16 Nov 2011 19:10:16 GMT

When I tried a DATETIME16. format with that value of 1636523977 for cdate I get 10NOV11:05:59:37. Does that look like the correct date for your example? If so you want the DATEPART of CDATE.