String

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

/*string*/
data dm1;
set dm;
len=length(fname);
ind1=index(fname,'a');
ind2=index(fname,'rao');
sc=scan(fname,3);
up=upcase(fname);
qt=quote(fname);
cp=compress(fname);
cp=compress(fname,'a');
tr=translate(fname,'A','a');
sub1=substr(fname,2,8);
run;
proc print data=dm1;
run;