LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 1998, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 18 May 1998 16:54:00 EDT
Reply-To:   jq5 <Jin_QIAN@UMAIL.UMD.EDU>
Sender:   "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:   jq5 <Jin_QIAN@UMAIL.UMD.EDU>
Subject:   Re: Data from IBM mainframe
Comments:   To: Wei Zhang <zhangw@CENTOCOR.COM>
In-Reply-To:   <>

>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.


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

Back to: Top of message | Previous page | Main SAS-L page