topic Re: PIPE Alternative? in SAS Enterprise Guide

PIPE Alternative?

RobW — Mon, 22 Dec 2008 15:14:15 GMT

OK...quick run-down of what I am trying to do:

Code node in EG project...using an EG project for the scheduling capabilities...

Code does:
PIPE to a folder
Data step to create dataset of folder metadata attributes (particularly looking at one file in the folder)
Parse out the Create Date of file of interest.
Compare that date to sysdate using a macro.
If no match, program sleeps and rechecks for date match using do loop before continuing to the actual meat of the program.

Of course I now realize through research that this fails at the beginning because you can't use PIPE in EG. Is there any coding alternatives other than changing the EG config (or anything of that nature)?

Other info:
SAS EG running locally only. No SAS server...yet. Hoping to get it soon.

Thanks in advance.

Re: PIPE Alternative?

deleted_user — Mon, 22 Dec 2008 16:35:54 GMT

windows API may be effective when you are "local", but what about on the server? Would that be "windows" too?

PeterC

good examples at http://devenezia.com/downloads/sas/sascbtbl/ . Message was edited by: Peter_c

Re: PIPE Alternative?

mgst170 — Wed, 07 Jan 2009 17:07:01 GMT

You can run pipe and x commands through EG.

There are a number of ways in which this can be done, but as you are running local EG, here is the solution you need:

Go to Start and type regedit

Navigate to HKEY_CLASSES_ROOT\CLSID\{440196D4-90F0-11D0-9F41-00A024BB830C}\LocalServer32

Here you will see the sas command used to start your local workspace server session. In this command, replace the -noxcmd with -xcmd.

Restart EG.

Easiest way to check is to run proc options and check xcmd is now set.

Cheers.

Re: PIPE Alternative?

RobW — Thu, 08 Jan 2009 22:39:23 GMT

mgst170:

Thanks for posting that...worked like a charm.

rmw