Hi Art, I would like to skip this question. Even I am not so clear with this requirement. Thanks for your valuable time in response for this question. ... View more

Tom, Many of us use procs import and export because we figure that SAS would have made the task easier and with more capabilties than we could have accomplished on our own.  Unfortunately, that isn't always the case as we have discovered with procs import and export. Hey, we could also accomplish building a neural net, logistic regression, or what have you in a datastep as well but, I think, most of us would simply use the procs included with Enterprise Miner and SAS/STAT. Me thinks that your comment should be taken as a wake up call to those who are responsible for procs import and export.  Some of our colleagues and I are doing a presentation at SGF2012 related to proc import, specifically about importing tables that one might copy from the web.  We, too, had to build code in a datastep because proc import didn't provide the necessary capabilities.  Obviously, a much better job could have been done if we had access to the actual source code. ... View more

I think that  For your situation , the best way is to SQL. data member; input (a1-a8) (& $20.); cards; 12345      Kimberly      cowan       32 Moore ave            .                Nassau            NY               11556 ; run; data demo; input (a1-a8) (& $20.); cards; 12345      Kimberly      cowan       130 Jerusalem st      apt #415          Nassau            NY               11556 12345      Kimberly      cowan       32 Moore ave             .                          Nassau            NY               11556 12345      Kimberly      cowan       130 Jerusalem st      apt #415          Nassau            NY               11556 12345      Kimberly      cowan       130 Jerusalem st      apt #415           Nassau            NY               11556 12345      Kimberly      cowan       32 Moore ave              .                          Nassau            NY               11556 ; run; proc sql noprint; create table want as select * from   demo natural join   (select * from demo except select * from member ); quit; Ksharp ... View more

I'm sure he will appreciate that.  But, if you don't indicate that the correct answer has been given, others will still spend time trying to provide you with a solution. ... View more

Thanks Art297.. I got the exact output.. ... View more

One way of doing it might be: data need;   set have;   retain claim;   if not missing(clam) then claim=clam; run; proc sql noprint;   create table want (drop=claim) as     select * from need       group by claim         having month(max(paiddate)) eq 6           order by lineno ; quit; ... View more

data have;   input (CLAM      LNNO        IND) ($);   cards; 12345    001          Y 12345    002          Y 12345    003          Y 23456    001            Y 23456    002            N 34567    001            Y 34567    002            N 78968    001            Y 78968    002            Y 78968    003            Y ; run; proc sql noprint; create table want as   select *    from have     group by clam      having count(distinct ind) eq 1 and ind='Y' union all corresponding      select *    from have     group by clam      having count(distinct ind) eq 2 and ind='N'; quit; Ksharp ... View more

Art, You are correct.  I was obviously not paying attention. Art ... View more

Thanks Howles for your help.. ... View more

     Thanks Tom..I can able to open with Wordpad. ... View more

It is another varying version of  Howles's code . data have ; input CODE $   SPECIALTY $  ; cards ;   PS  OBGYN PS  SURG PS1 OBGYN PS1 ANES PS1 NEPH PS2 OBGYN PS2 NEPH ; run; proc freq data=have noprint; format code $2.; tables code*specialty/list out=want(drop=percent) nocum nopercent; run; Ksharp ... View more

Thanks Duke !! ... View more