topic Re: Picture Format in SAS Programming

Picture Format

ssafmed — Wed, 28 Dec 2022 19:35:18 GMT

Hi,

I want to use Picture FORMAT to have the output in file like : -0000000000.0000000000 (the first one is for sign(if it's positiv it last empty but if it's negativ it's -) and ten zeros then dot then ten 0 It's 22 in total)

I use this format but I get ERROR: Number of digit selectors (17)cannot exceed 16

picture ving
LOW-<0 = '9999999999.9999999999' (prefix='-')
0-HIGH = '9999999999.9999999999'
other = .
;

Like this :

Can u please help to solve this issue 🙂

Re: Picture Format

PaigeMiller — Wed, 28 Dec 2022 17:18:56 GMT

I think the error message is clear. You need to remove a digit somewhere. You can also try the BESTw.d format or the w.d format.

Re: Picture Format

sbxkoenk — Wed, 28 Dec 2022 17:20:40 GMT

Hello,

I'm afraid you have hit a limit on the number of digit selectors in a picture format.

ERROR: Number of digit selectors (17) cannot exceed 16.

Unfortunately 16 is the maximum number of digits you can have in a picture format.
This one is a precision thing. For numerics, SAS is only able to hold 16 digits (17 digits for EBCDIC machines), before precision is lost. So Proc Format was designed to reflect this.
Obviously, SAS can hold bigger numbers (eg format 24.2), which it stores internally in floating point.
Proc Format is for display, and you are limited to 16 displayable chars maximum.

Regards,
Koen

Re: Picture Format

Tom — Wed, 28 Dec 2022 18:00:36 GMT

How is that any different than using 23.10 format?

3504  data _null_;
3505    do x=0,1,-1,1E10,-1E10,1e-10,-1e-10;
3506      put x 23.10 +1 x= ;
3507    end;
3508  run;

           0.0000000000 x=0
           1.0000000000 x=1
          -1.0000000000 x=-1
 10000000000.0000000000 x=10000000000
-10000000000.0000000000 x=-10000000000
           0.0000000001 x=1E-10
          -0.0000000001 x=-1E-10

Or perhaps the Z23.10 format?

3509  data _null_;
3510    do x=0,1,-1,1E10,-1E10,1e-10,-1e-10;
3511      put x Z23.10 +1 x= ;
3512    end;
3513  run;

000000000000.0000000000 x=0
000000000001.0000000000 x=1
-00000000001.0000000000 x=-1
010000000000.0000000000 x=10000000000
-10000000000.0000000000 x=-10000000000
000000000000.0000000001 x=1E-10
-00000000000.0000000001 x=-1E-10
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

Re: Picture Format

ssafmed — Wed, 28 Dec 2022 18:18:01 GMT

What I need is this:

If it's positiv its empty

Thanks!

Re: Picture Format

Tom — Wed, 28 Dec 2022 19:42:26 GMT

So use a normal VALUE statement instead and combine it with the -R modifier on the format specification (ving22.-R).

Example:

3616  proc format cntlout=xxx ;
3617  picture ving (default=22 )
3618  LOW-<0 = [Z22.10]
3619  0-HIGH = [Z21.10]
3620  other = '           .          '
3621  ;
NOTE: Format VING is already on the library WORK.FORMATS.
NOTE: Format VING has been output.
3622

NOTE: The data set WORK.XXX has 3 observations and 21 variables.
NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


3623  data _null_;
3624    do x=0,1,-1,1E9,-1E9,1e-10,-1e-10;
3625      put x ving22.-r +1 x= ;
3626    end;
3627  run;

 0000000000.0000000000 x=0
 0000000001.0000000000 x=1
-0000000001.0000000000 x=-1
 1000000000.0000000000 x=1000000000
-1000000000.0000000000 x=-1000000000
 0000000000.0000000001 x=1E-10
-0000000000.0000000001 x=-1E-10
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

Re: Picture Format

ssafmed — Wed, 28 Dec 2022 20:22:15 GMT

Thanks!