Date:         Fri, 5 Sep 2008 19:02:56 -0400
Reply-To:     Bucher Scott <SBucher@SCHOOLS.NYC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bucher Scott <SBucher@SCHOOLS.NYC.GOV>
Subject:      Re: proc datasets with many variables
Comments: To: M D <tant07@GMAIL.COM>
In-Reply-To:  A<8a8f77ab0809051552j69490ac0hc00c88ad2eb4fffe@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

Try using a single format statement, i.e.

proc datasets library = jack;
modify data0204;
format
        q1 q1.
        q2 q2.
        q3 q3.
      ;
quit;
run;

Regards,
Scott

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of M D
Sent: Friday, September 05, 2008 6:52 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: proc datasets with many variables

Hello,

I am trying to modify the format of the variables of a dataset. First I
run
a proc format to set the format of the variables and then I run proc
datasets.

*

proc **datasets* library = jack;

modify data0204;

format q1 q1.;

format q2 q2.;

.....
quit;
run;

Unfortunately, I have more than 4096 format statements that are trying
to
process at the same time and thus, I am getting the following error
message.


119803 format q1 q1.;

ERROR: Limit of 4096 formats or informats in use in a single step has
been
exceeded.

What can I do to avoid this error.

Many thanks in advance,

Mike.