Dear Cynthia,
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
sravan
sravan
sravan
What i have to do no
and one more is
can we give single cell reference is sas
like _c2_6
_c2_ col
6 row
Hi:
SAS is not Excel. So if you are using CALL DEFINE for formatting, then you need to just:
CALL DEFINE('_c2_','style','style={attr=value}');
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:
http://support.sas.com/resources/papers/proceedings12/189-2012.pdf
cynthia
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.