topic Cannot get my macro variable working in a PROC IMPORT in SAS Enterprise Guide

Cannot get my macro variable working in a PROC IMPORT

dllfrancelino — Fri, 24 Aug 2018 16:46:45 GMT

Dear all,

I'm trying to import a txt file with this code.

%let ex = 201806
proc import datafile = '\\10.39.114.71\Controladoria$\PLANNING\BASE_PORTFOLIO\BS_PORT_&EX..txt'
out= BS_PORT.BS_PORT_&EX.
dbms=dlm replace;
delimiter= '09'x;
run;

And it's not running, as you can see on the log below.

What am I doing wrong?

Thanks a lot!

25         proc import datafile = '\\10.39.114.71\Controladoria$\PLANNING\BASE_PORTFOLIO\BS_PORT_&&EX..txt'
26         out= BS_PORT.BS_PORT_&&EX.
WARNING: Apparent symbolic reference EX not resolved.
WARNING: Apparent symbolic reference EX not resolved.
NOTE 138-205: Line generated by the macro variable "SASWORKLOCATION".
26          BS_PORT.BS_PORT_&EX.
                            _
                            22
ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE,
              _DEBUG_.

NOTE: Line generated by the macro variable "SASWORKLOCATION".
26          BS_PORT.BS_PORT_&EX.
                            _
                            200
ERROR 200-322: The symbol is not recognized and will be ignored.

Re: Cannot get my macro variable working in a PROC IMPORT

Reeza — Fri, 24 Aug 2018 16:55:38 GMT

You need double quotes instead of single quotes.

@dllfrancelino wrote:

Dear all,

I'm trying to import a txt file with this code.

%let ex = 201806
proc import datafile = '\\10.39.114.71\Controladoria$\PLANNING\BASE_PORTFOLIO\BS_PORT_&EX..txt'
out= BS_PORT.BS_PORT_&EX.
dbms=dlm replace;
delimiter= '09'x;
run;

And it's not running, as you can see on the log below.

What am I doing wrong?

Thanks a lot!

25         proc import datafile = '\\10.39.114.71\Controladoria$\PLANNING\BASE_PORTFOLIO\BS_PORT_&&EX..txt'
26         out= BS_PORT.BS_PORT_&&EX.
WARNING: Apparent symbolic reference EX not resolved.
WARNING: Apparent symbolic reference EX not resolved.
NOTE 138-205: Line generated by the macro variable "SASWORKLOCATION".
26          BS_PORT.BS_PORT_&EX.
                            _
                            22
ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATAFILE, DATATABLE, DBMS, DEBUG, FILE, OUT, REPLACE, TABLE,
              _DEBUG_.

NOTE: Line generated by the macro variable "SASWORKLOCATION".
26          BS_PORT.BS_PORT_&EX.
                            _
                            200
ERROR 200-322: The symbol is not recognized and will be ignored.

Re: Cannot get my macro variable working in a PROC IMPORT

dllfrancelino — Fri, 24 Aug 2018 16:57:45 GMT

It worked!!! Thank you very much!!!