topic Re: Converting Character Date to DATE yymmn6. failed in SAS Programming

Converting Character Date to DATE yymmn6. failed

imdickson — Thu, 06 Dec 2018 09:54:53 GMT

Hi everyone. I am trying to onvert character date(MONYY) to DATE type yymmn6.

Here is my code:

data work.trans_load_re_oldfull;
set work.trans_load_re_oldfull;
    length newperiod $8.;
    charyear='JAN2018';
	newperiod=input(_NAME_,best.);

run;

Nothing came out. Anyone knows why?

Re: Converting Character Date to DATE yymmn6. failed

imdickson — Thu, 06 Dec 2018 10:04:08 GMT

I have also tried putting format newperiod yymmn6. but the field is entirely blank.

Re: Converting Character Date to DATE yymmn6. failed

PeterClemmensen — Thu, 06 Dec 2018 10:05:36 GMT

Do like this

data test;
   charyear='JAN2018';
   newperiod=input(charyear,monyy7.);
   format newperiod yymmn6.;
run;

Re: Converting Character Date to DATE yymmn6. failed

Kurt_Bremser — Thu, 06 Dec 2018 10:17:50 GMT

First of all: do not overwrite a dataset in the same data step while you're still developing; any mistake will force you to recreate the dataset from its origins.

data work.trans_load_re_oldfull;
set work.trans_load_re_oldfull;
    length newperiod $8.;
    charyear='JAN2018';
	newperiod=input(_NAME_,best.);

run;

You are setting charyear, but don't use it.

You define newperiod as character, and then assign a numeric value to it, forcing an automatic type conversion. Bad.

Is _NAME_ present on your dataset? If yes, is it of type character? If yes, what does it contain?