I am misunderstanding using multiple set statements.  Here is a piece of code, it's an idea I have but not getting me what I want: data D3A; set complete_sort; by power_id; count+1; if first.power_id then count = 1; where pass_date <> . and '30aug2012'd <= default_date_end <= '01jul2013'd; if count > 1; output; set complete_sort; run; I would like to take count > 1 from one dataset and then join it back to the original dataset and pull all of the records, including where count = 1.  Can you show me how to do that in one step with multiple set statements? Thank You, ... View more

Happy New Year, I would like to perform the following using sas code, not proc sql.  I know using the max function for two variables and a group by statement would work but I'm looking for another solution.  Thank You in advance: data have; infile cards dsd; informat date mmddyy10.; format date date9.; input acct $ date default $; cards; 00001,01/01/2000,pd npl 00001,01/01/2000,pd 00001,01/01/2001,pd 00002,02/01/2000,pd npl 00002,02/01/2000,pd 00002,02/01/2010,pd ; run; data want; infile cards dsd; informat date mmddyy10.; format date date9.; input acct $ date default $; cards; 00001,01/01/2001,pd npl 00002,02/01/2010,pd npl ; run; ... View more

Proc import is bringing in a weird date, from 2014 to 2074.  Is there anyway to correct it after it has been imported, or via proc import?  I don't know that I can informat using proc import.  I know I can datastep informat but if I can get around that (file changes monthly) I would much prefer too. Thanks in advance. ... View more

Running the code below I am expecting to see a 'null' for the check2 variable from the third row.  I get a 'wrong'.  Can someone explain why? Thank You, data ifc; infile cards dsd; input one two three; cards; 1,2,3 ,2,3 1,,3 1,3,  ; run; data test; set ifc; check1 = ifc(one,.,'one is null'); check2 = ifc(two = 2,'right','wrong','null'); run; ... View more