05-04-2012 12:45 PM
I'm a SAS newbie. In the first SAS program I create table mytable as ... in the second SAS program I try to select * from my table ... I get ERROR: File WORK.MYTABLE.DATA does not exist. I've just spent about three hours googling - no joy
05-04-2012 01:22 PM
Thanks for the quick reponse, That's exactly what I'm doing, except they're in two seperate SAS programs. The first does the create table, then the second does the select from mytable.
BTW: How do I paste into this editor?
05-04-2012 01:44 PM
When you say "two separate SAS programs" are they running in the same session? If not your WORK library by default is cleaned up by SAS at the end of the session and all data sets are deleted. Nehcour0420 suggestion below is how to create data sets that persist between sessions.
Since you say your are a new user the concept of LIBRARY is an important one to working in SAS.
05-04-2012 01:26 PM
Try to assign a library to your table, using:
Libname library_name '/sas/sasdata/library_name';
Then create table using:
create table library_name.mytable as