03-10-2006 02:21 PM
09-27-2012 11:21 AM
I need a wide table containing 24 columns and 4 rows.
Problem is first column contains Grouping values it need wide width column and remaining need a same width.
Am doing across the 2 variable that is giving 24 column(12 from each).
am applying style in both across variable and grouping variable separately in define statement but group variable values are coming in three line
like below which need to present in single line
What i have to do no
and one more is
can we give single cell reference is sas
09-27-2012 12:13 PM
SAS is not Excel. So if you are using CALL DEFINE for formatting, then you need to just:
But it's not clear to me that you are really talking about a CALL DEFINE, since you say you are using your style in an ACROSS item and a GROUP item DEFINE statement.
Also, I don't understand what you mean when you say "but group variable values are coming in three line like below which need to present in single line" -- because usually with GROUP items, if you have repetitious values, the repetitive ones are suppresses see screen shot for an example of what I mean. For REGION (a GROUP item), the EAST and WEST values are NOT repeated on every ROW. So I'm not sure how you are getting repeated values, as you describe.
In addition, it would be better for you to start your own discussion thread in the ODS forum, instead of adding to a posting from 2006. I almost didn't read this one because it was so old, I thought there was a glitch in the forum. What you describe isn't really related to the forum posting I made. My forum posting was about how to change style attributes to squeeze more information on a page. Your question is about something that seems DATA and PROC REPORT specific -- not about styles.
It is hard to provide you with constructive advice without seeing your code or your data or getting some idea of how your entire PROC REPORT program is coded, including the ODS statements which would indicate the destination you were interested in.
For some suggestions about posting questions to the forum, have a look at this paper: