Monday, November 7, 2011

Proc Print;Something Interesting

Q1.How to omit the obs columns and replace with say variable empid,
  id empid;?
Ans:
#you can sort the data with sort statement but you don't want the original dataset changed.
  out= option; e.g out =newdata;
#breakdown your listing
  with BY statement
#to do totals and subtotals
  with SUM statement
#you don't want to repeat the id variable in first column
  use the same variable in by and var statement
  by id
  var id
#how to print the variable names horizantly
  HEADING=horizontal option
_______________________

proc print has one property by which one can print observations of last created dataset only
by default.e.g.
proc print;
run;
using this property one can find -Is the dataset is created or dataset is modified?
________________________


No comments:

Post a Comment