Online File

How to use this page

---

Rick Aster: Professional SAS Programming Secrets: Contents

Chapter 9
Program 9a
Simple proc steps

---

*
  Professional SAS Programming Secrets
  Program 9a
  Simple proc steps
*;

*
  Input data - from Program 4b
*;
filename planets "planet1.csv";
filename dwarf "dwarfplanet1.csv";

data work.planet;
   length planet $ 16 sequence mass radius 8;
   infile planets dsd;
   input planet sequence mass radius;
run;

data work.dwarf;
   length planet $ 16 sequence mass radius 8;
   infile dwarf dsd;
   input planet sequence mass radius;
run;


title1;


proc print data=work.planet;
run;


proc contents data=work.planet;
run;


proc univariate data=work.planet;
run;


proc freq data=work.planet;
run;


proc corr data=work.planet;
run;


title1 'Planet Ranks';
proc rank data=work.planet out=work.planetrank;
run;
proc print data=work.planetrank;
run;


data work.oa;
   set work.dwarf;
run;
title1 'Before Appending: Dwarf Planets';
proc print data=work.oa;
run;

proc append data=work.planet out=work.oa;
run;
title1 'After Appending: Dwarf Planets and Planets';
proc print data=work.oa;
run;

title1;


proc rank data=work.planet out=work.planetrank;
   var mass radius;
run;


proc print data=work.planet split='~';
   var planet radius mass;
   format radius mass comma10.;
   label radius='Radius~(km)' mass='Mass~(10^21 kg)';
run;


proc print data=work.planet (obs=5);
run;

proc print data=work.planet;
   where planet = 'Jupiter';
run;


title1 'Planets With Standardized Variables';
proc standard data=work.planet out=work.planetstandard mean=0 std=1;
   var mass radius;
run;
proc print data=work.planetstandard;
run;