EG 5.1 Stored Process and Conditional Processing

[FredGIII]

Hi all,

During my search I found a discussing indicating that Conditional Processing code was not exported to a STP in EG 4.2 but was being looked at for a future release. Based on my quick attempt at a STP it appears that conditional processing is still not supported in EG 5.1.  Can anyone confirm this? Or am I doing something wrong (entirely likely ).

Thanks,

Fred

[Haikuo]

I am afraid your description is too vague. "Conditional processing" is a general term. It could mean IF-THEN within data step, it could also mean %IF-%THEN in Macros, it could also mean PROMPTS implementation, all of these can be related to "Conditional processing" and all are supported by STP. Please specify what you have, and what outcome you are looking for, as detailed as possible, and don't assume we can read your mind, we can't.

Regards,

Haikuo

[FredGIII]

Sorry Hai.Kuo

I thought in the context of the heading that it was clear. What I am referring to is the conditional branching within EG5.1.  I have a result table and based on a PROMPT  (user selects which report to output), then a specific Pareto Chart is run.  But when I try to turn that into a STP, I get a message:

One or more items in the process flow cannot be included as part of the SAS program....

And looking at the code generated by the STP wizard, I see:

/* --- Problem: Unable to express task in SAS code.  --- */

Hopefully I have explained myself clearly enough. If not, let me know. You can't read my mind because it's a jumbled mess, you would just get lost .

Regards,

Fred

[Haikuo · Accepted solution]

LOL, Fred. From I have collected, correct me if I am wrong:

what you have: A project flow with some possible query builders, tasks, and charts and reports, within which you have prompts in charge of "conditional processing".

what you want: to turn the whole thing into STP

If what I have gathered is correct, then I am afraid that you will have to do some reading and then some coding in order to embed these prompts. I have been there. EG sometimes is not smart enough to auto-generate STP codes with prompts, especially complicated prompts, such as cascade prompts, prompts groups etc. What I did is to read this book:The 50 Keys to Learning SAS Stored Processes: Must have guide for SAS Developers: Tricia Aanderud, A...

Trust me, it worth every penny.

Good Luck,

Haikuo

[FredGIII]

Thanks Haikuo;

I suspected as much.  That's ok, I am comfortable with writing SAS code and Macro's.  I was just hoping that the STP wizard would make my life easier.  Thanks for confirming though.

Fred