topic Message "Data Set Limit Reached" in SAS Enterprise Guide

Message "Data Set Limit Reached"

WLP165 — Mon, 17 Aug 2009 19:40:17 GMT

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.

Re: Message "Data Set Limit Reached"

Doc_Duke — Tue, 18 Aug 2009 00:47:53 GMT

See this thread

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

Re: Message "Data Set Limit Reached"

ChrisHemedinger — Tue, 18 Aug 2009 18:32:10 GMT

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

Re: Message "Data Set Limit Reached"

Sergio_Mora0713 — Mon, 30 Mar 2020 20:12:55 GMT

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?

Re: Message "Data Set Limit Reached"

SASKiwi — Tue, 31 Mar 2020 19:33:27 GMT

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.

Re: Message "Data Set Limit Reached"

TomKari — Tue, 31 Mar 2020 20:11:33 GMT

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