BookmarkSubscribeRSS Feed
Q1983
Lapis Lazuli | Level 10

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.

1 REPLY 1
Tom
Super User Tom
Super User

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

...

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1036 views
  • 0 likes
  • 2 in conversation