Desktop productivity for business analysts and programmers

Blanks in column names and WORK.TEST.DATA

Reply
Contributor
Posts: 73

Blanks in column names and WORK.TEST.DATA

[ Edited ]

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

Super User
Posts: 9,550

Re: Blanks in column names and WORK.TEST.WORK

Posted in reply to JuanDaniel

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.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 73

Re: Blanks in column names and WORK.TEST.WORK

Posted in reply to KurtBremser

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

 

Super User
Posts: 9,550

Re: Blanks in column names and WORK.TEST.WORK

Posted in reply to JuanDaniel

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 73

Re: Blanks in column names and WORK.TEST.WORK

Posted in reply to KurtBremser

@KurtBremser 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

Super User
Posts: 9,550

Re: Blanks in column names and WORK.TEST.WORK

Posted in reply to JuanDaniel

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 5 replies
  • 173 views
  • 2 likes
  • 2 in conversation