BookmarkSubscribeRSS Feed
kbone1975
Fluorite | Level 6

I am trying to convert a calculated date with a YYMMD7. format to a CHAR format in a proc sql where clause. The table I am selecting from has a text date column (2018-01). I have tried using put(date, CHAR7.) and get an error. Is there something else I can do to make this work?  

2 REPLIES 2
Ksharp
Super User
data _null_;
x=put(today(),yymmd7.);
put x=;
run;
kbone1975
Fluorite | Level 6

This worked perfectly-thanks!

 

 

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
  • 2 replies
  • 2415 views
  • 1 like
  • 2 in conversation