topic Re: converting date YYYY-MM to YYYY_DD in SAS Programming

converting date YYYY-MM to YYYY_DD

dht115 — Wed, 26 Jan 2022 14:15:24 GMT

Hello,

I need date format to YYYY_DD.

So far I was able to get the date format in YYYY-DD by using following code:

/*yymmd7. format - YYYY-DD*/
%let today2 = %sysfunc(today(),yymmd7.);
%put &today2.;

Result: 2022-01

Need:

Result: 2022_01

Re: converting date YYYY-MM to YYYY_DD

PaigeMiller — Wed, 26 Jan 2022 14:26:52 GMT

You would have to create a custom format using the PICTURE command in PROC FORMAT.

Example: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p1717ykol58oijn13lw9rs30lhn0.htm

Re: converting date YYYY-MM to YYYY_DD

PeterClemmensen — Wed, 26 Jan 2022 14:32:17 GMT

See if you can use this as a template

proc format; 
  picture dtfmt (default = 30)
    other = '%Y_%0m' (datatype=date)
  ;
run;

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

Re: converting date YYYY-MM to YYYY_DD

BrunoMueller — Wed, 26 Jan 2022 15:42:14 GMT

I assume by YYYY_DD you mean year_month

The code below uses the NLDATE function to build the string your are after. When you have nested DATA Step functions, each function needs its own %SYSFUNC. The %NRSTR macro function avoids warning messages.

/*yymmd7. format - YYYY-DD*/
%let today2 = %sysfunc(nldate(%sysfunc(today()),%nrstr(%Y_%m)));
%put &today2.;