Your SAS programs, embedded in web apps and elsewhere

EG 5.1 Stored Process and Conditional Processing

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

EG 5.1 Stored Process and Conditional Processing

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 Smiley Happy ).

Thanks,

Fred


Accepted Solutions
Solution
‎06-24-2014 10:53 AM
Respected Advisor
Posts: 3,156

Re: EG 5.1 Stored Process and Conditional Processing

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

View solution in original post


All Replies
Respected Advisor
Posts: 3,156

Re: EG 5.1 Stored Process and Conditional Processing

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 mindSmiley Wink, we can't.

Regards,

Haikuo

Contributor
Posts: 50

Re: EG 5.1 Stored Process and Conditional Processing

Sorry Hai.Kuo Smiley Happy

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 Smiley Happy.

Regards,

Fred

Solution
‎06-24-2014 10:53 AM
Respected Advisor
Posts: 3,156

Re: EG 5.1 Stored Process and Conditional Processing

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

Contributor
Posts: 50

Re: EG 5.1 Stored Process and Conditional Processing

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1120 views
  • 0 likes
  • 2 in conversation