How to Extract text from Date column in SAS?

[sas_newbie94]

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
;

[Ksharp]

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
;

[PGStats]

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

proc print; run;

[Tom · Accepted solution]

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.);