How to download sas stored process results

#How to download sas stored process results download

You can see in the screenshot below that as the selections are made in the drop-down lists, the calculated items in the list table get populated with the values. Then all of the other calculated items that were created for this process are put into the list table as well.

#How to download sas stored process results download

In this example, we created a calculated item named вЂњOptionвЂќ with the value of вЂњClick to Download DataвЂќ.

First, a new calculated item is to be created for the text that you want to be shown for the link. This needs to be done through a list table in order to pass all of the values. The final piece of this process is linking to the stored process. In the roles tab for each object is where you can set the respective parameter. Parameters can be set through control objects and in this example we are using all category variables so drop-down lists will be used. Now that we have the parameters and a way to pass them to the stored process, we need to set the parameters so that they get populated as users work within the report. Creating the calculation is easy since you can just use the parameter as the value.Д®xample of the DriveTrain variable is shown below.

Therefore, we need to create calculated items for each of the parameters that were just initialized. When linking to a stored process only calculated items can be passed to the global variables. In this case, we are using all categories so all of the parameters are set to the character. You can go into your report and create parameters for each one of the global variables that were created in the previous step. Now we need a way to pass these values around as selections are made in SAS VA, parameters are one way to do that. Now in order to correctly build the query that filters out the data you donвЂ™t want, you will need to create a dynamic where clause with these global variables. For the CARS dataset, we are using the following variables: In the macro, you will want to declare global macro variables for the fields that you want to filter on in your report. Also within the stored process, you will want to create a macro that will query the source dataset. The first thing that you will want to do is create a stored process and set your ODS destination to CSV.

In the following step by step example, we have a report based on the sashelp.cars dataset and build out an external link in SAS VA that calls a stored process to output the source data that is filtered based on what the user has selected. Not only does this link provide you with the detailed source data, but through the use of parameters in SAS VA, the data can be filtered as well so you are only seeing the subset that you want.

What you can do instead is create a link that downloads the source data when you are ready for a deeper investigation. While this is convenient, it is not exactly a good practice when using visualization tools since you are taking up valuable space with just rows of data. Often they will opt to put list tables at the bottom of their reports so that as they are filtering and interacting with the report, the list table gets updated with the source rows of their selections. When it comes to using visualization tools like SAS Visual Analytics (VA), users sometimes want to have that underlying data available to them on the screen. A common aspect of data analysis is being able to see the underlying data and examine it when an investigation is needed.