Exporting files to a relative path

[JamesNewcombe]

Hello

My SAS program uses Proc Export to write out a CSV file. I want to be able to write the file into a "Data" folder inside the same folder where I've stored my SAS program. If I copy my SAS program to a different folder and run it I want the CSV to automatically be written into data folder in the the new location. I don't want to have to keep manually altering the path in the program.

Does anyone know how I can do this? it must be possible!

Thanks.

[DF]

Perhaps the macro variables SAS_EXECFILEPATH and SAS_EXECFILENAME will help?  There are some more details here: http://support.sas.com/documentation/cdl/en/hostwin/63047/HTML/default/viewer.htm#editor_enhanced.ht... .

Sadly my setup doesn't allow me to create an example for you, but it sounds like they might help.

If they work for you, you should be able to parse the text of the full path to your program, and work out the full path of your desired folder.

[JamesNewcombe · Accepted solution]

I had look at it and coded this:

%let ipath = %sysget(SAS_EXECFILEPATH);

Which gets the current path where the SAS program is stored. Now I can easily add this into my Proc Export.

Thanks for your help!