SAS EG calls the Windows "Scheduled Tasks" (in the control panel) to do it's scheduling. You can do the same thing manually for SAS 9.3 if that is installed locally.  Get your batch process working, encapsulate it in a .bat file, and schedule the .bat file. If you are using a remote SAS server, there is typically a scheduling tool on the server (in *nix, it's called 'cron'). ... View more

If you don't have a metadata store, the macro approach I described on Chris' blog works well.  The SYMBOLGEN can't disclose the passwords by another user because the person running the program has to have access to the plain text passwords. It is also easy to explain to auditors. ... View more

looks like you have trailing blanks in your macro definition. ... View more

Your narrative and your example don't match.  Please restate more precisely. Subject 101 on 15Mar and 10Apr do not follow the pattern in the narrative.  ... View more

Curious.  The code you posted here is different from that which came by e-mail.  The PARAM=GLM is required for the SLICE statement to be valid.  Perhaps you could post your log, as something strange is going on. Doc ... View more

try here. https://www.yumpu.com/en/document/view/11719962/diagnosing-sasr-enterprise-guider-connectivity-problems No wonder it has been taken down.  EG has changed a lot since 4.1 ... View more

This is a common problem in epidemiology.  Sufficiently so, that some macros have been developed.  Check out http://support.sas.com/resources/papers/proceedings10/061-2010.pdf (I just googled matching macro site:sas.com ). As LinusH suggests, you could do it as a one-off with SQL.  If your large data set is really big, the computer time might be huge. ... View more

Are you using SAS to do the work in MS Access?  Assuming yes, perhaps you could share the code and the error message.  You could also go to the SAS/Access manual for your version of SAS and look at the diagnostics available to you so you can see exactly what SAS is passing to Microsoft Access. ... View more

You can also use the sashelp.zipcode table to determine if any particular ZIP code is valid.  That data are updated every few months, so you may need to download the current one from sas.com. ... View more

Some generic things to look at SAS(R) Data Integration Studio 4.2: User's Guide (The link refers to DI, but the recommendations are largely for Base SAS.) If your data are in a remote database (Oracle, etc.), SAS will try to run the join on the database.  However, some things that are allowed on SAS SQL don't exist in one (or more) of the remote system types and will force SAS to bring all of the data to the SAS workspace.  Pass-thru SQL gives you more control with remote databases, but requires more knowledge on your part. ... View more

This one probably warrants opening a ticket with Tech Support. ... View more

shows for me. ... View more

to just get the values printed, use the CLI option (not CLB).  See SAS/STAT(R) 13.1 User's Guide ... View more