Compute block for type conversion

arunrami — Fri, 22 Feb 2019 11:47:00 GMT

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;

Re: Compute block for type conversion

RW9 — Fri, 22 Feb 2019 12:13:14 GMT

You cannot put() a datetime number into a date format.

dummy = put(datepart(start_time),date9.);

topic Re: Compute block for type conversion in SAS Programming

Compute block for type conversion

Re: Compute block for type conversion