topic Re: how avoiding proc sorting before proc transpose in SAS Procedures

how avoiding proc sorting before proc transpose

michtka — Tue, 19 Jun 2012 13:18:37 GMT

Hi everyone,

in terms of avoiding the sorting step before transpose it, if you cehck my code, it look like that using proc freq (commented) or proc summary, the proc sorting is neccesary:

any suggestion to avoid it (not proc sql, please), or if not, an explanation of why not?

Thanks. V

    proc sort data= old1 nodupkey;
    by subjid randtext soc;
    run;

    /*proc freq data=old1 noprint;
    tables randtext*soc/out=fold1 (drop=percent);
    run;*/

   proc summary data=old1 nway;
   class randtext soc/missing;
   output out=probe (drop=_type_);
   run;

* is always this proc sorting neccesary before the proc transpose by soc?;

    proc sort data=probe out=sprobe
    by soc;
    run;

    proc transpose data=sprobe out=tprobe;
    by soc;
    id randtext;
    var _freq_;
    run;

Re: how avoiding proc sorting before proc transpose

data_null__ — Tue, 19 Jun 2012 13:32:29 GMT

If you change the order of the variables in PROC SUMMARY CLASS statement from

class randtext soc/missing;

to
class SOC randtext / missing;

You can remove the PROC SORT step.

The data output from PROC SUMMARY are "SORTED" by _TYPE_ and class variables. Similar to BY _TYPE_ SOC RANDTEXT;

Since you use NWAY you only have one _TYPE_ you can ignore it.

Re: how avoiding proc sorting before proc transpose

Alpay — Tue, 19 Jun 2012 13:32:41 GMT

If you modify your code as follows you won't need proc sort after step proc summary as proc summary generates sorted output by class variables.

I don't have data to test it but give it a try.

proc summary data=old1 nway;

class soc randtext/missing;

output out=probe (drop=_type_);

run;

    proc transpose data=probe out=tprobe;
    by soc;
    id randtext;
    var _freq_;
    run;

Re: how avoiding proc sorting before proc transpose

michtka — Tue, 19 Jun 2012 13:51:56 GMT

Brilliant, Thanks.

Re: how avoiding proc sorting before proc transpose

michtka — Tue, 19 Jun 2012 13:52:20 GMT

Briiliant, Thanks.