How do I convert table with rows representing fields into columns in SAS EG?

SASAlex101 — Wed, 06 Jul 2022 21:11:02 GMT

Hi I have a dataset in list format which is an output from powershell that I've cleaned into two columns called Field and Value and it looks like this:

Field Value

ID 1

ColA 123

ColB ABC

ColC D1E

ID 2

ColA 456

ColB DEF

ColC G6H

How do I convert this data into something like:

ID ColA ColB ColC

1 123 ABC D1E

2 456 DEF G6H

I've tried proc transpose, but it will just transpose all the columns as separate ones.

Re: How do I convert table with rows representing fields into columns in SAS EG?

Reeza — Wed, 06 Jul 2022 22:35:42 GMT

data have;
input Field  $ Value $;
cards;
ID       1
ColA   123
ColB   ABC
ColC   D1E
ID       2
ColA   456
ColB   DEF
ColC   G6H
;;;;
run;

data addID;
set have;
retain row;
if field='ID' then row=Value;
run;

proc transpose data=addID out=want ;
by row;
id field;
var value;
run;

proc print data=want;run;

topic Re: How do I convert table with rows representing fields into columns in SAS EG? in SAS Programming

How do I convert table with rows representing fields into columns in SAS EG?

Re: How do I convert table with rows representing fields into columns in SAS EG?