Hi, I need to export (using proc export) a data to flat file (with tilde delimiter ~ ) without header record in the output. data test; input name $ city $ state $; cards; Tim orlando Florida John jersey newjersey Bob newyork newyork ; run; output should be : Tim~orlando~Florida John~jersey~newjersey bob~newyork~newyork Please let me know Thanks. ... View more

Hi, I have 2 tables member and memberdemohistory, need to select the records that are different from the member table.Member table will have unique memno id.But in memberdemohistory , the members can have multiple records.so i need to compare with the member table record. For example, Member Table Memno  Firstname   Lastname   address1             address2    city            county           zipcode 12345      Kimberly      cowan       32 Moore ave                            Nassau            NY               11556 Demohistory Memno  Firstname   Lastname    address1                  address2         city            county           zipcode 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 Output should be : Memno  Firstname   Lastname    address1                  address2         city            county           zipcode 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       130 Jerusalem st      apt #415           Nassau            NY               11556 Please let me know how to get this desired output. Thanks in Advance. ... View more

Hi, I have a dataset with clam ,line and ind field. 1. when the whole clamno has the rev =Y  only, then need to select Y . 2.  When the clamno has the rev=Y and N , then need to select only 'N'. 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 34567 003 N 78968 001 Y 78968 002 Y 78968 003 Y ; output should be: 12345  001 Y 12345  002 Y 12345  003 Y 23456 002  N 34567 002 N 34567 003 N 78968 001 Y 78968 002 Y 78698 003 Y Thanks in Advance ... View more