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.
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.
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.
It worked!!! Thank you very much!!!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.