Hi!
I am trying to run a script with EG and I get an error like: “file WORK.TEST.DATA dont exist” but I dont find the error.
Other problem that i have is that in the DBMS the column names has blank spaces in the name and when I imported metadata in the SMC i have errors with this tables.
Kind regards
Look at the log of the step that should have created WORK.TEST.
And database columns with blanks are a VERY BAD IDEA and, in my eyes, proof for extreme stupidity on the part of the person responsible.
Yes... I Know. If I execute from the server ( I have a EG installed here for test) I have this problem but, if i execute from a client connected to server it works.
Could be a problem related with the EG configuration?
Thx
@JuanDaniel wrote:
Yes... I Know. If I execute from the server ( I have a EG installed here for test) I have this problem but, if i execute from a client connected to server it works.
Could be a problem related with the EG configuration?
Thx
EG works with
option validvarname=any;
and accepts non-standard SAS names (up to 32 characters). But that is mainly there to accomodate the usual stupidities included in Excel files caused by non-programmers.
The workspace server used by SMC does not set this option (AFAIK), and that could be why you have that problem.
Still, using sensible names at the source (the DB) does immediately away with all the curremt problems, and those that will arise in the future.
@Kurt_Bremser Sorry for my ignorance.
What is the difference of execute from the server machine or i execute in a client connected to the server in another machine? Both use the same workspace server?
There is any solution for solve this problem with the column names? Obviously the person responsible of the Database can change all columns names but i think is not a valid idea for him
Thx
It is Enterprise Guide that sends the option on establishing a server connection. It is not part of the workspace server configuration itself.
I can only repeat it: use proper names in the DB itself, blanks or special characters are idiotic and forbidden at my organisation.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.