I suspect I have hidden character '0A'X, 'M' in the variable. When I sort and put id on this variable, SAS thinks the same value(to me) are different. How to find out and change this hidden characters? The program I run is
proc sort data = meds_new2
out = meds_new3;
by All_Managers;
run;
data meds_new4;
set meds_new3;
by All_Managers;
if first.All_Managers then count + 1;
run;
and the output I got is:
thank you for your help.
I suspect I have hidden character '0A'X, 'M' in the variable. When I sort and put id on this variable, SAS thinks the same value(to me) are different. How to find out and change this hidden characters? The program I run is
proc sort data = meds_new2
out = meds_new3;
by All_Managers;
run;
data meds_new4;
set meds_new3;
by All_Managers;
if first.All_Managers then count + 1;
run;
and the output I got is:
thank you for your help.
If you know what the hidden character is, getting rid of it is easy:
all_managers = compress(all_managers, '0A'x);
If you don't know what the hidden character is you can find it with:
data temp;
set have;
all_managers = compress(all_managers, , 'ad');
run;
proc freq data=temp;
tables all_managers;
format all_managers $hex30.;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: