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?
I have also tried putting format newperiod yymmn6. but the field is entirely blank.
Do like this
data test;
charyear='JAN2018';
newperiod=input(charyear,monyy7.);
format newperiod yymmn6.;
run;
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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.