sas date - convert today() into yyyymmdd format

Asked 2009-07-30T14:48:58.153

How do I convert a SAS date such as "30JUL2009"d into YYYYMMDD format (eg 20090730)?

So for instance:

data _null_;
  format test ?????;
  test=today();
  put test=;
run;

Would give me "test=20090730" in the log...

date format sas

Edit Report

2 Answers

data _null_;
    format test yymmddn8.;
    test=today();
    put test=;
run;

answered 2009-07-30T15:54:14.360

%let expectdate1=%sysfunc(putn(%eval(%sysfunc(today())-1),yymmddn8.));

You want to use the format yymmddn8. The 'n' means no separator.

Per http://support.sas.com/kb/24/610.html you can specify B for blank, C for colon, D for dash, N for no separator, P for period, or S for slash.

answered 2009-08-07T19:41:39.963