sas automaticaly removes '-'

[ari]

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,

[Shmuel]

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

[Kurt_Bremser]

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

[ari · Accepted solution]

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

[Reeza]

@ari please mark the question solved. 

[RahulG]

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