skillman Tracker

Re: Using measures in list or dropdown controls.

skillman — Fri, 19 Feb 2016 14:55:26 GMT

Ashwani,

The filters allow you to use the list box (which only supports categories) and translates your selection in the list box to a measure that would appear in a report object. In my example, I have a drop-down list which depending on the value selected pushes different categories to a line chart. Choosing Business Unit of 'CCE' forces the line chart to show status 'B' & 'A', otherwise if nothing is chosen, default the list chart to show status 'N'.

You can setup your filter and line chart the same way. If Profit is selected, show 'Profit' in the line chart. If Cost is selected show only 'Cost' in the line chart. If both 'Profit' and 'Cost' are chosen then begin adding multiple categories based on the selection to the line chart.

If you have data you can share I can replicate this in VA for you.

Thanks,

-shawn

Re: VA 7.2 how to get a timestamp of last refresh (dataset) into your report

skillman — Tue, 18 Aug 2015 12:36:38 GMT

In my environment the LASR load pulls the most recent data from views in Oracle with a predefined prefix. In those views I have a column titled "Refresh Date" and the value is sysdate. When the views are queried the "Refresh Date" column automatically gets the value of the current timestamp in Oracle. This works great for us and any user can look at the "Refresh Date" column in VA to see when the data was last updated.

-shawn

Re: Display result in a textbox

skillman — Mon, 17 Aug 2015 19:56:13 GMT

You can create a table and hide the vertical and horizontal lines and show only one cell. This cell would be populated with the sum of sales value.

Re: link items selected in a filter to text

skillman — Thu, 09 Jul 2015 12:26:50 GMT

Have you looked into parameters and a list table? In the filters set the parameter and in the list table your advanced filter would be set to equal the value (parameter) in the filter.

Re: To compare two input files in Data Management Studio 2.4

skillman — Fri, 26 Jun 2015 20:54:40 GMT

The code I supplied essentially created a user-defined function vs. using an existing function. Creating a user-defined function can enable the users to see what is happening behind the scenes with the pattern() function.

Either way will work.

Re: Change date format

skillman — Thu, 25 Jun 2015 20:16:50 GMT

What software are you using? Base SAS, Enterprise Guide, SAS Data Management, SAS Data Integration, etc.?

-shawn

Re: Computing scoring of Business Rules using Expression node in SAS DataFlux DMP

skillman — Mon, 22 Jun 2015 16:14:25 GMT

Ronny,

Change the data type to a 'real' and you will get the precision you are expecting:

real Score

Score = No of Triggers \ No of Rows Processed

-shawn

Re: To compare two input files in Data Management Studio 2.4

skillman — Wed, 10 Jun 2015 13:12:23 GMT

Shah,

I just used the job specific data node for demonstration purposes. If you replace this with your data inputs, assuming the column names are the same, the logic will work as expected.

This is the expression logic used in the 'Field Profile' node:

/* Pre-Expression */

hidden real field_length

hidden integer cnt

string char_type

cnt = 1

field_length = len(`JC`)

char_type = ''

while cnt <= field_length

begin

if isnumber(mid(`JC`, cnt, 1))

char_type = char_type & ' ' & 'numeric'

else

char_type = char_type & ' ' & 'alpha'

cnt = cnt + 1

end

cnt = 1

What this expression does is loop through the entire value to determine if you have all numeric, all alpha or a mix (alphanumeric). Because your input (the JC Column) can be characters or numeric the column type is set to a character (string) field. You must look at a profile of the field's value instead of the field type based on your requirement.

-shawn

Message was edited by: shawn skillman Unable to reattach the DDF.

Re: To compare two input files in Data Management Studio 2.4

skillman — Tue, 09 Jun 2015 13:22:18 GMT

Shah,

Here is a solution in DM Studio. This solution works regardless of the field type on the input table. It scans each character and creates a profile of the field (JC). The data is joined and then an expression identifies where the field profile is different and outputs that data. The expression is quite simple:

`char_type_prev` != `char_type_curr`

The data job is also attached.

-shawn

Re: DataFlux Data Management Studio 2.6 Table Profiling Error -> Task: Analyse Table -> Error: Frequency distribution engine failed to initialize: failed to allocate memory

skillman — Wed, 27 May 2015 16:57:31 GMT

