[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Maximum number of (in)formats reached
From:       "Martin, Vincent (he | il) (StatCan)" <000012ceea78ff2b-dmarc-request () LISTSERV ! U
Date:       2024-04-11 14:16:08
Message-ID: YT3PR01MB103138AE9F5ED5D624BE9713ECC052 () YT3PR01MB10313 ! CANPRD01 ! PROD ! OUTLOOK ! COM
[Download RAW message or body]

You should be able to use sashelp.vcolumn for the OP's goal.

It has a variable order in the file structure variable and presence of format/name of \
format IIRC.



Vincent Martin

Senior Methodologist - Statistical Integration Methods Division, Analytical Studies, \
Methodology and Statistical Infrastructure Field Statistics Canada / Government of \
Canada vincent.martin@canada.ca / Tel: 613-853-7135

Méthodologiste principal - Division des méthodes d'intégration statistique, Secteur \
des études analytiques, de la méthodologie et de l'infrastructure statistique \
Statistique Canada / Gouvernement du Canada vincent.martin@canada.ca / Tél. : \
613-853-7135


-----Original Message-----
From: SAS(r) Discussion <SAS-L@LISTSERV.UGA.EDU> On Behalf Of Richard
Sent: Wednesday, April 10, 2024 3:29 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Maximum number of (in)formats reached

Hi Chris
Did you ever come up with a simple solution for ? We have just created a Redcap \
survey with ~6000 variables and struck this issue. Thanks
Richard

On Tue, 30 Apr 2013 07:44:43 -0400, Christopher Battiston <darth.pathos@GMAIL.COM> \
wrote:

> Good morning all,
> 
> One of my responsibilities in my day-to-day job is to support and 
> assist users in REDCap, an online MySQL Database developed and 
> supported by Vanderbilt 
> (https://can01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fproje
> ct-redcap.org%2F&data=05%7C02%7Cvincent.martin%40STATCAN.GC.CA%7Cb7efeb
> 3adf664160b92a08dc592ffcf9%7C258f1f99ee3d42c7bfc57af1b2343e02%7C0%7C0%7
> C638483309851015961%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJB \
> TiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=YMjw5bof%2BkCri27SikqeuuEexCKUuk%2BcRq2VoPBzEDY%3D&reserved=0). \
> With REDCap you can export to any number of formats, including SAS.  Three files \
> get created - a File Mapper (a basic batch file that tells SAS where to find the \
> data and SAS File), a CSV with the data, and then a SAS file that creates the \
> formats, imports the data, etc. 
> The problem we're having is that our project has over 10,000 variables, 
> and when I try and run the SAS file, I get
> 
> Error 81-59: Limit of 4096 formats or informats in use in a single step 
> has been exceeded.
> 
> Is there anything I can do other than somehow figuring out where the 
> 4095th (in)format is and creating a 2nd / 3rd step?
> 
> Thanks
> Chris
> 
> --
> View my Gift of 8 Campaign: 
> https://can01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fbeadon
> or.ca%2Fchristopher-battiston&data=05%7C02%7Cvincent.martin%40STATCAN.G
> C.CA%7Cb7efeb3adf664160b92a08dc592ffcf9%7C258f1f99ee3d42c7bfc57af1b2343
> e02%7C0%7C0%7C638483309851024185%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLj
> AwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata
> =cye5CltBpzKcP4bNlPYAnx9scerxAex20g%2Fzm5%2BVPiw%3D&reserved=0


[prev in list] [next in list] [prev in thread] [next in thread]