About MikeJenista

MikeJenista · ‎06-26-2018

I checked if a simpler calculation would work: DatePart( Now() ) - timestamp But it did not. I think this is because the underlying SAS date value is not a supported format for VA content, but I can check on it with some folks I know in development.

MikeJenista · ‎06-26-2018

It is a little cumbersome, but you can use the DayOfYear and Year functions to return numeric values from the two dates ('now' and 'timestamp'). Also you have to wrap 'Now()' in a DatePart() function: 365*( Year(DatePart( Now() )) - Year( timestamp ) + DayOfYear( DatePart( Now() )) - DayOfYear( timestamp )

MikeJenista · ‎06-26-2018

(1) This is only partially supported for VA 7.4 (which I think is what you have, the last VA 7.X release but with SAS 9.4). Some objects, like Decision Tree and Forecasting, can be included in reports. But most of the modeling objects (Linear Regression, Clustering, etc) are not supported objects in reports. (2) You should be able to export the scoring script from your model if it is a VS model (cluster, LinReg, LogReg, GLM, DTree). That script can be run in a SAS session against any data with the expected column names for the model. Once you have applied the script to a new data set, you can import the results to either VAE or VAD for further analysis or reporting. For VAD, you would only be able to import the scored values as a column in a table, not the details of the model itself.

MikeJenista · ‎06-26-2018

At first glance, it sounds like an aggregated calculation will work. But what exactly is your 'chart'? A crosstab or list table? A bar chart? The possibilities will be different based on what kind of chart you are using because the number of measures you can assign will be different.

MikeJenista · ‎06-26-2018

FindChar returns a number for the first position of any of the desired chars to find. I think it returns 0 or -1 if none are found, so you need to make a modification to something like: IF ( FindChar (inputs) > 0 ) and then it should work like you want.

MikeJenista · ‎03-08-2018

Ah, wait, I think I understand. Are you using two date items, one for start date and one for end date? If that is the case I don't believe you can create a single filter control that sets both dates. You could define a single advanced filter that uses an AND condition, or add two separate slider controls to set each date individually.

MikeJenista · ‎03-08-2018

When I add a slider to the report prompt area and add a date variable, it shows me a two-slider control use for filtering by range. Similarly, when I add a date item as a filter to a specific object, the default control for this filter is a two-slider range. How are you trying to set up the filter?

MikeJenista · ‎03-08-2018

Is it 7.3 Designer or 7.3 Explorer?

MikeJenista · ‎03-08-2018

I believe you can use a parameter to achieve this. Ranks can take a parameter as the input for the number, and you can add a UI control to set the parameter value. UPDATE: After a quick check, this is correct for 7.4 Designer, but I don't think it works in Explorer.

MikeJenista · ‎03-08-2018

What version are you using? There should be filter objects or properties that convert to a range (two sliders).

MikeJenista · ‎02-14-2018

I see; I think to achieve what you want in VA you might have to separate each program population into its own column. If you don't want to do that on the raw data, you could try making a calculated item for each cohort that checks your combination year item for the program year. If it matches, copy the population value to the calculated item. If it doesn't match, set to 0 or missing. Then, you can aggregate these calculated items by year, and use the period calculations I mentioned earlier.

MikeJenista · ‎02-14-2018

If you are in Designer, you can right-click on the population variable and select 'create'; one of the options should be new difference from previous period, percent difference from previous period, etc. I believe these are dependent on having date items in the data to make the aggregation well-defined, so you might need to import the year as its own column or created a calculated date column from your Year/Program Year column. A similar calculation is available in Explorer.

MikeJenista · ‎02-08-2018

Okay, if I understand correctly, you will still need to do extra steps besides refresh. With your existing process, editing Mytab in SAS will not make changes available to the LASR in-memory copy. You must use 'change data source' and choose the same Mytab data. The dialog should ask if you want to rename or replace, and you can just choose replace. This is the same process as importing the data again, overwriting the name, and then clicking refresh. If you want to make changes to Mytab that will get picked up with just 'refresh' I believe you would have to define a LASR library in your SAS session and make the changes directly on the LASR table loaded in memory.

MikeJenista · ‎02-08-2018

When you change the original data (excel file, csv, sas data set, etc), it still has to be imported to the server. Then the refresh button will load the table into memory again. If you give the table a new name, you should use 'change data source' instead. I don't think 'refresh' will know that you want to use the new version you imported.

MikeJenista · ‎02-07-2018

I would just create a new column that divides this one by 1,000,000. Then you can adjust the trailing digits after the decimal with the standard numeric format options.

Online Status	Offline
Date Last Visited	‎04-08-2020 12:00 PM

Re: SAS VISUAL ANALYTICS 8.2

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: Creating datasets on the fly - SAS VA

Re: how to create group by average column in SAS VA 7.3 crosstab

Re: SAS VISUAL ANALYTICS 8.2

Re: Creating datasets on the fly - SAS VA

Re: MoM growth of the current month in text object

Re: MoM growth of the current month in text object

Re: SAS VISUAL ANALYTICS 8.2

Re: SAS Visual Statistics and Visual Analytics

Re: Creating datasets on the fly - SAS VA

Re: How to change the date expression to numeric after creating 'New C...

Re: How to change the date expression to numeric after creating 'New C...

Re: SAS Visual Statistics and Visual Analytics

Re: Dynamic percentage calculations

Re: SAS VA Calculated Item Btw Numeric and Character Values

Re: How to get date filter on two dates (start date and end date) in S...

Re: How to get date filter on two dates (start date and end date) in S...

Re: How to get date filter on two dates (start date and end date) in S...

Re: interaction on a rank

Re: How to get date filter on two dates (start date and end date) in S...

Re: Year to year rollover calculation

Re: Year to year rollover calculation

Re: Refresh button does not work

Re: Refresh button does not work

Re: How to create million format to measure in SAS VA