https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60671#M279 It appears that your Excel file contains variables names that are not in standard SAS format (i.e. some may contain a blank space). <BR /> By default, Enterprise Guide executes the statement "options validvarname=any;".<BR /> This setting of the VALIDVARNAME system option allows the use of column<BR /> names that contain embedded spaces and special characters. <BR /> For more information please refer to: <A href="http://support.sas.com/kb/14/661.html" target="_blank">http://support.sas.com/kb/14/661.html</A><BR /> I would suggest to remove these blanks before importing the Excel file.<BR /> Hope this helps,<BR /> Udo Wed, 12 Nov 2008 08:44:39 GMT udo_sas 2008-11-12T08:44:39Z https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60670#M278 We have created a SAS dataset from an Excel file in SAS EG . We do not have PC file formats installed on UNIX, so I am using the import wizard in EG to import the Excel file. When I try to access the SAS dataset in Enterprise Miner, it says it cannot access table. EG can open the dataset without any issues. <BR /> <BR /> However, when we run the PROC IMPORT in PC SAS and then access the SAS dataset created using Enterprise Miner, we are able to access thedataset without any issues. Mon, 10 Nov 2008 22:23:20 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60670#M278 hkotian 2008-11-10T22:23:20Z https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60671#M279 It appears that your Excel file contains variables names that are not in standard SAS format (i.e. some may contain a blank space). <BR /> By default, Enterprise Guide executes the statement "options validvarname=any;".<BR /> This setting of the VALIDVARNAME system option allows the use of column<BR /> names that contain embedded spaces and special characters. <BR /> For more information please refer to: <A href="http://support.sas.com/kb/14/661.html" target="_blank">http://support.sas.com/kb/14/661.html</A><BR /> I would suggest to remove these blanks before importing the Excel file.<BR /> Hope this helps,<BR /> Udo Wed, 12 Nov 2008 08:44:39 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60671#M279 udo_sas 2008-11-12T08:44:39Z https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60672#M280 You are right.........it was the spaces that was causing the problem with the import........but i did check the validvarname = any option in SAS EG and it is set to default to any .....<BR /> <BR /> but yet when I removed the spaces it worked .......the only thing i'm wondering is why ?? Thu, 13 Nov 2008 17:56:48 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60672#M280 hkotian 2008-11-13T17:56:48Z https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60673#M281 When using VALIDVARNAME=ANY your SAS variable can begin with or contain any characters, including blanks.With other words not only the Excel variable name can contain blanks but the SAS variables which will be created after importing will contain these blanks as well. You might want to verify this by checking the SAS variable names of your table after importing.<BR /> For more information about the recommended usage of VALIDVARNAME please refer to online help: <A href="http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000279245.htm" target="_blank">http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000279245.htm</A><BR /> Hope that helps,<BR /> Udo Fri, 14 Nov 2008 09:11:41 GMT https://communities.sas.com/t5/SAS-Forecasting-and-Econometrics/SAS-Enterprise-Miner/m-p/60673#M281 udo_sas 2008-11-14T09:11:41Z