topic Re: Executing DOS Commands in SAS Programming

Executing DOS Commands

BCNAV — Thu, 09 Nov 2017 16:51:53 GMT

Hi all, at the end of an EG project, I need to have one dataset deleted and one copy and renamed as the one that was just deleted (for the next run).

I have the following in a code node as the last step of the project:

options noxwait;
data _null_;
	x 'del \\NCRFP4\TAF\SAS Projects Datasets\NATGapDatasets\natcumfbs1.sas7bdat'; run;
	x 'copy \\NCRFP4\TAF\SAS Projects Datasets\NATGapDatasets\natcumfbs.sas7bdat \\NCRFP4\TAF\SAS Projects Datasets\NATGapDatasets\natcumfbs1.sas7bdat';
run;

these steps are never executed.

Any insight? Thanks

Re: Executing DOS Commands

Reeza — Thu, 09 Nov 2017 16:55:40 GMT

EG rarely supports X commands. Is X commands enabled and are you running locally where DOS is available or is EG running off a Unix Server?

Is there a specific reason you're not using the SAS functionality for this, ie PROC DATASETS can both delete and move data?

Re: Executing DOS Commands

RW9 — Thu, 09 Nov 2017 16:56:49 GMT

Why do you need system commands (which are likely disabled) for such a thing:

proc datasets lib=<insertlib> nolist;
  delete natcumfbs1;
quit;

data <insertlib>.natcumfbs1;
  set <insertlib>.natcumfbs;
run;

I don't know your library so you need to put that in.

Re: Executing DOS Commands

BCNAV — Thu, 09 Nov 2017 19:08:25 GMT

Thank you all. I am updating old code, and the X commands were there. It just never occurred to me to use proc datasets...Bah! Thanks!