topic A typical data step problem in SAS Programming

A typical data step problem

MKhandelwal — Sat, 02 Jul 2011 05:43:11 GMT

Hi all,

I have a SAS data set like below:

And I want a new data set to be like this...

Please tell me the solution.

With Best Regards,

Manoj Khandelwal

barheat — Sat, 02 Jul 2011 08:24:03 GMT

Simple solution is to use PROC TRANSPOSE

proc transpose data=chem out=chem2;

var org na ca mg;

by mois;

run;

Default column names will be mois, _NAME_ and COL1

MKhandelwal — Sat, 02 Jul 2011 08:31:04 GMT

Thanks barheat. It works.

data_null__ — Sat, 02 Jul 2011 12:57:06 GMT

Default column names will be mois, _NAME_ and COL1

Use NAME= option and RENAME data set option'

proc transpose name=trt out=chem2(rename=(col1=response))