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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.