topic Re: Displaying date in YYYYMMDD format in SAS Software for Learning Community

How do I display data in YYYYMMDD format?

opoudyal0 — Mon, 07 May 2018 14:45:26 GMT

How do I display date in the YYYYMMDD format? Like 1960/02/21.

Re: Displaying date in YYYYMMDD format

Kurt_Bremser — Thu, 19 Jan 2017 06:07:09 GMT

The yymmdd format is what you are looking for.

data test;
datevar = date();
format datevar yymmdd10.;
run;

Re: Displaying date in YYYYMMDD format

Astounding — Thu, 19 Jan 2017 11:20:34 GMT

I can't test it right now, but you should be able to control the separator as well:

format datevar yymmdds10.;

format datevar yymmddd10.;

s = slash

d = dash

Re: Displaying date in YYYYMMDD format

Kurt_Bremser — Thu, 19 Jan 2017 12:05:02 GMT

@Astounding wrote:

I can't test it right now, but you should be able to control the separator as well:

format datevar yymmdds10.;

format datevar yymmddd10.;

s = slash

d = dash

The default separator for the YYMMDD format is the dash or hyphen.

Possible separators for the extended version of the format (as @Astounding posted) are

n no separator

b blank

d dash

s slash

p period

c colon

Re: Displaying date in YYYYMMDD format

opoudyal0 — Thu, 19 Jan 2017 20:47:29 GMT

What about if my date is a character variable and not numeric? For example: I have 11/5/1969 read in as character and I need to change it to the YYYYMMDD format.

Re: Displaying date in YYYYMMDD format

Kurt_Bremser — Thu, 19 Jan 2017 21:05:51 GMT

Depending on the format, do

datvar = input(stringvar,ddmmyy10.);

datvar = input(stringvar,mmddyy10.);

Re: Displaying date in YYYYMMDD format

Astounding — Thu, 19 Jan 2017 21:09:34 GMT

If you want to continue to use the same variable name, you need to output the result as character. For example:

datevar = put ( input(datevar, mmddyy10.), yymmdds10. );