I'm trying to import a text file that has been extracted from a MUMPS database. However, it is both comma delimited and caret delimited. See example below. Can anyone tell me how to import this type of file?     ^MUC("TXHAMMS",40622,733614) 300^300^300^300^300^300^300^300^300^300 ^MUC("TXHAMMS",40622,733853) 300^300^300^300^300^300^300^300^300^300 ^MUC("TXHAMMS",40622,734148) 300^300^300^300^300^300^300^300^300^300 ^MUC("TXHAMMS2",36708,711017) 200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200 ^MUC("TXHAMMS2",36708,728648) 200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200 ^MUC("TXHAMMS2",36708,731084) 200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200 ^MUC("TXHAMMS2",36708,731869) 200^200^^^^^^^200^^^^^^^200^200^200^200^200^200^200^200^200^200^200 ^MUC("TXHAMMS2",36708,732348) 200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200^200 ^MUC("TXHAMMS2",36708,732351) 200^200^^^^^^^200^^^^^^^200^200^200^200^200^200^200^200^200^^ ^MUC("TXHAMMS2A",34903,733584) 200^^200^200^^200^200^^200^200^^200 ^MUC("TXHAMMS2A",34903,733586) 200^^200^200^^200^200^^200^200^^200 ^MUC("TXHBZLC",40884,719357) 100^100^100^100^100^100^100^100^100^100^^100^100^100^100^100^100^100^100^100^^^^100^100^100^100^100^^100 ^MUC("TXHBZLC",40884,719358) 100^100^100^100^100^100^100^100^100^100^^100^100^100^100^100^100^100^100^100^^^^100^100^100^100^100^^100 ^MUC("TXHBZLC",40884,719425) 100^100^100^100^100^100^100^100^100^100^^100^100^100^100^100^100^100^100^100^^^^100^100^100^100^100^^100 ^MUC("TXHBZLC",40884,719426) 100^100^100^100^100^100^100^100^100^100^^100^100^100^100^100^100^100^100^100^^^^100^100^100^100^100^^100   ... View more

I've been looking online for what seems like hours. Is anyone able to explain why in the following code AND is used between where clauses rather than OR? I'm trying to say that if the variable is in any of the tables then it should be deleted not if it is in ALL of the tables. However, when I use OR it doesn't appear to delete any of the variables but with AND it does.   proc sql ; create table spec2 as select a.* from spec a left join qtnhst.Medpro_spec b on a.accession_num = b.accession_num AND a.lab = b.lab AND a.specimen_first_rpt_date = b.specimen_first_rpt_date left join qtnhst.DL_spec c on a.accession_num = c.accession_num AND a.lab = c.lab AND a.specimen_first_rpt_date = c.specimen_first_rpt_date left join qtnhst.EXCL_spec d on a.accession_num = d.accession_num AND a.lab = d.lab AND a.specimen_first_rpt_date = d.specimen_first_rpt_date left join qtnhst.chng_clnt_hst e on a.accession_num = e.accession_num AND a.lab = e.lab AND a.client_num = e.new_client_num where (b.accession_num is NULL AND b.lab is NULL AND b.specimen_first_rpt_date is NULL) AND (c.accession_num is NULL AND c.lab is NULL AND c.specimen_first_rpt_date is NULL) AND (d.accession_num is NULL AND d.lab is NULL AND d.specimen_first_rpt_date is NULL) order by accession_num, lab, specimen_first_rpt_date, specimen_type, change_date desc ; quit ;   Thanks! ... View more