data WORK.URBANICITY;
infile datalines dsd truncover;
input Municipality:$36. urbanicity:COMMA15.;
format urbanicity COMMA15.;
label Municipality="Municipality" urbanicity="urbanicity";
datalines;
Seoul 605,569,314
   Jongno-gu 23,972,507
   Jung-gu 9,974,292
   Yongsan-gu 21,870,000
   Seongdong-gu 16,804,426
;;;;
Hope I got the guidance right. This is the data I'm dealing with.
Repeats of the same 3 characters is making me think that your actual data may be DBCS.
And perhaps the KCOMPRESS, KTRIM may be wanted.
@ballardw has nailed it. That's the reason, I have nicknamed him the "Cop"
You mean the function kcompress()?
The function kcompress() is MBCS-aware.
The function compress() is not, it just considers individual bytes.
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!
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.
Ready to level-up your skills? Choose your own adventure.