Hi - How do i use a reference table to create multiple 'or'  filters For example, this  code i'm looking for would read the below reference table and create a filter with the below criteria. I need an automated/dynamic way to create this filter because the code itself cannot be changed, but new records can be freely inserted and deleted from the reference table. Ideally I would like to use this reference table and store this filter criteria inside macro variables, and then apply these macro variable filters to a different table.   if ((state='NJ' and ID_Number=1) or (state='NY' and ID_Number=4));     Reference Table   ... View more

I have a table that contains order ID numbers. When an order is updated, the observation for that order isn't updated. Instead, a new observation is inserted into the dataset so there would be two observations for a single order.   There is a variable that identifies the iteration of the observation for a particular order ID. So, the initial order will be iteration 1. If an order is updated, there will be a 2nd record that that order where the iteration number is 2.  How would I query this table to return only observations with the highest iteration number for a each order id? ... View more

Hi All!   The below macro will conditionally set the macro variables &r1 and &r2 to either 0 or 1 based on the following criteria, where &sub. is a random number (which was generated by another macro variable). if &sub. is a whole number  then r1=0 and r2 = 0 if &sub. has a decimal that rounds down then r1 = 1 and r2 = 0 if &sub. has a decimal around rounds up then r1 =1 and r2=1   However, i can't get the macro to work. When i use this macro i get the error message "Statement is not valid or is used out of proper order". Any tips?   %macro round_test (sub); %let r1 = x; %let r2 = y; %let round = %eval(%sysfunc(int(&sub.))-&sub.); %if &round = 0 %then %do;           x=0;           y=0; %end; %else %if round(&round) = 0 %then %do;           x=1;           y=0; %end; %else %do;          x=1;          y=1; %end; run; %mend;   Hey Guys, I beleive i solved this with the below code:   %macro round_test (sub); %let round = %eval(%sysfunc(int(&sub.))-&sub.); %if &round = 0 %then %do;       %let r1=0;       %let r2=0; %end; %else %if round(&round) = 0 %then %do;      %let r1=1;       %let r2=0; %end; %else %do;       %let r1=1;       %let r2=1; %end; run; %mend; ... View more