topic Re: informat& format help in SAS Programming

informat& format help

King — Tue, 01 Oct 2013 18:32:59 GMT

data step to read these data into three variables: Invoice, Amount, and Quantity.

12244 $1,499.99 144

32189 $20,000 1

92314 49.28 3

I have written the below code

data testrun;

input invoice amount quantity;

informat amount dollar9.2;

cards;

12244 $1,499.99 144

32189 $20,000 1

92314 49.28 3

;

run;

There is no errors in log but it is reading all observations.but it is not correct, What is the problem. Thanks for the help

Re: informat& format help

data_null__ — Tue, 01 Oct 2013 18:53:26 GMT

dollar9.0

Re: informat& format help

zqkal — Wed, 02 Oct 2013 13:53:07 GMT

Adding “$” in front of 49.28 for amount fix the problem. I think I you specify the dollar format all of you fields needs to have dollar($) sign.

data testrun;

input invoice

amount dollar9.2

quantity ;

format amount dollar9.2;

cards;

12244 $1,499.99 144

32189 $20,000 1

92314 $49.28 3

;

run;

proc print data=testrun;

run;

Re: informat& format help

data_null__ — Wed, 02 Oct 2013 14:00:46 GMT

A missing $ sign is NOT the problem. Do you think $20,000 is twenty thousand or $200.00?

Re: informat& format help

King — Wed, 02 Oct 2013 14:38:52 GMT

It's $20,000 twenty thousand

Re: informat& format help

Tom — Wed, 02 Oct 2013 14:40:09 GMT

What DATA_NULL_ is trying to point out is that for an INFORMAT the decimal part of the informat is the number of decimal places to apply when the value read does NOT contain a decimal point. When you specify dollar9.2 you are telling SAS to divide the 20,000 value by 100 in order to implement the implied decimal place.

Use dollar9.0 for the informat.