multivaraite data to univariate with varaible names as count

[sapasupu]

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.

[PaigeMiller · Accepted solution]

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;

[sapasupu]

Thank you. It worked.