concatenation1&delete

 Delete : delete unwanted data or variables

proc import datafile='C:\Documents and Settings\mobileclub\Desktop\source\xls\data.xls'
out=we dbms=excel replace;
sheet='sheet3$';
run;

data we1;
set we;
drug_dose=drug||'('||dose||')';
drug_dose=compress(drug_dose);
adevevt1=scan(adevents,1);
adevent2=scan(adevents,2);
drop adevents;
run;

proc print data=we1;
run;

proc import datafile='C:\Documents and Settings\mobileclub\Desktop\source\xls\data.xls'
out=ty dbms=excel replace;
sheet='sheet1$';
run;

data ty1;
set ty;
surname=scan(fname,1);
i=index(fname,' ');
name=substr(fname,i+1);
if gender='f' then g1='female';
else g1='male';
drop fname gender i;
rename g1=gender;
run;

proc print data=ty1;
run;

data ty2;
set ty;
if gender ='f' then delete;
run;
proc print data=ty2;
run;

data ty3;
set ty;
where gender ne 'm';
run;

proc print data=ty3;
run;