topic Re: Converting character text with hyphen to numeric in SAS Programming

Converting character text with hyphen to numeric

venkatagopinath — Sun, 03 Oct 2021 21:30:37 GMT

Hi,

I have data where the ID of the people are in character format and the data looks like this

840-02-001

840-02-002

840-02-003

Can you please suggest how to convert this text to numeric so that i can sort and also convert back to same character text. Since i cant sort the data with this id variable because it is character.

data id;

set name;

ptid =input(id,10.);

run;

Help to correct the code for reading character with Hyphen and converting to numeric for sorting.

Thanks

Re: Converting character text with hyphen to numeric

sbxkoenk — Sun, 03 Oct 2021 21:34:51 GMT

data have;
LENGTH ID $ 10;
input ID $ ;
cards;
840-02-001
840-02-002
840-02-003
;
run;

data want;
 set have;
 IDnum=input(compress(ID,'-'),10.);
run;
/* end of program */

Re: Converting character text with hyphen to numeric

ChrisNZ — Sun, 03 Oct 2021 22:29:59 GMT

> Since i cant sort the data with this id variable because it is character.

That's an odd comment. Why can't you?

Re: Converting character text with hyphen to numeric

venkatagopinath — Sun, 03 Oct 2021 23:03:04 GMT

Thank you

Re: Converting character text with hyphen to numeric

SASKiwi — Mon, 04 Oct 2021 00:12:50 GMT

Based on the data you have supplied the sort order will be the same if you compare a character sort with a numeric sort. Why bother converting?

Re: Converting character text with hyphen to numeric

ballardw — Mon, 04 Oct 2021 04:10:10 GMT

Why? Where are you going to perform arithmetic with ID values?

Your example doesn't show any likely problem with sorting, so provide a more complex example that did not sort the way you expect it to.

Proc sort has options like Sortseq with LInguistic and Numeric_Collation that allows you to override or specify some additional behaviors such as the numeric value instead of the default character order sort, ie "8 Main St" can come before "45 Main St".

Re: Converting character text with hyphen to numeric

Kurt_Bremser — Tue, 05 Oct 2021 08:22:29 GMT

There's no problem sorting character values:

data have;
length ID $ 10;
input ID;
cards;
840-02-001
840-02-002
840-02-003
;

proc sort data=have;
by id;
run;

Log:

 69         data have;
 70         length ID $ 10;
 71         input ID;
 72         cards;
 
 NOTE: The data set WORK.HAVE has 3 observations and 1 variables.
 NOTE:  Verwendet wurde: DATA statement - (Gesamtverarbeitungszeit):
       real time           0.00 seconds
       user cpu time       0.01 seconds
 
 76         ;
 77         
 78         proc sort data=have;
 79         by id;
 80         run;
 
 NOTE: There were 3 observations read from the data set WORK.HAVE.
 NOTE: The data set WORK.HAVE has 3 observations and 1 variables.
 NOTE:  Verwendet wurde: PROZEDUR SORT - (Gesamtverarbeitungszeit):
       real time           0.00 seconds
       user cpu time       0.00 seconds