> There is in 9.2, a
> delimiter= option that allows you to change the
> delimiter from a comma to a tab character (which is
> 09'x, I believe) for ODS CSV.
That will be a nice feature. I look forward to using 9.2, soon perhaps.
The features of the FILE and PUT statement plus the call routine VNEXT make the data step solution fairly concise.
filename FT24F001 temp lrecl=512;
data _null_;
file FT24F001 dsd dlm='09'x;
set sashelp.shoes(obs=3);
if _n_ eq 1 then link nameRow;
put (_all_)(:);
return;
nameRow:
length _LABEL_ $128 _NAME_ $32;
if _n_ eq 1 then do;
do while(1);
call vnext(_name_);
if _name_ eq '_LABEL_' then leave;
_label_ = vlabelx(_name_);
put _label_ @;
end;
put;
end;
return;
run;
data _null_;
infile FT24F001;
input;
list;
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.