BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
arunrami
Pyrite | Level 9

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;

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

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

View solution in original post

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 723 views
  • 1 like
  • 2 in conversation