converting a zonal decimal to numeric in SAS

mambopras · New User Joined: 11 Nov 2008 Posts: 52 Location: Hyderabad

Hi,
I have a requirement in SAS to read a variable which is a zonal decimal of ZD14.2 and put it in the output as a numeric which can be a max of 9 digits (including decimal if any)
Example - if the value in the input file is
00000002130}00000

I need i is 213.00 or just 213 (with a leading sign if negative).

I have been trying SAS formats but was not successful. Can anyone please help me with this ?

enrico-sorichetti · Posted: Sat May 28, 2011 12:46 am

before posting it would be wise to review Your understanding of numeric data representation and the relative terminology
as described in
z/Architecture Principles of Operation
publibfp.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dz9zr002/CCONTENTS
here
publibfp.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dz9zr002/8.1?DT=20030424140649

after reading You will understand why the example You posted is not a valid number

Robert Sample · Posted: Sat May 28, 2011 1:05 am

Okay, you tell us you have a ZD14.2 SAS value, give us 17 digits, and the value is stored in just the first 12 digits -- obvious due to the sign overlay in the 12th position. I think your first, and most obvious problem, is that YOU HAVE NO IDEA WHAT YOU ARE DOING!

Assuming you really meant 12.2 and not 14.2, why not

Phrzby Phil · Posted: Sat May 28, 2011 6:17 am

Your subject also makes no sense.

Zoned decimal, packed decimal, pure binary (aka binary), and a few others are all numeric, just coded differently.

dick scherrer · Posted: Sat May 28, 2011 8:08 am

Hello,

Why do you believe that 00000002130}00000 is a zonal decimal of ZD14.2

This part of the value 00000002130} meets the rules for a signed, zoned decimal with a value of 213.00.

Suggest you review what you actually "have" and what you want to do with this. Hint: how is the output value to be used?

mambopras · New User Joined: 11 Nov 2008 Posts: 52 Location: Hyderabad

Well, apologies for my earlier 'not properly' framed question and confusion over terminology.

Requirement :I have an existing SAS program in production that reads an amount field having values like 0000000002130{ from an input file into a variable of ZD14.2. This variable wasn't moved to the out put field earlier. Now, I need to move it into the output such that it gets displayed as 213.00 (Truncating the leading zeros). I tried using NO DOLLAR9.2 etc...but could not get the amount displayed as required.

So what should be the declaration of the variable in the PUT statement was the question I intended to ask - But I couldn't convey that earlier.

The output is used as a report. However, we couldn't use PROC PRINT (which could have taken care of this issue) to generate report as our requirements made us code everything manually due to the extra customization the client wanted.

I hope this explanation is better than the earlier. Can you help me out with this ?

Bill Woodger · Posted: Sat May 28, 2011 3:49 pm

Try looking up COMMA or D in the manual, see if either give you what you want.

PeterHolland · Posted: Sat May 28, 2011 3:57 pm

put @x value 14.2;

mambopras · New User Joined: 11 Nov 2008 Posts: 52 Location: Hyderabad

Peter I tried that way but the leading zeros are not being truncated.
Bill : I tried a NO DOLLAR14.2. It seems to work ok. I would have to do more testing.

Thanks a lot to all of you for your responses and help.

PeterHolland · Posted: Sat May 28, 2011 4:22 pm

And this one ? :

char=put(value,14.2);

mambopras · New User Joined: 11 Nov 2008 Posts: 52 Location: Hyderabad

Peter, I need to try this!!!