cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
cass5957
Calcite | Level 5 cass5957
Calcite | Level 5

How to make one date variable from three separate

Posted 10-11-2020 05:03 PM (1110 views)

I'm really struggling to make one date variable from three separate variables. For instance, I have "BirthYear", "BirthMonth", "BirthDay" as three separate variables, and I need to make them into one "BirthDate" variable. I'm really lost at how to even start this or what to try. Thank you!

0 Likes
Reply
1 REPLY 1
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: How to make one date variable from three separate

Posted 10-11-2020 05:06 PM (1106 views)  |   In reply to cass5957

In a DATA step

wanted_date=mdy(birthmonth,birthday,birthyear);
format wanted_date yymmdd10.;

 

--
Paige Miller
Reply

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Watch Mastering the WHERE Clause in PROC SQL on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎10-11-2020 05:03 PM
  • 1111 views
  • 1 like
  • 2 in conversation