data have; input id s_date ddmmyy9. hf adm_Date ddmmyy9.; cards; 1 1/1/2005 1 2/2/2004 1 7/7/2005 0 . 2 4/3/2004 0 . 2 2/2/2005 1 6/7/2005 2 . 0 . 3 . 0 . 3 4/4/2006 1 8/8/2005 ; run; proc sql ; create table want as select * from have where id not in (select distinct id from have where s_date < adm_date and hf=1) ; quit; ... View more

one way data have; input x $37.; cards; the first site is www.abc.com www.187878723.com is the second website. www.computer.com is the second website. ; run; data want ; set have; www=index(x, "www."); com=index(substr(x,www+4), ".com"); if www and com then website=substr(x,www,com+7); drop www com; run; ... View more

Yes. You just need to read about  IF Statement, Subsetting, and understand what it is equivalent to. ... View more

You can us COMPRESS function to get rid of all single quotation in your variables. Or you can use SUBSTR if your variable contains other desired single quotation other than the one in the beginning. For example data test; input x $; x=compress(x,"'"); cards; 're34 '466 'terew ; run;   ... View more

In the DELIMITER= statement you specify list of individual delimiters, in this example you have two individual delimiters a and b.   The question now is, What if we have two or more consecutive delimiters? You have two cases for that:   1- DELIMITER= alone Any combination of consecutive delimiter are treated as only one delimiter. So if you deleted the statment DSD in the infile statment from your example. In the dataset example: 1aa2ab3 will be treated as: 1 aa 2 ab 3 as if  1,2,3   2- DELIMITER= with DSD Consecutive delimiters are treated individually even if they are consecutive. In the dataset example: 1aa2ab3 will be treated as: 1 a Missing a 2 a Missing b 3 as if 1, , 2, , 3 ... View more