cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
need_some_help
‎09-01-2015
  • 56 Posts
  • 12 Likes Given
  • 0 Solutions
  • 0 Likes Received

Wrong ordering or grouping?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-23-2011 07:28 AM
‎09-23-2011 07:28 AM
And is the way I've described in 'Sep 20, 2011 1:54 AM'-post incorrect, or unwanted/not optimal for SAS? (to know whether I've understood proc report grouping-ordering concept right..) ... View more

Wrong ordering or grouping?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-23-2011 07:23 AM
‎09-23-2011 07:23 AM
Didn't use formats before (except rather simple cases)... And haven't even thought to get the result I need by that way) But it's very interesting, and very SAS-like)) I'll take note of that, thanks a lot! ... View more

Wrong ordering or grouping?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-20-2011 02:08 AM
‎09-20-2011 02:08 AM
It's (I hope - was) not 'sql-way of thinking', just my incorrect way) ... View more

Wrong ordering or grouping?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-20-2011 01:54 AM
‎09-20-2011 01:54 AM
I've corrected my code that way and got the results I need (I did correctly? or I'm doing wrong again and needed results prevent me from 'seeing' that?): proc report data=for_report nowd;       column region ordsale agent_info sale;       define region / group order=data;       define ordsale /display order=data /*noprint*/;       define agent_info/display;       define sale /display; run; As I've understood (probably my 'oracle-way' of thinking doesn't let me to see the point): when I need ordering by certain variables in my report I should specify an appropriate order in COLUMN-statement and group relevant variables (all ordering-variables except last one). Is that right? I guess it's very stupid of me not 'to see' that, but I'm trying to put things right. Many thanks for your help! ... View more

Wrong ordering or grouping?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-19-2011 11:03 AM
‎09-19-2011 11:03 AM
The information I found: The four types of sorts that can be specified with the ORDER= option are: • ORDER=FORMATTED Sorts by a variable’s formatted values (DEFAULT) • ORDER=DATA Sorts in the order that the variable values are encountered in the data set                 <--- • ORDER=INTERNAL Sorts by a variable’s unformatted values • ORDER=FREQ Sorts by frequency counts of the variable values So I've organised my data in proc sql the way I needed (data set FOR_REPORT) and expected this organization wouldn't change. I can't get my mistake(( Maybe there are more appropriate way to organise data with SAS-tools? ... View more

Wrong ordering or grouping?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-19-2011 03:36 AM
‎09-19-2011 03:36 AM
After proc sql (and as I need): REGION AGENT AGENT_INFO SALE ORDSALE city1      agent2      agent2            4           4 city1      agent1      agent1            1           1 city1      agent6      others            1           -1 city2      agent3      agent3            3           3 city2      agent4      agent4            2           2 city2      agent5      others            7           -1 after proc report: REGION AGENT_INFO SALE ORDSALE city1      agent2                 4      4              agent1                 1      1              others                  1      -1 city2      others                  7      -1              agent3                 3      3              agent4                 2      2 (it seems like 'others'-rows are 'grouped' somehow....) ... View more

Wrong ordering or grouping?

