How to make each value a variable in SAS?

Sapkota — Wed, 11 Jun 2014 16:07:45 GMT

I have hundreds of value in the following format in one SAS dataset:

ID Chemical Value

AS4001X abc 1.4

AS4001X def 3.2

AS4001X ghi 3.4

BC4002Y abc 2.1

BC4002Y def 4.3

BC4002Y ghi 5.4

..................

and so on

I would like is to change each value of 'Chemical' into a variable so that I get the new dataset that look like this:

ID abc def ghi

AS4001X 1.4 3.2 3.4

BC4002Y 2.1 4.3 5.4

...........

Please suggest how do I go about about making such modification of dataset. I thank you all in advance.

Sapkota

Re: How to make each value a variable in SAS?

Reeza — Wed, 11 Jun 2014 16:19:10 GMT

Look into Proc Transpose

PGStats — Wed, 11 Jun 2014 16:22:34 GMT

Typical task for Proc Transpose:

proc transpose data=have out=want(drop=_name_);

by ID;

var Value;

id Chemical;

run;