Programing for new calculated iteam

Saurabh77 — Fri, 23 Aug 2019 10:49:11 GMT

Hello Everyone,

Please understand the query bit correctly.

I have one value 'X' and for that i have thousands of observations (Values basically lie withing 0 to 200)

Now what i want to build is a programing to set diffrent limits to this 'X'.

Example - I want to see how many observations are above 100 (Value of X)

In same program I should be able to see this results if i apply filter to see all the observations above 75 or lets say all the observations above 50 and so on...

Now I wrote following program (I know somehow i need to get rid of this ELSE ...but quetions is how?).

IF ( 'X' > 100 )
RETURN 'For 100'
ELSE ( 
  IF ( 'X' > 75 )
  RETURN 'For 75'
  ELSE ( 
   
 IF ( 'X' > 50 )
    RETURN 'For 50'
    ELSE 'other' ) )W

hat results it is showing is...For the limit of 100 it is showing right results ..but when i tried to see results for 50 or 75..it is showing me all the observations above 50 or 75 but below 100.

What i want to see is all the observation above 75 and 50.

Could you please help for this on bit urgent basis.

I will really appriciate.

Best Regards,

Saurabh

Re: Programing for new calculated iteam

FredrikE — Fri, 23 Aug 2019 14:22:52 GMT

If you are using VA7.4 or above you can use parameters.

1. create a new numeric parameter

2. assign the parameter to an input object (like slider, input text)

3. create a filter either directly on the data (data set filter) or on your object. The filter should look something like "x > [parameter name]"

This should work so if you set the parameter to 75 the data shown will be greater than 75.

//Fredrik

topic Programing for new calculated iteam in SAS Visual Analytics

Programing for new calculated iteam

Re: Programing for new calculated iteam