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!!!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.