BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dude12345
Calcite | Level 5

I am fairly new in SAS and SAS EG. I am experiencing a problem that is extremely perplexing.

No matter what I do, my queries that are supposed to generate individual tables continue to join automatically. And they are not even joining in the way that you would actually join tables. Each subsequent query just connects itself to my first query output table and overwrites the tables content. It is hard to explain, bu the picture i attached might better explain.

In it, you will see, I set up the queries which separate the original data set based on disease category, i.e. skin diseases, musculoskelatal diseases, etc.

The queries at the bottom are set up identical to the ones above that generated new, separate, tables. Unfortunately when I run the ones at the bottom, they all just connect themselves to the one new data set farthest to the right and replace the data entirely with the data that should have been generated as a new separate table. 

I am wondering if there is a limit on the number of queries that one EG project can contain, rite now this project has about 25-30, or maybe a limit on the number of SAS tables it can contain, which is again around 25-30 rite now as the project stands.

I brought the original dataset into a new EG project though, and I experienced the same problems. I am confused and frustrated. I tried to run the code from the query as a program, and it did the same thing.

I do not believe it to be a problem with the original data set because, or a specific disease category that I am filtering by because If I delete the output from one of the earlier disease groups, then try to run one of the ones at the bottom, it runs fine, and then if I re-run the one at the top, the problem re-occurs at this location in the project.

If ANYONE understands what I am trying to convey, or has experienced this problem before and knows a solution , please let me know. Any help would be greatly appreciated.


EG_Query_Help.PNG
1 ACCEPTED SOLUTION

Accepted Solutions
Fugue
Quartz | Level 8

Check the output data set names on each of the query objects. (Select the object, right-click, select Properties, then Results). Check the Name of the output data set. You can manually change the name by clicking on Change.

View solution in original post

6 REPLIES 6
ballardw
Super User

Can you show the code of the query?

dude12345
Calcite | Level 5

Where I work, SAS runs in a virtual machine. I can copy and paste things INTO the virtual machine, but it does not allow me to copy and past OUT of the virtual machine.

So, I took a screenshot of the code. each query is idential except for the last part WHERE t1.Category = "_________" The one shown is for Diseases of the Circulatory System, but each query identifies a different disease group.

Any Ideas?EG_Query_Help1.PNG

And did you look at the attached image from the original post?

Fugue
Quartz | Level 8

Check the output data set names on each of the query objects. (Select the object, right-click, select Properties, then Results). Check the Name of the output data set. You can manually change the name by clicking on Change.

dude12345
Calcite | Level 5

The Change box is greyed out, so I cannot click it. However, I right clicked on the query builder and modified query to edit the name of the output.

I guess i just figured EG would give a unique name to each consecutive output table each time i added a new query builder. And i obviously did up to a certain point. The output of the two tables seen connected in the original attached image ended in 000O, that must be as high as the auto naming convention of EG will go before it simply duplicates the name over and over again.

One I changed the output names, all is well.

THANK YOU Fugue!

Fugue
Quartz | Level 8

You are right -- ordinarily, EG will assign a new output name for each new task (e.g. query builder). It is a mystery (to me) as to why EG failed to automatically create new table names. Your project doesn't appear to have so many tasks or table outputs that EG would be stressed. I'm wondering . . . does this have something to do with available disk space?

dude12345
Calcite | Level 5

I do not think it has anything to do with disk space, We have multiple terabytes available still on the servers we run SAS on. There are however several other EG projects (not mine) that have many more queries and tables referencing the same original table that I was querying from.

The problem is resolved though, and to be honest, I like changing the table names and the tables actually having unique names that I can identify what they are. As opposed to just standard names assigned by the query.

However, I do have a new issue...

https://communities.sas.com/thread/48544

You seem very knowledgeable, Do you think you could help me out on this one too?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 665 views
  • 2 likes
  • 3 in conversation