topic Re: How would I Reverse Order of All Variables, Rows, and Columns in SAS Programming

Important question

austinrousevelt — Thu, 04 Oct 2018 02:06:29 GMT

Re: How would I Reverse Order of All Variables, Rows, and Columns

Astounding — Thu, 08 Mar 2018 06:03:30 GMT

Suggestion: start with reversing the order of the rows. The other pieces of the problem are much more difficult.

Re: How would I Reverse Order of All Variables, Rows, and Columns

srinath3111 — Thu, 08 Mar 2018 07:27:59 GMT

Hi,

Reversing of all the observations in a data set is an easy process, We can do it in many forms.one of the solution.

data want;
do i=nobs to 1 by -1;
set have point=i nobs=nobs;
output;
end;
stop;
run;

Re: How would I Reverse Order of All Variables, Rows, and Columns

gamotte — Thu, 08 Mar 2018 10:01:19 GMT

Hello,

Here is a start, using @srinath3111 solution for reversing row order.

proc sql noprint;
    SELECT nvar
    INTO :ncols
    FROM dictionary.tables
    WHERE libname="SASHELP" and memname="CLASS";
quit;

data _NULL_;
    set sashelp.vcolumn (where=(libname="SASHELP" and memname="CLASS")) end=eof;

    array lengths (&ncols.) $5. _TEMPORARY_;
    array columns (&ncols.) $32. _TEMPORARY_;

    lengths(&ncols.-varnum+1)=ifc(strip(type)='char',cats('$',length,'.'),cats(length,'.'));
    columns(&ncols.-varnum+1)=name;

    if eof then do;
        call execute('data want; format ');
        do i=1 to &ncols.;
            call execute(cat(' ',columns(i),lengths(i)));
        end;
        call execute('; do i=nobs to 1 by -1; set sashelp.class nobs=nobs point=i; output; end; stop; run;');

        /* reverse values of numeric variables */
        call execute('data want; set want; array nums(*) _NUMERIC_;');
        do i=1 to &ncols.;
            if substr(lengths(i),1,1) ne '$' then do;
                call execute(cat(columns(i),'=input(reverse(put(',columns(i),',',lengths(i),')),',lengths(i),');'));
            end;
        end;
        call execute('run;');
    end;

run;

Re: How would I Reverse Order of All Variables, Rows, and Columns

Ksharp — Thu, 08 Mar 2018 12:53:14 GMT

If "values within cells" are all a string, then that would be easy for IML code and data step.