BookmarkSubscribeRSS Feed
dav_amol
Calcite | Level 5
We are trying to generate 4 reports thru a single stored process.

In this stored process , we are planning to give 2 dropdown menus to user
and the values/parameters of 2nd box should vary based on value selected
in first box. Based on the state and country the stored process will
generate the Report.

e.g. first input field will be Country .

if End user selects US from the dropdown menu then based on that
input the second menu should give States corresponding to US only so that
user can select ( like drop down menu will contain CA,AZ,TX etc. )and then
report for that perticular state should be generated thru stored process
execution.

If End user selects INDIA from first dropdown menu then based on
that input the second menu should give states correponding to India only
that user can select and generate the report for that state.

Can we deploy this thru use of Stored process? if yes it would be
appreciable if you can tell us how can we do that?
Thanks,
Amol
2 REPLIES 2
dav_amol
Calcite | Level 5
One more point .

We are deploying this thru SAS Information Delivery Portal but client don't want to deploy it using JSP.
Cynthia_sas
SAS Super FREQ
Hi:
In SAS 9.2p designed to work with the BI Platform, you will be able to do both Cascading and Dynamic prompts for stored processes. If you are using SAS 9.1.3, however, you would have to code the cascading or dynamic prompts yourself--the stored process won't do it automatically until 9.2p.
cynthia

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 787 views
  • 0 likes
  • 2 in conversation