I am retrieving a directory listing used in ftp upload
%let HHF_host=********; /* Machine to connect with ftp */
%let HHF_userid=******; /* ID to use with ftp command */
%let HHF_ftppwd=********; /* Password for the ftp userid */
%let workpath = %sysfunc(pathname(work));
filename dir ftp '' ls cd="/inbound" user=&HHF_userid pass="&HHF_ftppwd"
host="&HHF_host" prompt;
data folders;
infile dir missover truncover;
input name $;
call symput('F'||trim(left(_N_)),compress(name));
run;
I get the following warning WARNING: Apparent symbolic reference DIR not resolved.
Does one of your passwords include an & character?
You might want to use macro quoting to prevent the macro processor from trying to expand the value.
Personally I normally include the quotes into the macro variables. This makes it possible to use single quotes around passwords that contain macro triggers.
%let HHF_ftppwd='********'; /* QUOTED Password for the ftp userid */
...
pass=&HHF_ftppwd
...
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.