Hello,
I'n new in SAS and I have simple question.
I have two columns
1. DATE
2. TEXT
For bussiness purposes I need to join this two columns into enother one the format should look like: TEXT "\" YYYY-MM-DD
Any suggestions?
If your date varaible is a sas date variable then this should work:
data want;
set have;
length newtextvar $ 50 ; /* the lenght here should be a least large enought to take the longest text value plus 12 characters.
newtextvar = catx('\',text, put(date, yymmddD10.);
run;
If the date is not currently a SAS date valued numeric then a conversion will be needed to create one.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.