topic Re: SAS Date Format in SAS Programming

SAS Date Format

psrajput — Thu, 30 Jul 2020 07:11:07 GMT

Hi,

I want the following sas date format: YYYY-MM-DD

Can someone help to achieve this?

Thanks.

Re: SAS Date Format

Kurt_Bremser — Thu, 30 Jul 2020 07:24:01 GMT

Two display formats exist that display SAS date values (counts of days, where 1960-01-01 is day zero) in this manner: YYMMDDD10. or E8601DA10.

If you have to start with something that looks like a date, but is not yet a SAS date value, please tell us the type (numeric or character) and the current format attached to the variable.

Re: SAS Date Format

psrajput — Thu, 30 Jul 2020 08:04:03 GMT

Thanks, I could not find it anywhere on the internet. And that's how bigquery takes a date variable.

Re: SAS Date Format

Kurt_Bremser — Thu, 30 Jul 2020 08:34:55 GMT

First, bookmark this link:

SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation

From there, open Data Step Programming to find the chapters dealing with Formats/Informats, Functions/Call Routines, and other DATA step related information. The Dictionary of Formats offers to find Formats by Category, so you get a place where to start looking for date formats.

Re: SAS Date Format

LeonidBatkhan — Thu, 30 Jul 2020 13:51:48 GMT

Hi KurtBremser, I think you mistyped the format YYMMDD10. as YYMMDDD10. (extra D). Isn't it?

Re: SAS Date Format

Kurt_Bremser — Thu, 30 Jul 2020 14:01:30 GMT

@LeonidBatkhan wrote:

Hi KurtBremser, I think you mistyped the format YYMMDD10. as YYMMDDD10. (extra D). Isn't it?

No. The extra "D" instructs SAS to use the dash as delimiter (default is a forward slash). See here.

Re: SAS Date Format

LeonidBatkhan — Thu, 30 Jul 2020 14:35:10 GMT

Hi KurtBremser,

Interesting. I run

data _null_;
   d='30jul2020'd;
   put d= yymmdd10.;
run;

(without extra d) and it gives me the date with hyphens:

d=2020-07-30

Apparently in the YYMMDDxw. Format default (when x is not present) is hyphen.

Re: SAS Date Format

Kurt_Bremser — Thu, 30 Jul 2020 16:40:22 GMT

You're right. I don't know how I came to use the YYMMDDD format; maybe I confused it with MMDDYY, where the slash is default.