topic Re: Blanks in column names and WORK.TEST.WORK in SAS Enterprise Guide

Blanks in column names and WORK.TEST.DATA

JuanDaniel — Tue, 07 Nov 2017 12:58:57 GMT

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

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

Kurt_Bremser — Tue, 07 Nov 2017 09:16:15 GMT

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.

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

JuanDaniel — Tue, 07 Nov 2017 12:21:56 GMT

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

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

Kurt_Bremser — Tue, 07 Nov 2017 12:35:41 GMT

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

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

JuanDaniel — Tue, 07 Nov 2017 13:15:52 GMT

@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

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

Kurt_Bremser — Wed, 08 Nov 2017 06:58:47 GMT

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.