Wednesday, November 24, 2010

how to remove Brakes of cell (SAS)

data val;
infile"c:\value.csv" DLM="'" DSD MISSOVER;
informat name $130.;
format name $130.;
input 
if index (Name'"') gt 0 then do;
input / Name_a :$75. @;
end;
run;
data conc;
set val;
name=compress (compbl(Name||' '||Name_a);
output;
Name = '';output;
run;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.