topic Date YYMMDD in SAS Enterprise Guide

Date YYMMDD

Jyuen204 — Thu, 19 Aug 2021 13:07:18 GMT

Looked up in SAS for dates. I Want it in a YYMMDD fields and the closes i found was the format below. However it generates the dat with dashes
where I would want it like 120317

YYMMDD.

19069

12-03-17

Re: Date YYMMDD

PaigeMiller — Thu, 19 Aug 2021 13:11:50 GMT

Try format YYMMDDN6.

Do a smart thing and use four digit years, which would be YYMMDDN8.

Re: Date YYMMDD

Ksharp — Thu, 19 Aug 2021 13:13:00 GMT

Pick the right format:

data _null_;
date=date();
put date yymmddn6.;
run;

Re: Date YYMMDD

Reeza — Thu, 19 Aug 2021 15:28:44 GMT

Format right after that one in the documentation.
Very good page to bookmark
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/leforinforref/n0p2fmevfgj470n17h4k9f27qjag.htm

Re: Date YYMMDD

ballardw — Thu, 19 Aug 2021 16:56:25 GMT

You need to very carefully label things in examples. You may not be aware but in one form 19069 could be 10 March 2019 (Julian date notation; or could be 1919, 1819,2119 for the year, 2 digit years are such a pain to keep straight).

Re: Date YYMMDD

Jyuen204 — Thu, 19 Aug 2021 17:00:52 GMT

Thank You! I would normally do the full on year. I am just migrating a legacy solution over to SAS so changing the format is not required.