https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33049#M6380 Open the dataset again in EGuide. Select Properties and see how the dataset was created and give you an indication of your next step.<BR /> <BR /> For instance, if you have multiple SAS datasets on your desktop and they were created with different engines, then you need different libnames for each engine type. <BR /> <BR /> (Note that even if the files have the same extension, they may have been created with different engines.) Mon, 18 May 2009 19:28:02 GMT Doc_Duke 2009-05-18T19:28:02Z https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33048#M6379 A colleague emailed me a SAS dataset which I copied to my desktop. I double click it and it opens just fine in SAS Enterprise. I can see all the variable names and the actual data. <BR /> <BR /> But when I ask for the dataset to be opened in SAS 9.1 it says:<BR /> <BR /> ERROR: Unable to open the table TMP1.exer. TMP1.exer cannot be opened. Do you want to select a different table to open.<BR /> <BR /> <BR /> I am confused. Because I do not understand enough. I would like to be able to read the dataset into SAS 9.1. Any ideas? Sun, 17 May 2009 16:43:12 GMT https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33048#M6379 Doc 2009-05-17T16:43:12Z https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33049#M6380 Open the dataset again in EGuide. Select Properties and see how the dataset was created and give you an indication of your next step.<BR /> <BR /> For instance, if you have multiple SAS datasets on your desktop and they were created with different engines, then you need different libnames for each engine type. <BR /> <BR /> (Note that even if the files have the same extension, they may have been created with different engines.) Mon, 18 May 2009 19:28:02 GMT https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33049#M6380 Doc_Duke 2009-05-18T19:28:02Z https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33050#M6381 Hi Doc,<BR /> <BR /> you have given the error pop-up when you tried to open the table.<BR /> <BR /> can you please post the error showing in log window.<BR /> <BR /> This problem occurs when BASE SAS not able to identify the formats assigned to the variables where SAS EG can do that.<BR /> <BR /> I faced this problem before. we have reassigned the format for that particular variable and then we used that table in BASE SAS.<BR /> <BR /> This is one possible reason for that ERROR<BR /> <BR /> Hope this will help you<BR /> <BR /> Regards,<BR /> skm Thu, 21 May 2009 04:33:20 GMT https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33050#M6381 deleted_user 2009-05-21T04:33:20Z https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33051#M6382 Doc<BR /> <BR /> is it possible the data set was read in E.G. from an excel file with special characters in a column name?<BR /> It seems by default E.G. applies system option [pre] validVarName= ANY [/pre] but a non-E.G. session uses V7 instead of ANY.<BR /> If you set your defaults (in so many ways) to ValidVarName=ANY, you may overcome the problem.<BR /> <BR /> good luck<BR /> <BR /> PeterC Thu, 21 May 2009 14:56:21 GMT https://communities.sas.com/t5/SAS-Programming/SAS-dataset-opens-in-SAS-Enterprise-but-not-in-SAS-9-1/m-p/33051#M6382 Peter_C 2009-05-21T14:56:21Z