topic How to assign all column names and respectively their values in another column in SAS Programming

How to assign all column names and respectively their values in another column

abhityagi — Thu, 27 Dec 2018 20:01:17 GMT

Hi Team,

I have a sas table and in that table I have 20 columns and all 20 columns have certain values. And here I want to create another sas table from this table where I should two column. in one column I should have all column names of first sas table and in other table I want to store all the values respective to the column names.

first dataset:

DATA Abhi;

input a b c d e f g h i j k l m;

datalines;

---

;

outcome dataset result:

1st 2nd

a 5

a 4

a 3

b 2

b 6

c 8

d 9

e 10

f 11

g 12

h 13

;

thank!

Re: How to assign all column names and respectively their values in another column

novinosrin — Thu, 27 Dec 2018 20:17:20 GMT

Take a look at proc transpose and sort.

If you could post clear samples,lazy people like me would test the code for you

Re: How to assign all column names and respectively their values in another column

PGStats — Thu, 27 Dec 2018 22:32:12 GMT

You should get that with :

data want;
set abhi;
array _a a--m;
do _i = 1 to dim(_a);
    var = vname(_a{_i});
    value = _a{_i};
    if not missing(value) then output;
    end;
keep var value;
run;

proc sort data=want; by var; run;

(untested)