topic Re: PDx format in SAS Programming

PDx format

alepage — Tue, 08 Dec 2020 17:20:33 GMT

Hello,

Does someone know how many significant digits do we have using a PD.6 format.

Could it be possible to get a table showing the number of significant digits for each PD.x format.

Regards,

Re: PDx format

ballardw — Tue, 08 Dec 2020 17:24:38 GMT

Digits or significant digits? Not the same thing. The significant digits are use specific.

The W is the number of BYTES in the output, and each byte has two digits. So PD6. = 12 digits.

Re: PDx format

alepage — Tue, 08 Dec 2020 17:49:04 GMT

Thank you very much for the precision.

So it means that if we use a PD6 format , we can have any number between 0 and 999 999 999 999.

What will happen if the number is bigger then 999 999 999 999?

Regards,

Re: PDx format

Kurt_Bremser — Tue, 08 Dec 2020 17:59:41 GMT

Try it:

length checkvar $12;
checkvar = put(put(1234567123456,pd6.),$hex12.);

Re: PDx format

alepage — Tue, 08 Dec 2020 18:55:08 GMT

I though that PD6 could take 12 digits. It is not the case?

/*11 digits*/
data test;
length checkvar $12;
checkvar = put(put(12345671234,pd6.),$hex12.);

/*10 digits*/

length checkvar1 $12;
checkvar1 = put(put(1234567899,pd6.),$hex12.);
run;

Re: PDx format

ballardw — Tue, 08 Dec 2020 23:45:25 GMT

You are not starting with a packed decimal value.

Re: PDx format

Kurt_Bremser — Wed, 09 Dec 2020 10:33:34 GMT

I ran this test:

data test;
length checkvar $12;
input number;
checkvar = put(put(number,pd6.),$hex12.);
datalines;
123456789
-123456789
1234567890
-1234567890
12345678901
123456789012
1234567890123
;

proc print data=test;
run;

and got this result:

Beob.      checkvar             number

  1      000123456789        123456789
  2      800123456789       -123456789
  3      001234567890       1234567890
  4      801234567890      -1234567890
  5      009999999999      12345678901
  6      009999999999     123456789012
  7      009999999999    1234567890123

So it can be seen that a full byte is reserved for the (possible) sign. This behavior is described in the OS-specific documentation of the PD format:

UNIX

Windows