topic Re: How do i convert SAS date9. to character monyyn6? in SAS Programming

How do i convert SAS date9. to character yymmn6?

imdickson — Wed, 05 Dec 2018 08:16:19 GMT

Hi. I currently have a dataset that contains date9. columns.

I want to convert it to yymmn6. in character. Is it do-able?

data date;
  input dates 8.;
  datalines;
01/02/2012
run;

i want it to be:

201202 in character.

PeterClemmensen — Wed, 05 Dec 2018 08:20:25 GMT

data test;
date="05dec2018"d;
format date date9.;

charDate=put(date, yymmn6.);
run;

r_behata — Wed, 05 Dec 2018 08:27:42 GMT

data have;
input dates :ddmmyy10.;
yymmn=put(dates,yymmn6.);
datalines;
01/02/2012
run;

Kurt_Bremser — Wed, 05 Dec 2018 08:33:11 GMT

Your data step creates missing values. Please test example data code before posting it here.

I guess you meant to do

data date;
input dates ddmmyy10.;
format dates date9.;
datalines;
01/02/2012
;
run;

From there you can apply the other's suggestion.