topic Re: Delete csv file from home folder in SAS Programming

Delete csv file from home folder

dcortell — Tue, 10 Jul 2018 15:35:21 GMT

I'm trying to delete a csv file from the home directory in sas

I was using

data_null_;

rc=fdelete("~/nameoffile.csv");

run;

but it seems not working

There is any command I can use for the scope?

Re: Delete csv file from home folder

Reeza — Tue, 10 Jul 2018 15:45:01 GMT

Try using the full path?

The documentation seems to expect a fileref, not the path, did you try that approach?

http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#p029yvwyao7xspn19xzxo3vyb0hz.htm

@dcortell wrote:

Hi

I'm trying to delete a csv file from the home directory in sas

I was using

data_null_;

rc=fdelete("~/nameoffile.csv");

run;

but it seems not working

There is any command I can use for the scope?

Re: Delete csv file from home folder

dcortell — Wed, 11 Jul 2018 10:00:27 GMT

Tested both :

data _null_;
rc=fdelete("/r/ge.unx.sas.com/vol/vol110/u11/spndac/final_&dd&mm&yy..csv");
run;

data _null_;

ff=("/r/ge.unx.sas.com/vol/vol110/u11/spndac/final_&dd&mm&yy..csv");
rc=fdelete(ff);
run;

The files are still there

Re: Delete csv file from home folder

dcortell — Wed, 11 Jul 2018 10:17:14 GMT

Solved with the following :

filename test "/r/ge.unx.sas.com/vol/vol110/u11/spndac/final_&dd&mm&yy..csv";

data _null_;
rc=fdelete('test');
put rc=;
run;

Re: Delete csv file from home folder

s040293 — Thu, 04 Oct 2018 23:07:44 GMT

It works magically, thank you!