在线等！急问！！谢谢！！

shiyiming

如果一个数据集source中只有一个变量，不知道有多少个观测，比如
tom
xx
a
ff
.....

如果想把这些观测在新的数据集mydata中连接起来,变成一行观测，如tomxxaff...
该怎么写？

谢谢！！

shiyiming

my level is low as i have to create a macro symbol first.
[code:25rpt7fk]
proc sql noprint;
      select x into :y separated by '' from source;
quit;
data mydata;
     y="&y";
run;
[/code:25rpt7fk]
or i'll have to use more steps
[code:25rpt7fk]
data source;
        input x $;
datalines;
tom
xx
a
ff
;
proc transpose data=source out=source1(drop=_name_);
        var x;
data mydata(keep=x);
        set source1;
        x = cats(of _char_);
run;
[/code:25rpt7fk]
or manually
[code:25rpt7fk]
data source;
        input x $;
datalines;
tom
xx
a
ff
;
data mydata(keep=y);
        if 0 then set source nobs=nobs;
        y = repeat(' ', vlength(x)*nobs);
        do until(eof);
                set source end=eof;
                y = cats(y,x);
        end;
run;
[/code:25rpt7fk]

shiyiming

Thanks！ Great Help！