topic Creating a ddccmmyy macro in SAS Programming

Creating a ddccmmyy macro

EMC9 — Wed, 24 Jul 2013 09:42:46 GMT

I am currently trying to assign a Year macro that will show the year : like below

%let yr = year(&date.);

%let dag = day(&date.);

%let yydd = compress(&yr.||&dag.);

For e.g. NAME = D20130719

Thanks

arnouxvr — Wed, 24 Jul 2013 09:47:28 GMT

Hi Allistair,

Please try the following:

%let year = %sysfunc(year("&sysdate"d));

%let month = %sysfunc(putn(%sysfunc(month("&sysdate"d)),Z2.));

%let day = %sysfunc(putn(%sysfunc(day("&sysdate"d)),Z2.));

%let combined = D&year.&month.&day;

%put &combined;

EMC9 — Wed, 24 Jul 2013 09:50:50 GMT

Hi Arnoux

will try that out now.

Thank you!

Scott_Mitchell — Wed, 24 Jul 2013 10:13:29 GMT

You could also create a Picture Format.

PROC FORMAT ;

PICTURE DYYMMDD LOW-HIGH = "D"'%Y%0m%0d'

(DATATYPE = DATE) ;

RUN ;

%LET WANT = %SYSFUNC(PUTN("&SYSDATE."D,DYYMMDD.));

%PUT ************** &WANT.;

LOG:

SYMBOLGEN: Macro variable WANT resolves to D20130723

************** D20130723