BookmarkSubscribeRSS Feed
vishu2
Fluorite | Level 6

Hi everyone. 

 

i want to create a calculated item in SAS VA ;- 

Details:- 

 

RA Applicable = Y if there is an RA record and activity_exists = 'Y'
RA Applicable = N if activity_exists = 'N' or RA record does not exist for that country​

 

Activity_exist has 2 items Y and N 

Thanks in advance.

2 REPLIES 2
Mo_NHS
Fluorite | Level 6
I am using VA 7.3 but should be the same :
1. Once you added the table to the VA report right click on any of the field or menu and select calculated field,
2. A small screen will pop up, type a name for your calculated file and choose the data type,
3. its all drag and drop from here: under the login operator choose "if & else" statement and "And" to build the logic you need.
4. you can drag and drop the fields you want to use in your logic from the fields listed on the left hand side.
Saurabh77
Fluorite | Level 6

hello

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 2 replies
  • 2479 views
  • 0 likes
  • 3 in conversation