topic Re: X command in PC SAS in SAS Programming

X command in PC SAS

KevinC_ — Wed, 18 Feb 2015 18:16:39 GMT

Hello Everyone,

I am trying to remove a permanent SAS dataset stored in a Unix directory from PC SAS. I enclose the code in Rsubmit and Endrsubmit; For testing purpose, I try to remove just one file first. When I run the code it has no errors. But it does not remove the dataset either. Can anyone tell me what I am doing wrong? Thank you very much for any input you may have!

rsubmit;

%macro remove;

x "rm /users/apps/cust_folder/customers1.sas7bdat";

%mend;

endrsubmit;

rsubmit;

%remove;

endrsubmit;

Re: X command in PC SAS

Tom — Wed, 18 Feb 2015 18:28:16 GMT

Your title is a little misleading. Looks like you want to run a Unix command using RSUBMIT block to a remote SAS session. Doesn't look like PC SAS has anything to do with it.

I usually like to use INFILE ... PIPE in a data step for those types of commands. That way you can see the response from the operating system. Also not sure what the macro is there for.

rsubmit;

data _null_;

infile "rm /users/apps/cust_folder/customers1.sas7bdat" pipe ;

input;

put _infile_;

run;

endrsubmit;

Re: X command in PC SAS

KevinC_ — Wed, 18 Feb 2015 18:37:20 GMT

Thanks Tom,

I ran your code and it did not display anything from _infile_. There was no errors in the log. In fact, the only thing I see in the log was "Remote submit to XXX commencing" and "Remote submit to xxx complete". Any other suggestions?

Just to make myself clear, I run this from PC (Not on Unix). Hence, I call it 'PC SAS'.

Re: X command in PC SAS

ballardw — Wed, 18 Feb 2015 18:37:36 GMT

Is that location available as a library from your SAS server or directly from your computer?

If so there is no reason to go to system commands. You could use proc delete or proc datasets.

And remember that UnIx is veRy Case sensiTIVE.

Re: X command in PC SAS

SASKiwi — Wed, 18 Feb 2015 18:37:41 GMT

Is there any particular reason for using an operating system command instead of these SAS techniques?

proc datasets library = MyLib;

delete customers1;

run;

quit;

proc sql;

drop table Mylib.customers1;

quit;

Re: X command in PC SAS

Tom — Wed, 18 Feb 2015 18:52:38 GMT

Sounds like your remote session is confused. Otherwise you should see the data step in the log with attendant NOTE: lines.

Try closing it and opening a new one.

Re: X command in PC SAS

KevinC_ — Wed, 18 Feb 2015 19:13:32 GMT

Thank you Tom, ballardw, and SASKiwi.

Tom,

I restarted a new SAS session and now I was able to see more info in the log. The problem was one of the letters in the file name had an incorrect case. It works like a charm now.

Thank you everyone!