04-20-2015 03:40 PM
I'm new to SAS EG and am having trouble working with it. I cannot create SAS datasets from EG as SAS is not installed locally.
When I import a CSV file into EG and try to filter on the variables, it gives me an ERROR saying that the file WORK.XXX does not exist. What do I have to do to be able to be able to filter on a variable in this dataset and create a new one with reduced variables?
04-20-2015 05:54 PM
Did you create an EG project, import the CSV file into WORK, close the project thus ending your SAS session and losing your work directory, then reopen the project and discover the work table doesn't exist? If so, just import into a permanent library instead of WORK.
04-21-2015 09:17 AM
Echoing what others have said:
04-21-2015 10:36 AM
Thank you all. Yes, the file was being saved temporarily in the Work environment...but neither the filter nor the query builder would work. I tried writing a sql code today instead....and it works just fine. Maybe it is one those quirks I have to get used to?
04-21-2015 10:56 AM
That should not be the case -- the Query Builder should work with this data. I recommend that you work with SAS Tech Support to see what's going on, as it might affect your ability to run other tasks against this imported data.