- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hello Team,
I am writing this python script to upload the files to SFTP and I want to dynamically pass the file name as a macro variable. Unfortunately we can not use the submit block inside a macro function. Can someone please help me with a solution ? or an alternative way to SFTP the files?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Balli
You can't call macro variables in the script that way, instead the macro variable needs to be passed using the SAS variable which is created as part of the PROC PYTHON session.
You should be able to use SAS.symget('') where you've highlighted the issue in your code in yellow.
see example from documentation below:
%let myvar = Jane Doe;
proc python;
submit;
x = SAS.symget('myvar')
print('macro variable myvar = ' + x)
py_var = 'Inside python'
SAS.symput('macrovar', py_var)
endsubmit;
run;
%put &=macrovar;
%put &=myvar;
Thanks
Harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Balli
You can't call macro variables in the script that way, instead the macro variable needs to be passed using the SAS variable which is created as part of the PROC PYTHON session.
You should be able to use SAS.symget('') where you've highlighted the issue in your code in yellow.
see example from documentation below:
%let myvar = Jane Doe;
proc python;
submit;
x = SAS.symget('myvar')
print('macro variable myvar = ' + x)
py_var = 'Inside python'
SAS.symput('macrovar', py_var)
endsubmit;
run;
%put &=macrovar;
%put &=myvar;
Thanks
Harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks @HarrySnart , works like a charm 🙂