We're upgrading to 3.5 in the next weeks. In my understanding at least I can use the common task model language which will come in handy for populating dynamic list boxes based on the data.
I have managed to achieve more or less what I wanted to do.
The form displays in VA and once the run button is pressed the form disappears and the graph draws having applied correctly the parameter supported filter. I have achieved this by suppressing the _target="tab" option in the html code.
What is still missing is to have a button that brings back the form again because the graph persists. When I draw whatever object on the report pane then the web content refreshes and the form is shown again. How can I include a going back button in the job code part?
<!DOCTYPE html>
<html lang="en">
<head>
<title>Return SGPLOT Image Output</title>
<link rel="stylesheet" href="/SASJobExecution/theme">
</head>
<body role="main" class="jobexec_body">
<form class="jobexec_form" action="/SASJobExecution/" >
<input type="hidden" name="_program" value="/Public/renato/labor/test2"/>
<input type="hidden" name="_action" value="execute"/>
<div class="jobexec_sample_header">SAS<sup>®</sup> Job Execution</div>
<h1 class="jobexec_sample_name">Return SGPLOT Image Output</h1>
<p>
The SGPLOT procedure creates a bar chart using the SASHELP.CLASS
table, and returns the binary image data to the client.
</p>
<label for="age_min">Output format:</label>
<select name="age_min" id="age_min" class="jobexec_sample_select">
<option value="12">twelve</option>
<option value="13">thirteen</option>
<option value="14">fourteen</option>
</select>
<br/>
<br/>
<label for="_odsstyle">ODS style:</label>
<select name="_odsstyle" id="_odsstyle" class="jobexec_sample_select">
[More values here]
<option value="HTMLBlue" selected>HTMLBlue</option>
[More values here]
</select>
<br/>
<br/>
<hr/>
<input type="submit" value="Run code" class="jobexec_sample_input_submit"/>
<input type="checkbox" name="_debug" id="_debug" value="log"
class="jobexec_sample_input_checkbox"/>
<label for="_debug">Show SAS Log</label>
</form>
</body>
</html>
* Declare input parameters;
%global _ODSSTYLE
age_min;
ods graphics / imagemap;
proc sgplot data=sashelp.class;
where age gt &age_min;
hbar age / tip=(AGE) ;
run;
quit;
Hello Rajesh,
This functionality is not currently available but it is something we are interested in as a possible future addition.
Currently, the best way to indicate change would be to make a display rule as follows:
1. Create a "Difference from previous period" calculation by right-clicking a measure on the Data pane and selecting "New Calculation" :
2. Create your table. Add the measure and the date column. Add the "Difference from previous period" calculation to the Hidden role if you don't want to show it, or add it to the Columns role if you do.
3. Create a display rule on the Rules pane that is based on the "Difference from previous period" calculation and colors the measure values according to whether the value is less than 0
Set the Placement option to be the original measure rather than the calculated measure.
Your result should look like this:
Where the value is less than the previous value, it is colored by the display rule. You can repeat these steps for additional measures as needed.
A limitation of this approach is that you MUST include the date column in your table.
I hope this helps,
Sam
You can work around it for List tables (no crosstabs, unfortunately):
The Good/Bad column is a character calculated item defined as below:
The arrows (and other symbols) can be obtained from an unicode table. For this example, I've used:
🠕 - Upwards Arrow with Equilateral Arrowhead: U+1F815 - Unicode Character Table (unicode-table.com)
What's nice about the links above is that you can simply find what you want, use the copy button, and paste the symbol in the VA expression.
Then all you need to do is define a display rule similar to the formula used in the expression to assign the color, as seen in the first screenshot.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.
-
2983 views
-
11 likes
-
-
