Go Back   Rhinocerus > Newsgroup > Newsgroup comp.soft-sys.sas

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 12-17-2008, 02:17 PM
Amit Panda
Guest
 
Posts: n/a
Default creating custom table using Proc Report problem

Hi,

I have to make a tabular report, using proc Report, for the sample input
file below:

----------------------
x | y | n1 | n2 | c1
----------------------
A | 1 | 22 | .9 | m
B | 1 | 20 | .4 | n
C | 1 | 32 | .3 | mn
A | 2 | 11 | .5 | op
B | 2 | 5 | .7 | mo
C | 2 | 29 | .1 | on
----------------------

and desired output report should look like:


|| y = 1 || y = 2 ||
---------------------------------------------
x || n1 | n2 | c1 || n1 | n2 | c1 ||
-------------------------------------------------
A || 22 | .9 | m || 11 | .5 | op ||
B || 20 | .4 | n || 5 | .7 | mo ||
C || 32 | .3 | mn || 29 | .1 | on ||

That according proc report syntax: x should be a group variable, y should
be across, where as n1 & n2 are analysis while c1 is display (character).

If I specify column statement with c1 in it, proc Report gives error as it
allows grouping of numerical variables together, and does NOT include c1,
without a statistic.

The problem is how to group (n1, n2, c1) & place it under y?

Regards,
Amit
Reply With Quote
Alt Today
Advertising
 
and become member of Rhinocerus
Standard Sponsored Links

Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Proc means - Now proc report doubt Adriano Rodrigues - Instituto GPP Newsgroup comp.soft-sys.sas 0 08-20-2007 06:08 PM
Re: PROC FREQ--DATA STEP--MODELING QUESTION Gerstle, John Newsgroup comp.soft-sys.sas 0 06-06-2007 07:47 PM
Re: PROC FREQ--DATA STEP--MODELING QUESTION data _null_; Newsgroup comp.soft-sys.sas 0 06-06-2007 07:45 PM
Re: multicollinearity in proc logistic Bora Yavuz Newsgroup comp.soft-sys.sas 0 11-21-2006 02:02 PM
custom table of contents using ODS PDF and proc report Maxim Newsgroup comp.soft-sys.sas 0 05-16-2006 10:18 PM



All times are GMT. The time now is 10:39 PM.


Copyright ©2009

LinkBacks Enabled by vBSEO 3.3.0 RC2 © 2009, Crawlability, Inc.