Cannot get my macro variable working in a PROC IMPORT

[dllfrancelino]

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.

[Reeza · Accepted solution]

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.

---

[dllfrancelino]

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