>Hi SAS experts: > >I got a data set from IBM mainframe. One of the variables has a ending = >letter representing a sign. I used character string to input that = >variable and some of the values are like: > >00000174P >00000100} >00000187M >00000225J > >Can somebody tell me how to convert those letters and '}' into meaningful = >signs?=20 >Thank you very much. > =20

Zhang Wei:

The data format is called Zoned Decimal Digit. You can use ZDw.d informat to read. For example, if your data has two digit for decimal, you can use ZD9.2 to read.

data one; input x ZD9.2 cards; 00000174P 00000100} 00000187M 00000225J 00000100} 00000187M 00000225J ; proc print; run;

This will give you the following output.

OBS X

1 -17.47 2 -10.00 3 -18.74 4 -22.51 5 -10.00 6 -18.74 7 -22.51

Hope this helps.

Jin Qian Comsys Technical Services, INC. Rockville, MD