Hi,   I am trying to run the code using CAS server instead of EG with the following code:   proc sql; update mylib.dataset_a x Set column_wanted=1 where exists (select column_A from mylib.dataset_b y and x.person=y.person and x.date>=y.date and y.date>=x.date-366); quit;   Wondering what i should be putting in SAS Studio in order for it to work. Thanks! ... View more

Hi I'm looking to create a new column in the same table like below where the columns are from the same category and value 1 is the numerator and value 2 is the denominator:      Category 1     Value 1 Value 2 New Value (Value 1/Value2) Measure 1 1 5 0.20 Measure 2 2 6 0.33 Measure 3 3 7 0.43 Measure 4 4 8 0.50   Thanks.   Update: I'm looking to achieve this under SAS Visual Analytics. ... View more