How to Pass Agrument from SAS to batch File Using PSFTP

[Rajendra]

2. I have put psftp.exe on local  server directory D:\psftp.exe
4. I have created batch file on same local directory D:\market_extract.bat as below
5. Batch file code as below
6. lcd d:\landing
7. cd  /home/Comcast/sample_data
8. mget  market *.csv
9. quit
10. It is getting market files from remote directory /home/Comcast/sample data to local directory d:\landing.
13. Using sas I have stored global variable in config file as D:\ftp_variable.sas below is the code
15. Macro ftp_variables()
16. %global  market_cmd_script, PSFTP_HOME, USERID, REMOTE_FTP_SERVER, PSWD;
17. %let market_cmd_script=D:\market_extract.bat
18. %let PSFTP_HOME_DIR=D:\psftp;
19. %let USERID=dummy1;
20. %let REMOTE_FTP_SERVER=ftp.dummy1.com;
21. %let PSWD=dummy2;
23. %mend;
24. %ftp_variables;
28. Now In sas i am executing this market_extract.bat using psftp commands and global variables declared in ftp_variable.sas as below in user_written_code operator
29. %include ‘D:\ftp_variable.sas’
30. %let var_str= &PSFTP_HOME_DIR &USERID@&REMOTE_FTP_SERVER -P 22 -pw &PSWD -batch -v –b &MARKET_FTP_CMD_SCRIPT;
31. %let cmd_str= "&var_str";
32. %sysexec &cmd_str;
33. It is working fine and transferring file from remote directory to local directory.
34. New Requirement:
35. Now I want to remove path hard coding in batch file market_extract.bat
36. In batch file instead of d:\landing and /home/Comcast/sample_data I want to create a global variable in
37. Sas config file ftp_variables.sas like below
38. Macro ftp_variables ()
39. %global  market_cmd_script, PSFTP_HOME, USERID, REMOTE_FTP_SERVER, PSWD,LOCAL_DIR,REMOTE_DIR;
40. %let market_cmd_script=D:\market_extract.bat
41. %let PSFTP_HOME_DIR=D:\psftp;
42. %let USERID=dummy1;
43. %let REMOTE_FTP_SERVER=ftp.dummy1.com;
44. %let PSWD=dummy2;
46. %let LOCAL_DIR= D:\landing
48. %let REMOTE_DIR= /home/Comcast/sample_data
50. %mend;
51. %ftp_variables;
55. In batch file market_extarct.bat replacing path hard coding with Parameter as %1,%2
57. Batch file code as below
58. lcd %1
59. cd  %2
60. mget  market *.csv
61. quit
63. and while running this batch from sas giving argument to market_extract.bat  as below
64. %include ‘D:\ftp_variable.sas’
65. %let var_str= &PSFTP_HOME_DIR &USERID@&REMOTE_FTP_SERVER -P 22 -pw &PSWD -batch -v –b &MARKET_FTP_CMD_SCRIPT  &LOCAL_DIR  &REMOTE_DIR ;
66. %let cmd_str= "&var_str";
67. %sysexec &cmd_str;
69. But %1 and %2 are not getting passed as path from sas so remote files are not getting transfer to local_dir.
71. Is there any other way to pass parameter to market_extract.bat from sas  using sftp .

Regards

Rajendra Jain

[ChrisNZ]

I suspect the -batch option does not accept batch parameters.

&LOCAL_DIR  &REMOTE_DIR would be seen as more options after the -batch option.

Have you tried running the command from the prompt?

Maybe enclosing the whole command in quotes

-batch -v –b "&MARKET_FTP_CMD_SCRIPT  &LOCAL_DIR  &REMOTE_DIR "

would work?