I did and it produced 0 observations ... View more

rows. ... View more

I am just trying to keep columns, sc1 through sc5 that have just the values 'a','b', or 'c' by using arrays and not have entries that do not meet the criteria     hence why i was doing set fdata1.test_weekly; where sc1 in('A', 'B', 'C') or where sc2 in('A', 'B', 'C') or where sc3 in('A', 'B', 'C') or where sc4 in('A', 'B', 'C') or where sc5 in('A', 'B', 'C') or where sc6 in('A', 'B', 'C') ; run; ... View more

what do i put in the insert code?   where ACX1 in('ST', 'SU', 'SW') or ACX2 in('ST', 'SU', 'SW') or ACX3 in('ST', 'SU', 'SW') or ACX4 in('ST', 'SU', 'SW') or ACX5 in('ST', 'SU', 'SW') or ACX6 in('ST', 'SU', 'SW') ; How do i accomplish above by using array? ... View more

so what i can do instead of where? I am trying to pull data from AX1 to AX3 if they have A,B, or C.   where ACX1 in('ST', 'SU', 'SW') or ACX2 in('ST', 'SU', 'SW') or ACX3 in('ST', 'SU', 'SW') or ACX4 in('ST', 'SU', 'SW') or ACX5 in('ST', 'SU', 'SW') or ACX6 in('ST', 'SU', 'SW') ; how do i convert this or accomplish above by using array? ... View more

The sample data has a lot of information and rows in his hypothetic data set fdata1.test_weekly; ID NAME sc1 sc2 sc3 sc4 sc5 sc6 1 Bob D A E F G H 2 Sam A D F H I 3 Mike B D E F G 4 Al 5 Steve 6 Sara 7 Tom 8 etc etc ... View more

I am not sure what you mean. I want to compare the values in the dor variables/columns to a start and end date. ... View more

// OK so I am pulling this from a dataset that has a DOR column in YYYYMMDDn8. format One of the values in that columns is 20161101. if the DOR is between 01feb2016 and 31dec2016 then it would be a match if DOR less than or equal to 31DEC16 then it will be match2 FOR EXAMPLE The DOR colum/variable in the dataset has numerous rows with different dates in the YYYYMMDDn8. format one of them is 20161101. When I run it, it does not produce match data test3; set lib.test_data(keep dor); length dummy $10; if ( '01FEB16'd <='01NOV16'd <='31DEC16'd ) then dummy="match"; else if DOR <= '31DEC16'd then dummy="match2"; end; run; // ... View more

// OK so I am pulling this from a dataset that has a DOR column in YYYYMMDDn8. format One of the values in that columns is 20161101. if the DOR is between 01feb2016 and 31dec2016 then it would be a match if DOR less than or equal to 31DEC16 then it will be match2 FOR EXAMPLE   The DOR colum/variable in the dataset has numerous rows with different dates in the YYYYMMDDn8. format one of them is 20161101. When I run it, it does not produce match   data test3; set lib.test_data(keep dor);   length dummy $10;   if ( '01FEB16'd <='01NOV16'd <='31DEC16'd ) then dummy="match";   else if DOR <= '31DEC16'd then dummy="match2";   end; run; // ... View more