topic Output dataset in SAS Programming

Output dataset

SASPhile — Tue, 03 Apr 2012 16:55:24 GMT

PROC MEANS DATA=final_row NWAY ;

CLASS mco agegroup gender RiskGroup ;

/* VAR metric ;*/

OUTPUT OUT=final N=cnt ;

RUN;

by commenting out the var statement there is no output dataset created.But how to create an outputdataset

Hima — Tue, 03 Apr 2012 20:41:15 GMT

Tested on one of my data set and working fine

PROC MEANS DATA = TMP39 NWAY;
CLASS FEE;
OUTPUT OUT=FINAL N=CNT ;
RUN;

PROC PRINT DATA = WORK.FINAL;
RUN;

NOTE: There were XXXXX observations read from the data set TMP39.

NOTE: The data set WORK.FINAL has 2 observations and 4 variables.

NOTE: Compressing data set WORK.FINAL increased size by 100.00 percent.

Compressed is 2 pages; un-compressed would require 1 pages.

NOTE: The PROCEDURE MEANS printed pages 45-56.

NOTE: PROCEDURE MEANS used (Total process time):

real time 40.04 seconds

user cpu time 25.06 seconds

system cpu time 1.20 seconds

Memory 2402k

OS Memory 9508k

Timestamp 4/03/2012 3:40:09 PM

Page Faults 0

Page Reclaims 314

Page Swaps 0

Voluntary Context Switches 3500

Involuntary Context Switches 990

Block Input Operations 0

Block Output Operations 0

Reeza — Tue, 03 Apr 2012 21:04:36 GMT

proc means data=sashelp.class nway noprint;

class sex age;

output out=final n= /autoname;

run;

Works for me as well. If you just want a count though, could use proc freq.

proc freq data=final_row noprint;

tables mco*agegroup*gender*RiskGroup/out=final;

run;

SASPhile — Wed, 04 Apr 2012 15:23:03 GMT

Thanks.