syntax error when running a .sas program on unix server

cnilsen — Wed, 11 Sep 2019 20:20:46 GMT

HI.

perhaps someone can help. I have a large .sas program that generates an error at this particular part of the code when I run directly on our unix server, but when I run the same piece of code in EG, I have no issue and my output creates as expected. So.. I'm assuming that this statement is interpreted differently as .egp.. and therefor I need to use some sort of unix syntax equivilant?

this is my code

PROC SQL;
CREATE TABLE work.CustRespChanPlatALLGFGB AS
SELECT DISTINCT

compress(t1.Source_ID || put(t1.'WEB ORDER ID'n,best.)) as SrcAndWebNbr
,t1.'ORDER #'n as OrderNumber
,t1.'MASTER CHANNEL'n as MasterChannel
FROM
ADS.CUST_RESP_CHAN_PLAT_ALLGFGB t1
;
QUIT;

these are the errors I get:

ERROR: Column WEB ORDER ID could not be found in the table/view identified with the correlation name T1.
ERROR: Column ORDER # could not be found in the table/view identified with the correlation name T1.
ERROR: Column MASTER CHANNEL could not be found in the table/view identified with the correlation name T1.
ERROR: Numeric format BEST in PUT function requires a numeric argument.

I have attached the source table specs so that you can see what the input table contains.

Any help or advice would be truly appreciated.

Re: syntax error when running a .sas program on unix server

r_behata — Wed, 11 Sep 2019 20:33:04 GMT

Try

OPTIONS VALIDVARNAME=ANY;

Re: syntax error when running a .sas program on unix server

cnilsen — Thu, 12 Sep 2019 18:18:01 GMT

That worked out.. Thanks so much!

topic syntax error when running a .sas program on unix server in SAS Programming

syntax error when running a .sas program on unix server

Re: syntax error when running a .sas program on unix server

Re: syntax error when running a .sas program on unix server