Forecasting using SAS Forecast Server, SAS/ETS, and more

SAS Enterprise Miner

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

SAS Enterprise Miner

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.

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.

Accepted Solutions
Solution
‎08-09-2017 02:12 PM
SAS Employee
Posts: 416

Re: SAS Enterprise Miner

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.
For more information about the recommended usage of VALIDVARNAME please refer to online help: http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000279245.htm
Hope that helps,
Udo

View solution in original post


All Replies
SAS Employee
Posts: 416

Re: SAS Enterprise Miner

It appears that your Excel file contains variables names that are not in standard SAS format (i.e. some may contain a blank space).
By default, Enterprise Guide executes the statement "options validvarname=any;".
This setting of the VALIDVARNAME system option allows the use of column
names that contain embedded spaces and special characters.
For more information please refer to: http://support.sas.com/kb/14/661.html
I would suggest to remove these blanks before importing the Excel file.
Hope this helps,
Udo
Occasional Contributor
Posts: 12

Re: SAS Enterprise Miner

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 .....

but yet when I removed the spaces it worked .......the only thing i'm wondering is why ??
Solution
‎08-09-2017 02:12 PM
SAS Employee
Posts: 416

Re: SAS Enterprise Miner

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.
For more information about the recommended usage of VALIDVARNAME please refer to online help: http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000279245.htm
Hope that helps,
Udo
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 1697 views
  • 0 likes
  • 2 in conversation