Message "Data Set Limit Reached"

[WLP165]

I'm trying to import multiple CSV files into SAS datasets. After running the code in EG (v4.1), I get the following message:

"There were 106 data sets created, however only the first 50 data sets were added to the project."

Any ideas? All of the input CSV files appear complete, and the other SAS data set being referenced and used by the program appears complete.

[Doc_Duke]

See this thread

http://support.sas.com/forums/thread.jspa?threadID=2035

[ChrisHemedinger]

With EG 4.2, there is an option in Tools->Options to let you configure how many data sets to add to the project automatically. Default is still 50, but you can raise it or lower it (even to zero) if you want.

Chris

[Sergio_Mora0713]

Can you change this option in the code itself? I have this option where I am creating about 110 small tables. I can change my options but I will need someone else to run this for me eventually. How can I code for this?

[SASKiwi]

Unfortunately not. There is no limitation in your SAS session and you can't change EG settings with SAS code. It can only be done in EG itself. 

[TomKari]

One thing I do when I'm in a situation like this, if the scenario fits:

i) delete overall dataset

ii) in a macro, read in the data to a temp dataset, append to the overall dataset, delete the temp dataset

And then cycle the macro for all of the datasets. That way the single datasets that are input won't show up in the project.

Tom