Do you know how may records are in the table? Try removing some of the metrics, if they are not needed. Frequency and Pattern Frequency Distribution can use more memory than other metrics.

-shawn

Re: Creating a view in a sql database using Proc SQL

skillman — Thu, 14 May 2015 16:26:31 GMT

This explicit pass-through SQL (vs implicit in your original post) works fine for me:

PROC SQL;

connect to oracle (path='' user='' password='');

execute( create view LEAD_ACCOUNT_V as

select *

from "Lead_Account"

) by Oracle;

quit;

Re: String limitation of 255 characters in Global Function/UDF of Data Management Studio

skillman — Fri, 01 May 2015 15:34:52 GMT

You are correct that the in stating that string symbols may be declared with a size. If you assign a value to a string symbol, it is truncated/increated to this size. If you do not specific a size, 255 is used by default.

This is an example from the Expression Reference document for format of setting the string size:

string(20) person

integer x

integer y

integer age

Age=10

if Age < 20 then

person="child"

else

person="adult"

if Age==10

begin

x=50

y=20

end

// nested if/else

I hope this helps.

-shawn

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

skillman — Mon, 27 Apr 2015 12:26:50 GMT

It is a SAS Data Management Expression code. The original poster asked for help within SAS Data Management Studio, and this was exactly what he wanted.

-shawn

Re: Question to convert the field type in Data Management Studio 2.4

skillman — Fri, 24 Apr 2015 17:17:19 GMT

This was answered here:

but to save you a click here is the solution:

/* Pre-processing Expression*/

string desired_output

hidden integer i

desired_output = ''

i = 0

/*Expression*/

if len(`COCD`) < 4

begin

desired_output = `COCD`

while i < (4 - len(`COCD`))

begin

desired_output = '0' & desired_output

i = i + 1

end

else

desired_output = `COCD`

i = 0

Re: Question to include value '0' as prefix for the field values in Data Management Studio 2.4

skillman — Fri, 24 Apr 2015 17:14:06 GMT

This expression will give you what you want:

/* Pre-processing Expression*/

string desired_output

hidden integer i

desired_output = ''

i = 0

/*Expression*/

if len(`COCD`) < 4

begin

desired_output = `COCD`

while i < (4 - len(`COCD`))

begin

desired_output = '0' & desired_output

i = i + 1

end

else

desired_output = `COCD`

i = 0

Re: Cumulative Sum with grouped variables

skillman — Wed, 22 Apr 2015 16:28:04 GMT

This should give you close to what I think you want based on your description:

proc sql;

create table want as

select

storeid,

productcode,

productsubcode,

days,

sum(sold) as cum_sold

from

have

group by

storeid,

productcode,

productsubcode,

days;

quit;

Re: Dynamic header for the Line chart

skillman — Fri, 10 Apr 2015 14:44:47 GMT

Swapna,

You could also create an interaction between your list table and a second list table that is formatted to appear like a header:

-shawn

Re: How do you use the Data Panel for SAS Visual Analytics?

skillman — Thu, 02 Apr 2015 12:56:09 GMT

1) I never change the grouping. I always use ‘by classification.’

Re: How to separate charaters and numerics by using Data FLux

skillman — Thu, 02 Apr 2015 12:52:37 GMT

Here is a solution which will loop through the whole input string and pick the values that are numeric or characters and assign them to a temp variable until the end of the loop. Also see attached:

Pre-Processing Expression:

hidden string temp_string_num

real string_Num

hidden string temp_string_char

string string_char

hidden integer cnt

hidden integer i

string_Num = 0

temp_string_num = ''

temp_string_char = ''

string_char = ''

cnt = 0

i = 0

Expression:

cnt = len(`input_string`)

while i <= cnt

begin

if isnumber(mid(`input_string`, i, 1)) == true

temp_string_num = temp_string_num & mid(`input_string`, i, 1)

else

temp_string_char = temp_string_char & mid(`input_string`, i, 1)

i = i + 1

end

i = 0

string_num = temp_string_num

string_char = temp_string_char

Re: Display label with values.

skillman — Fri, 27 Mar 2015 12:56:20 GMT

Ashwani,

Does this data exist in a data source? If so, you could use a list table and filter the table to show only those labels and respective value pairs. Also, remove the header and the grids on the list table to make it more visually appealing.

-shawn