sas date - convert today() into yyyymmdd format

Question

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...

adam · Accepted Answer · 2017-08-09T16:53:06.393

26

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

edited Aug 09 '17 at 16:53

answered Jul 30 '09 at 15:54

adam

Umm. Maybe I'm doing something wrong, but format that works for me is: format test yymmddn8.; – pinegulf May 29 '17 at 12:12
Thanks @pinegulf, I updated the answer. Only took 8 years for someone to catch that! – adam Aug 09 '17 at 16:52

score 14 · Answer 2 · answered Aug 07 '09 at 19:41

%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.

Andy K · Answer 3 · 2014-08-05T12:46:18.787

3

There is this one that should do the trick too

%let today=%sysfunc(today(),yymmddn8.);
%put &today.;

Everything on the link below

edited Aug 05 '14 at 12:46

answered Aug 05 '14 at 10:22

Andy K

score 2 · Answer 4 · answered Jul 30 '09 at 14:57

2

here's how I did it in macro, but surely there must be a format??!!!

%let today=%sysfunc(compress(%sysfunc(today(),yymmddd10.),'-'));

its weird - the INFORMAT yymmdd8. gives YYYYMMDD result, whereas the FORMAT yymmdd8. gives a YY-MM-DD result!!

answered Jul 30 '09 at 14:57

Allan Bowe

score 0 · Answer 5 · answered Nov 11 '13 at 11:29

0

You can see all date and time formats in Help tab when you enter 'date' to Index tab and then selecr 'date and time formats'

answered Nov 11 '13 at 11:29

andrey_sz

5 Answers5