topic Re: sas automaticaly removes '-' in SAS Programming

sas automaticaly removes '-'

ari — Fri, 26 Aug 2016 10:17:52 GMT

Hi,

I am sorting a dataset with id's

Have:

BR01-999-1001-002

BR01-999-1045-004

when i sort them, in the output the ids look like,

BR01-999-1001002

BR01-999-1045004

Any way the sort the data while keeping Ids as such in the input dataset??

Thanks,

Re: sas automaticaly removes '-'

Shmuel — Fri, 26 Aug 2016 10:23:58 GMT

Check the format and the format length (how many digits) has the ID variable.

Re: sas automaticaly removes '-'

Kurt_Bremser — Fri, 26 Aug 2016 10:30:19 GMT

Post your code.

data have;
input key $17.;
cards;
BR01-999-1001-002
BR01-999-1045-004
;
run;

proc print noobs;
run;

proc sort
  data=have
  out=want
;
by key;
run;

proc print noobs;
run;

gives this result

        key

 BR01-999-1001-002
 BR01-999-1045-004
                   

        key

 BR01-999-1001-002
 BR01-999-1045-004

Re: sas automaticaly removes '-'

ari — Fri, 26 Aug 2016 10:34:58 GMT

this was an issue due to source dataset. thanks for the help though

Re: sas automaticaly removes '-'

RahulG — Fri, 26 Aug 2016 10:37:45 GMT

Check data in the input data set. It might have read incorrectly while reading from source

Re: sas automaticaly removes '-'

Reeza — Fri, 26 Aug 2016 10:54:27 GMT

@ari please mark the question solved.