FILENAME FTP PROMPT in SAS OnDemand

[Junyong]

I was uploading a file via FTP using the following code:

%put %sysfunc(dlgcdir(!userprofile\desktop));
filename original 'original.txt';
filename copy ftp 'copy.txt' host='my.address.com' user='myusername' prompt passive debug;

data _null_;
	infile original;
	input;
	file copy;
	put _infile_;
run;

And I found that the PROMPT above is impossible in SAS OnDemand; I checked that only PASS works there. Is the PWENCODE-PASS combination the only way in SAS OnDemand? Or is there any other way to keep PROMPT here?

[Tom · Accepted solution]

Isn't SAS On Demand using SAS/Studio as the user interface?

If you want to prompt the user for a password you will need to use a SAS/Studio type prompt to get the password into a macro variable that you can use in the FILENAME code.