by Calcite | Level 5 in SAS Enterprise Guide
‎09-19-2011 03:22 AM
‎09-19-2011 03:22 AM
Hi! I thought I would have no problems with ordering (it has seemed clear to me) but I've got some unexpected result. And can't find reasons why it is going like that. And in consequence of that I get wrong report. Can anyone show me where am I wrong? Example: data sales; input agent$ sale; datalines; agent1 1 agent2 4 agent3 3 agent6 1 agent4 2 agent5 7 ; run; /*need to place certain agents in a special group ('others') in the end of agent's list sorted in descending order for every region*/ proc sql; create table for_report as select   (case    when agent in ('agent1','agent2','agent6') then 'city1'    when agent in ('agent3','agent4','agent5') then 'city2'    end) as region,   (case    when agent in ('agent5','agent6') then 'others'    else agent    end) as agent_info,   sale,   (case    when agent in ('agent5','agent6') then -1    else sale    end) as  ordsale from work.sales order by region,ordsale desc; quit; proc report data=for_report nowd; column region agent_info sale ordsale; define region / group order=data; define agent_info / group order=data; define sale /group order=data; define ordsale /group order=data /*noprint*/; run; After proc sql I get the result I need, but after proc report - unexpected((      (though I'm trying to 'save' proc sql results) ... View more

rows and columns in gchart legend

by Calcite | Level 5 in SAS Enterprise Guide
‎09-19-2011 01:56 AM
‎09-19-2011 01:56 AM
Cynthia, many thaks! I didn't expected that is so simple. And with value option I can specify the order I need. So I can change my legend in any way! Thanks!!! ... View more

rows and columns in gchart legend

by Calcite | Level 5 in SAS Enterprise Guide
‎09-15-2011 07:29 AM
‎09-15-2011 07:29 AM
Hi! In my Vbar chart I have a legend with a lot of entries, the most appropriate place for it is under the chart (with the same width as chart - fit page). So it is shown there but there is a little problem - values are listed first from left to right and then from top to bottom ('rows-filling') and I need them to go first from top to bottom and then from left to right ('columns-filling'). I've tried to use Accross= and Down= options but it didn't help. I've also got known about rowmajor | colmajor - but I don't know how to use them correctly (there are no examples at all....). Does anyone have any ideas? P.S. To avoid misunderstanding:                HAVE                                                      NEED name1     name2     name3                        name1     name3     name5 name4     name5     name6                        name2     name4     name6 ... View more

2 (two) line string in one row (cell) - proc report

by Calcite | Level 5 in SAS Enterprise Guide
‎09-15-2011 06:53 AM
‎09-15-2011 06:53 AM
Found details in http://communities.sas.com/message/34271#34271 ... View more

2 (two) line string in one row (cell) - proc report

by Calcite | Level 5 in SAS Enterprise Guide
‎09-15-2011 03:15 AM
‎09-15-2011 03:15 AM
Hi! I've got such a problem: I have a column in proc report with name&surname. And now I need name and surname to be in different lines but in the same row which gives some data for this person. As I've tried to find some information I read this topic http://communities.sas.com/message/18915#18915 (Columns and totals (report or computab) ?), and there is something useful (as I think) - post from Mar 24, 2009 9:18 AM (3rd possibility - about line feed symbol) but unfortunately with no details. If anyone knows how to do it, please, help... ... View more

Groups order in grouped stacked bar chart.

by Calcite | Level 5 in SAS Enterprise Guide
‎09-14-2011 08:19 AM
‎09-14-2011 08:19 AM
It's funny vut only after posting this message I found somethinf useful in documentation I've already read)): there is rather simple way: %_eg_conditional_dropds(WORK.SORTTempTableSorted); PROC SQL; CREATE VIEW WORK.SORTTempTableSorted AS   SELECT T.type, T.week, T.agent, T.num FROM WORK.SAMPLE as T ; QUIT; Legend1 FRAME ; Axis1 STYLE=1 WIDTH=1 MINOR=NONE ; Axis2 STYLE=1 WIDTH=1 ; /*!!!!!!!!!*/ Axis3 order=('week2' 'week1' 'week3') ; /*!!!!!!!!!*/ ; TITLE; TITLE1 "title"; FOOTNOTE; FOOTNOTE1 "footnote"; PROC GCHART DATA=WORK.SORTTempTableSorted ; VBAR   type / SUMVAR=num SUBGROUP=agent GROUP=week CLIPREF FRAME TYPE=SUM LEGEND=LEGEND1 COUTLINE=BLACK RAXIS=AXIS1 MAXIS=AXIS2 /*!!!!!!!!!*/ GAXIS=AXIS3; /*!!!!!!!!!*/ ; RUN; QUIT; %_eg_conditional_dropds(WORK.SORTTempTableSorted); TITLE; FOOTNOTE; Merphy's law))) ... View more

Groups order in grouped stacked bar chart.

by Calcite | Level 5 in SAS Enterprise Guide
‎09-14-2011 07:53 AM
‎09-14-2011 07:53 AM
Hi, I use grouped&stacked bar chart for my data set. And I need groups in that bar chart to have certain order. When using the simplest bar chart you can do it with midpoints option. But I can't find the way to use it correct for grouped&stacked bar chart. For example: /*data*/ data sample; length week agent type $12.; do week='week1','week2','week3'; do agent='agent1','agent2','agent3','agent4'; do type='type1','type2'; num=ceil(ranuni(0)*10); output; end; end; end; run; /*gchart*/ %_eg_conditional_dropds(WORK.SORTTempTableSorted); PROC SQL; CREATE VIEW WORK.SORTTempTableSorted AS   SELECT T.type, T.week, T.agent, T.num FROM WORK.SAMPLE as T ; QUIT; Legend1 FRAME ; Axis1 STYLE=1 WIDTH=1 MINOR=NONE ; Axis2 STYLE=1 WIDTH=1 ; ; TITLE; TITLE1 "title"; FOOTNOTE; FOOTNOTE1 "footnote"; PROC GCHART DATA=WORK.SORTTempTableSorted ; VBAR   type / SUMVAR=num SUBGROUP=agent GROUP=week CLIPREF FRAME TYPE=SUM LEGEND=LEGEND1 COUTLINE=BLACK RAXIS=AXIS1 MAXIS=AXIS2 ; RUN; QUIT; %_eg_conditional_dropds(WORK.SORTTempTableSorted); TITLE; FOOTNOTE; Is there any way to have groups in a special order: e.g. 'week2' 'week1' 'week3'?     (using      midpoints='week2' 'week1' 'week3'      gives incorrect result...) Thank's in advance! ... View more

Different page orientation in PDF-report.

by Calcite | Level 5 in SAS Enterprise Guide
‎08-31-2011 10:14 AM
‎08-31-2011 10:14 AM
Thanks for the information, but unfortunately I needed different orientations in one file( ... View more

Different page orientation in PDF-report.

by Calcite | Level 5 in SAS Enterprise Guide
‎08-31-2011 09:33 AM
‎08-31-2011 09:33 AM
Thanks - that is exactly the one I've just read)) it's a pity... ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links