Online File

How to use this page

---

Rick Aster: Professional SAS Programming Secrets: Contents

Chapter 9
Program 9o
Transposing

---

*
  Professional SAS Programming Secrets
  Program 9o
  Transposing
*;
filename crop1 "crop.txt";
data work.prod;
   infile crop1;
   input year corn tomatoes wheat soybeans;
run;

title1 'Before Transposing';
proc print data=work.prod;
run;

proc transpose data=work.prod out=work.tranprod name=crop let;
   var corn tomatoes wheat soybeans;
   id year;
   idlabel year;
run;
title1 'After Transposing';
proc print data=work.tranprod;
   id crop;
   label crop='crop';
   var _1985-_1990;
run;