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 ... View more

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. ... View more

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. ... View more

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. ... View more

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

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 ... View more

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. ... View more

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 ... View more

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 ... View more

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 ... View more

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 ... View more

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   end else   desired_output = `COCD`   i = 0 ... View more

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   end else   desired_output = `COCD`   i = 0 ... View more