I'm sure there are plenty of ways, here is one: data ref; input var$; cards; 1 2 3 ; run; data table; input var$; cards; 1 2 3 4 5 ; run; proc sql; create table want as select * from table where var not in (     select var from ref); ... View more

There are a lot of different features that you can use to get your desired output.  I'm assuming you are not familiar with proc freq or proc transpose?  Is it necessary to only use proc sql;? ... View more

ne stands for not equal to: data have; infile cards; input Employee_id$  Dept$; cards; 1453253         Accounts 7866341         Sales 2333642         HR 4566333         Accounts 2223355         Operation ; data want; set have; where dept ne 'Sales'; run; ... View more

Did you pull up the first 100 obs and look at the 95th line?  Your code isn't the problem it's the incoming data: data have; infile cards dsd; input a$ g$16.; cards; MM,Total Calls MM,Total Calls MM,Total Calls MM,Total Calls MM,Total Calls MM,Total Calls MM,Total Calls MM,Total Calls MM,Total Calls MM, ; DATA WANT; set have; if g = 'Total Calls' then delete; if scan(a,1) = 'MM' and _N_ = 10 then action = 'Arizona Calls'; run; it works ... View more

1)  You don't have 'THEN DELETE' in the code, only in your question does it say delete. 2) You should pull up the first 100 obs, look at what line 95 has, if it doesn't match your if statement you won't get 'Arizona Calls'. ... View more

Here's a solution for your example.  I would test this with your real data to make sure it gets the desired output. data have; infile cards dsd; informat parent_closure date9.; format parent_closure date9.; input Parent_ID     PR_ID     Value1     Value2     Value3     Parent_Closure; cards; 123,123,12,29,,01JAN2015 123,153,,,45, ; run; data want; set have; by parent_id; retain date; if first.parent_id then date = parent_closure; if missing(parent_closure) then parent_closure = date; drop date; run; ... View more

I cannot tell what you are trying to accomplish with this code.  I would be sure to run what you intend without the macro first, then run the macro and verify the output.  This might be what you are intending to do but I'm not sure: %macro con;                                                                                                                                                                                                                                       data final2;                                                                                                                                                                                                                                              %do i = 1 %to 2;                                                                                                                                                                                                                                          set want&i;                                                                                                                                                                                                                                                                                                                                      %end; if _n_ = round((0.95*2)) then output;                                                                                                                                                                                                                     run;  ;                                                                                                                                                                                                                                                         run;                                                                                                                                                                                                                                             %mend;                                                                                                                                                                                                                                              %con; ... View more

Here is the output I see.  I assume we are using different versions of SAS. Characteristic 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 var1        .   .   .   .   .   .   .   .   .   . var2        .   .   .   .   .   .   .   .   .   . var3        .   .   .   .   .   .   .   .   .   . var4        .   .   .   .   .   .   .   .   .   . var5        .   .   .   .   .   .   .   .   .   . var6        .   .   .   .   .   .   .   .   .   . var7        .   .   .   .   .   .   .   .   .   . var8        .   .   .   .   .   .   .   .   .   . var9        .   .   .   .   .   .   .   .   .   . var10       .   .   .   .   .   .   .   .   .   . var11       .   .   .   .   .   .   .   .   .   . var12       .   .   .   .   .   .   .   .   .   . var13       .   .   .   .   .   .   .   .   .   . var14       .   .   .   .   .   .   .   .   .   . var15       .   .   .   .   .   .   .   .   .   . var16       .   .   .   .   .   .   .   .   .   . var17       .   .   .   .   .   .   .   .   .   . ... View more

Are you able to run the code I provided and look at the output?  If so let me know if this is what you want. ... View more