LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 5 Sep 2008 21:24:32 -0400
Reply-To:   Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:   Re: proc datasets with many variables
Comments:   To: John Hans <tant07@GMAIL.COM>


You could always run proc datasets via a couple of macros, each limited to 4096 or fewer formats. For example:

%macro doit1; proc datasets library = jack; modify data0204; %do i=1 %to 4096; format q&i. q&i._.; %end; quit; %mend; %doit1

%macro doit2; proc datasets library = jack; modify data0204; %do i=4097 %to 5000; format q&i. q&i._.; %end; quit; %mend; %doit2

HTH, Art -------- On Fri, 5 Sep 2008 17:52:05 -0500, M D <tant07@GMAIL.COM> wrote:

>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.

Back to: Top of message | Previous page | Main SAS-L page