Hello RW9, I agree with you. but he wants to calculate in SAS VA.  data_null_'s answer is about back end (SAS EG) data calculation and Mike's Answer is suitable when the columns are in date format. In front end (SAS VA) we are not able to  change Character to Numeric (we are able to change Date format to numeric format), in this case we have only one alternative i.e.., if else statement  to achieve his requirement. Thanks & Regards, Teja Surapaneni ... View more

Hello Raj, Can you share your 'Week of' column, Teja ... View more

Hi, You can't show character to numeric format............... Alternative: In SAS VA IF ( 'Month'n In ('Jan') ) RETURN 1 ELSE (   IF ( 'Month'n In ('Feb') )   RETURN 2   ELSE (     IF ( 'Month'n In ('Mar') )     RETURN 3     ELSE (       IF ( 'Month'n In ('Apr') )       RETURN 4       ELSE (         IF ( 'Month'n In ('May') )         RETURN 5         ELSE (           IF ( 'Month'n In ('Jun') )           RETURN 6           ELSE (             IF ( 'Month'n In ('Jul') )             RETURN 7             ELSE (               IF ( 'Month'n In ('Aug') )               RETURN 8               ELSE (                 IF ( 'Month'n In ('Sep') )                 RETURN 9                 ELSE (                   IF ( 'Month'n In ('Oct') )                   RETURN 10                   ELSE (                     IF ( 'Month'n In ('Nov') )                     RETURN 11                     ELSE (                       IF ( 'Month'n In ('Dec') )                       RETURN 12                       ELSE . ) ) ) ) ) ) ) ) ) ) ) You can achieve your requirement by doing above. Thanks & Regards, Teja Surapaneni ... View more

Hi Joy@sas, Thanks for your information about 7.2, I don't have any experience on SAS VA 7.2,  I heard that 7.2 have couple of advanced features. Thanks, Teja   ... View more

Hello, Which version you are using? You can use List (Controls) instead of drop down list in section prompts. But every month you have to change the dates, it would not be automated. Can you share "Week of" Logic. Thanks & Regards, Teja Surapaneni. ... View more

Hello Silvia, In SAS Visual Analytics Home Page  Click On Help (?) Button ----> About SAS Visual Analytics Hub  ---> Configuration Details ----> System. Hope This will help you. Thanks & Regards, Teja Surapaneni. ... View more

Hello, If you want to refresh your excel data in sas va, You have to use VDB(Visual Data Builder) in SAS VA, SAS(R) Visual Analytics 7.1: User's Guide Hope this will help you. Thanks & Regards, Teja SUrapaneni. ... View more

Hi, There is a related discussion Thanks & Regards, Teja Surapaneni ... View more

Hello, In present versions both way Interactions are not possible. If you want, there are alternative ways to achieve this. Thanks & Regards, Teja Surapaneni. ... View more