topic Re: Unwanted file in the Config folder in Administration and Deployment

Unwanted file in the Config folder

siddhu1 — Mon, 30 May 2022 11:38:14 GMT

Hi,

I need some help, While executing the below code in the SAS Studio environment,
%let outpath=G:\Data\CXV\PGMSs\Test;
%put &outpath is ;

data shorts1;
set sashelp.cars;
run;
proc export data=shorts1
outfile="&outpath/shorts.csv"
dbms=csv replace;
run;

I was getting the below error:

ERROR: Physical file does not exist, D:\SAS\Config\Lev1\SASApp1-u8/&outpath/shorts.csv.
The files has been created in the config folder.
So can you help us in knowing the reason how it has been created.

Thanks & Regards,
Siddhartha

Re: Unwanted file in the Config folder

JosvanderVelden — Mon, 30 May 2022 11:54:09 GMT

Maybe it works if you use outfile="&outpath./shorts.csv"?

It seems the &outpath is not substituted. Are there other error messages or warnings? Do you have comments that prevent execution of the code in question?

Re: Unwanted file in the Config folder

Kurt_Bremser — Wed, 01 Jun 2022 19:39:33 GMT

Post the complete (all statements and messages) log from this code:

%let outpath=G:\Data\CXV\PGMSs\Test;
%put outpath is &outpath.;

data shorts1;
set sashelp.cars;
run;
proc export data=shorts1
outfile="&outpath./shorts.csv"
dbms=csv replace;
run;

by copy/pasting it into a window opened with the </> button.

BIG hint: the last message is usually the least important, but fixing the first issue can fix all others.

Re: Unwanted file in the Config folder

Tom — Mon, 30 May 2022 15:09:35 GMT

So one of two things appears to be happening.

Either you actually ran the code using single quotes instead of the double quotes .

outfile='&outpath/shorts.csv'

The macro processor ignores string literals bounded by single quotes.

Or the macro variable OUTPATH was not defined. In that case you should have received a WARNING message:

7729  %put "&outpath/myfile.csv";
WARNING: Apparent symbolic reference OUTPATH not resolved.
"&outpath/myfile.csv"

Either way once the operating system sees that SAS is using a RELATIVE pathname so it tries the create a file under the current working directory, which appears to be on that disk/sharename that is mounted as the D drive.

Re: Unwanted file in the Config folder

Sajid01 — Wed, 01 Jun 2022 19:32:42 GMT

Please check if the path specified in the macro assignment actually exists.
Please note the path should exist on the machine where the code is being executed.
If the code is being executed on the server, then the: G:\" refers to the G driver on the server.
The code is syntactically correct and will go wrong if the path is incorrect. I have tested your code and it works.
Please post the output of the following

%let outpath=G:\Data\CXV\PGMSs\Test;
%put &=outpath  ;