data test2;
first = 'Ipswich, England';
city = substr(first,1,7);
city_country = city||', '||'England';
run;
how come city_country = 'Ipswich , England'?
where did the space between 'Ipswich' and the comma come from?
Thank you!
What length did you expect that the SAS would use to create the variable CITY ? It makes it length $16 since the variable FIRST was defaulted to $16 based on the length of the string literal first assigned to it. Hence there are 11 spaces at the end of the variable after the 7 that you populated with the SUBSTR() function call.
Use CATS or CATX function instead to have SAS strip the spaces off the end of the variable.
data test2;
first = 'Ipswich, England';
city = substr(first,1,7);
city_country = city||', '||'England';
fix = catx(', ',city,'England';
put (_all_) (/ $quote.);
run;
"Ipswich, England"
"Ipswich"
"Ipswich , England"
"Ipswich, England"
NOTE: The data set WORK.TEST2 has 1 observations and 4 variables.
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.