Dear SASians,
I am trying to create a new variable in proc report using compute block which should do the type conversion(Numeric to character) but at the end in result I am getting irrelevant symbols(***) as shown below . Please help to sort it out.
data A;
start_time= '11JUN2011:02:45'dt;
run;
proc report data=A out=B;
col start_time dummy;
define start_time/display ;
define dummy/computed;
compute dummy/character length=20;
dummy = put(start_time,date9.);
endcomp;
run;
You cannot put() a datetime number into a date format.
dummy = put(datepart(start_time),date9.);
You cannot put() a datetime number into a date format.
dummy = put(datepart(start_time),date9.);
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.