topic Re: multivaraite data to univariate with varaible names as count in SAS Data Management

multivaraite data to univariate with varaible names as count

sapasupu — Sat, 25 Apr 2020 22:12:38 GMT

Hello everyone,

I have a data structured as

I want to convert it into univariate with a new variable as below

How can I able to achieve that? Tried MV to UV conversion but the Item variable displays only the counts of the Items but not the variable names. Also, PROC TRANSPOSE didn't work. Any clues or help will be appreciated.

Re: multivaraite data to univariate with varaible names as count

PaigeMiller — Sat, 25 Apr 2020 23:06:31 GMT

Use an array with the VNAME function.

UNTESTED CODE

data want;
    set have;
    array x onions--eggs;
    do i=1 to dim(x);
        do j=1 to x(i);
            items=vname(x(i));
            output;
        end;
    end;
    drop i j onions--eggs;
run;

Re: multivaraite data to univariate with varaible names as count

sapasupu — Sat, 25 Apr 2020 23:10:03 GMT

Thank you. It worked.