About KeithM

KeithM · ‎02-12-2021

David, I was able to get it to work. This is what my sample data looked like. It started off with just RandomIDChar and Real. I assume that your goal is to get one value and add it to a Key Value object. Calculations: Step #1: Create your new character data item based on your filter criteria: Name: RandomIDNew Calculation: Step #2: Numerator: (Note: NumMiss will calculate the number of items that are missing. If there are any missing, then we need to subtract that one distinct count from the resulting distinct count calculation) Step #3: Denominator: Step #4: Create Percent (Note: step 2,3 & 4 could all be just one calculation)

KeithM · ‎06-09-2020

The message is coming from the expression Position <> "FAKT_STD". To get this to work, turn that into a numeric expression by doing the following: 1. Create a numeric calculated data item called Position Flag. 2. In the expression for Position Flag make it look like: If Position <> "FAKT_STD" return 1 else 0 3. Modify your % v.UMS.(Lf.M) calculation and replace (Position <> "FAKT_STD") with "Position Flag"n >= 1

KeithM · ‎04-17-2020

Try creating an aggregated measure that looks like the following: sum(_bygroup_(Var0))/sum(_ForAll_(Var0))

KeithM · ‎01-28-2020

Try removing the parameter. It should not be needed. Also make sure that no filters are applied to the individual objects.

KeithM · ‎07-11-2019

Sometimes it is easier to see the solution with a few screen captures. Here is my analysis that corresponds to the accepted solution. This is easily illustrated with a few screen captures. I created a simple cross tab from cars table. I formatted frequency to be currency. I also created a custom category called Custom Category 1 based on Origin. Default option window show when exporting data from a list table: Formatting: if this is selected then any formats that you added WITHIN VA will be exported. DETAIL DATA does not aggregate and does not show calculated columns that were created in VA. So in the example above, CUSTOM CATEGORY 1 does not exist in detail data. Here are the results formatted and unformatted.

KeithM · ‎06-14-2019

I think this can be done. It is easiest to create 3 stored processes. One to generate the form that is initially displayed. Another to run the report to send results back to the viewer. Another to run a stp that exports it to ODS. STP 1 would look similar to the following: /************************************************************** DATA _NULL_; file _webout; put "<html>"; put "<style>"; put "body {font-family: 'Calibri';}"; put "h3 {text-align: center;}"; put "div {font-size: small; font-weight: bold;}"; put "</style>"; put "<body>"; /* first form to run stored process to "return to start" */ put "<FORM ACTION='&_URL'>"; put '<input type="hidden" name="_program" value="/Projects/TLM/StoredProcess/TLM_DnM_FC_get_input">'; put '<div><input type="submit" value="RETURN TO START"></div></form>'; /* end of first form definition */ put '<br> </br>'; /* second form to run stored process that will export to excel */ put "<FORM ACTION='&_URL'>"; put '<input type="hidden" name="_program" value="/Projects/TLM/StoredProcess/TLM_DnM_export2Excel">'; put '<div><input type="submit" value="EXPORT TO EXCEL"></div></form>'; /* end of second form definition */ put "</body>"; put "</html>"; RUN; /* ********************************************************************************************************** */ STP 2 would be the stp that you have already created making sure that it is wrapped with %stpbeing and %stpend STP 3 would be your same code in STP 2, but you would use tags to Export to Excel like the following example: The next step that you must have in place is to define the stored process TLM_DnM_export2Excel, and here is a short example of code that exports a PROC PRINT output to Excel. This stored process must be registered to execute on the "Stored Process Server only" and should produce Stream results. /* Example: Create a HTML file for downloading to Excel. */ /* Using %STPBEGIN and %STPEND */ *ProcessBody; data _null_; rc = stpsrv_header('Content-type','application/vnd.ms-excel'); rc = stpsrv_header('Content-disposition','attachment; filename=report.xls'); run; %stpbegin; proc print data=sashelp.class; run; %stpend;

KeithM · ‎03-06-2019

Here is an example that might be similar to what you want to do. In this sample, you end up creating a custom graph. http://support.sas.com/kb/59/480.html

KeithM · ‎02-20-2019

The issue is with the browser. It most likely won't happen with Chrome. See http://support.sas.com/kb/62/388.html

