BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Cruise
Ammonite | Level 13

@ballardw 

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. 

ballardw
Super User

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.

novinosrin
Tourmaline | Level 20

@ballardw  has nailed it. That's the reason, I have nicknamed him the "Cop"

Cruise
Ammonite | Level 13

 

@ballardw kcomp.png

You hit the nail on the head! kcomp it is. Hurray!

ChrisNZ
Tourmaline | Level 20

Searching for   ã€€   brings up   ã€€ 文字化け

So MBCS indeed.

Cruise
Ammonite | Level 13
Why then kcomp would have worked out?
ChrisNZ
Tourmaline | Level 20

You mean the function kcompress()?

The function kcompress() is MBCS-aware. 

The function compress() is not, it just considers individual bytes.

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 21 replies
  • 3357 views
  • 7 likes
  • 6 in conversation