topic Re: Need to format date/time as YYYYMM in SAS Procedures

Need to format date/time as YYYYMM

mariearev — Tue, 02 May 2017 23:53:07 GMT

I looking to format a date/time field as an interger in the format of YYYYMM. Below works, but I cannot figure out how to remove the day part (DD). Thanks.

input(put(datepart(r.MyDate),yymmddn8.),8.) as MyDateFormatted format=8.

Example:

MyDate=10MAR2017:13:29:57.000

Need=201703 as numeric

Re: Need to format date/time as YYYYMM

Reeza — Wed, 03 May 2017 00:04:55 GMT

There's a format for that 😉

YYMMN6 Format, either apply the format or use PUT() with DATEPART().

data test;
 dt=dhms('01Jan2017'd, 5, 2, 20);
 format dt datetime20.;
 
 date_formatted=datepart(dt);
 format date_formatted yymmn6.;
 
 x=put(datepart(dt), yymmn6.);
 y=input(x, 8.);
run;

ods select variables;

proc contents data=test;
run;

proc print data=test;
run;

Re: Need to format date/time as YYYYMM

Jani_Pretorius — Mon, 12 Mar 2018 09:54:56 GMT

You can use the following format to convert a date to YYMM or YYYYMM. For example: 12-03-2018 to 201803:

put(r.MyDate, yymmn6.) as MyDateFormatted

See this link for more details:

http://support.sas.com/documentation/cdl/en/fedsqlref/67364/HTML/default/viewer.htm#n1d48aw39lluo9n1xdepexkarko1.htm