KeithM · ‎12-26-2018

Here is a sample that I wrote on this subject. http://support.sas.com/kb/60/267.html

KeithM · ‎05-29-2018

In the readme file (https://github.com/sassoftware/sas-sdk-for-iOS-examples/blob/master/README.md) There is a note that says the following: "NOTE: Because Swift does not yet have ABI compatibility, we are required to package the swift runtime with the built framework. This means that consumers of the framework must compile apps that use the framework with the same swift version as was used for compiling the framework. For release 8.22, the framework was built with Xcode 9.2 (9C40b)."

KeithM · ‎05-08-2018

The VA versions supported are the same as the requirements documented as if you were downloading SAS Mobile BI from the App store which are VA versions 7.3, 7.4, 8.1, and 8.2) The biggest version requirement is the Xcode version. The SDK was compiled using xcode version 9.2. So if you are trying to run the SDK with the latest version of XCode version 9.3 then it is not going to work. The GitHub readme file explains this: https://github.com/sassoftware/sas-sdk-for-iOS-examples/blob/master/README.md "Because Swift does not yet have ABI compatibility, we are required to package the swift runtime with the built framework. This means that consumers of the framework must compile apps that use the framework with the same swift version as was used for compiling the framework. For release 8.22, the framework was built with Xcode 9.2 (9C40b)."

KeithM · ‎01-26-2018

You can see an example of Data driven content by simply dragging over the Dynamic Text object onto the canvas. If you look at the source html code behind the scenes then you will see that the default view is data driven content. Initially, I tried to reference my html files from another server, but I was not successful. I had success when I placed my html (data driven content) on my VA server in /opt/sas/viya/home/var/www/html/htmlcommons. I can then reference the file using this syntax: http://yourVAserver/htmlcommons/yourfile.html You can test this by taking the source code mentioned above and save it to the htmlcommons directory.

KeithM · ‎12-08-2017

If you have VA 7.4 then the you can take advantage of a prompt of type Character List. Thus, if you have a multi select prompt, the parameter can capture all of the values that are selected. You can then add a Text Object to your report and simply put the cursor where you want the parameter value and add the parameter on the roles tab of the text object. See below.

KeithM · ‎12-08-2017

I created this sample that is similar to what you want: http://support.sas.com/kb/59/907.html Keith M.

KeithM · ‎12-07-2017

If you have a prompt on the report then you can add a parameter to the report. Typically when a report opens, the parameter value is missing. Thus, you could add a filter to both List table that looks something like: If MyParameter Missing then 1=0 else 1=1

Online Status	Offline
Date Last Visited	‎05-14-2025 12:43 PM

Re: Issue with passing filters from a graph to another section

Re: Bar chart 3 measures with different axis y scales

Re: Bar chart 3 measures with different axis y scales

Re: Bar chart 3 measures with different axis y scales

Re: Dropdown Filters: How to display names different from the underlyi...

Re: Parameter for filter descriptions - 'current value' not possible

Re: Generate the excel file from code

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: SAS visual Analytics

Re: Required input for SAS VA dashboard report link

Viya Jobs that Create Multiple Output Files

Re: SAS Visual Analytics Date slider

Re: Dropdown Filters: How to display names different from the underlyi...

Re: Required input for SAS VA dashboard report link

Re: Generate the excel file from code

Re: Required input for SAS VA dashboard report link

Re: SAS visual Analytics

Re: Distinct Subpopulation Divided by Distinct Population

Re: SAS VA formul with a string condition

Re: How to calculate a percent of total of quarter?

Re: Text input at Page control in SAS VA 8.3.1

Re: what is difference between formatted data and detailed data when e...

Re: Stored Process to create, view and download report in Excel in Vis...

Re: Sorting bars in a bar chart based on measures instead of categorie...

Re: How to remove null value in data tip in bar chart ?

Re: Run STP on demand

Re: Error when trying to run the sample project for SAS Mobile SDK on ...

Re: Which VA Version for SASKit API

Re: Data Driven Content in SAS VA 8.2

Re: Displaying checkbox selections

Re: Displaying checkbox selections

Re: SAS VA 7.4 - How do I prevent a List Table Object from loading up...