topic How to Extract text from Date column in SAS? in SAS Programming

How to Extract text from Date column in SAS?

sas_newbie94 — Fri, 09 Oct 2020 10:04:33 GMT

Data is currently stored as date format, YYYYMM. However I would like to create a text column with just year and month. Meaning to say YYMM, I know this is not a good way to store data however I require it in that format. Meaning to say for YYYYMM = 201906, desired output = 1906. YYYYMM = 202006, desired output = 2006. YYYYMM = 200606, desired output = 0606.

data have;
infile datalines missover;
input yymm :yymmn6.;
format yymm yymmn6.;
datalines;
201904
201807
201912
202005
;

Re: How to Extract text from Date column in SAS?

Ksharp — Fri, 09 Oct 2020 11:00:59 GMT

data have;
infile datalines missover;
input yymm :yymmn6.;
format yymm yymmn6.;
want=cats(put(yymm,year2.),put(month(yymm),z2.));
datalines;
201904
201807
201912
202005
;

Re: How to Extract text from Date column in SAS?

PGStats — Fri, 09 Oct 2020 18:06:47 GMT

data have;
infile datalines missover;
input yymm :yymmn6.;
format yymm yymmn4.;
datalines;
201904
201807
201912
202005
;

proc print; run;

Re: How to Extract text from Date column in SAS?

Tom — Fri, 09 Oct 2020 19:28:48 GMT

If you just want to have the existing variable displayed without the century then just change the width of the format.

format yymm yymmn4.;

If instead want to create a character variable then use a PUT() function call.

desired_output = put(yymm,yymmn4.);