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: 
B2SAS
‎09-01-2015
  • 7 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: PROC REPORT summary report help

by Calcite | Level 5 in SAS Procedures
‎08-28-2015 07:49 AM
‎08-28-2015 07:49 AM
Thank you very much XIA. This worked exactly the way I was expecting. Very much appreciated for your help. Prasad. ... View more

Re: PROC REPORT summary report help

by Calcite | Level 5 in SAS Procedures
‎08-26-2015 10:36 AM
‎08-26-2015 10:36 AM
Hi Xia..Thank you so much for your quick response. I do get the desired result, except the net differences at the end as shown in the report. I am not sure whether I can use COMPUTE statement or something else. Regards, Prasad. ... View more

PROC REPORT summary report help

by Calcite | Level 5 in SAS Procedures
‎08-25-2015 09:26 PM
‎08-25-2015 09:26 PM
Dear All, I hope you will be able to help me in getting the desired result. I am currently working on a specific requirement to generate the below report: However, when I tried to generate the same, I could able to generate the report in the  below format:                                                            STATUS TOTAL  14M08  14M09 14M10  14M11  14M12 15M01  15M02  15M03  -------------------------------------------------------------------------  CLOSE 199     12     10 15     11      8 9     19     10  OPEN 583     46     42 33     61     50 32     34     65  ……. Till the Aug-15. Now, I got stuck  while addressing the below requirements: Displaying totals on the right most side. Displaying the net differences at the end of the report. Covert the MONTH-YEAR format  YYMM  as 'MMM-YY' . I tried several options but unable to get any idea to move forward. My knowledge to SAS is limited and I am  in the process of enhancing it. The sample input data file look like this:           OPEN_                   MNTH_    Obs CLOSE_ST    MNTH_YM    CNT_OPCL                                              1 OPEN       14M08         1     2 OPEN       14M08         1     3 OPEN       14M09         1     4 OPEN       14M09         1     5 OPEN       14M10         1     6 OPEN       14M10         1     7 CLOSE      14M08         1     8 CLOSE      14M08         1     9 CLOSE      14M09         1    10 CLOSE      14M09         1    11 CLOSE      14M10         1    12 CLOSE      14M10         1 Please help me in this regards to be able to generate the report. Regards, Prasad. ... View more

Re: seeking help on PROC report.

by Calcite | Level 5 in SAS Procedures
‎08-18-2015 10:41 AM
‎08-18-2015 10:41 AM
Thank You data_null_; When I used ORDER=DATA, I was getting the result, with one exception. Later, when I used ORDER=INTERNAL, I got my desired results. As you indicated, I removed PROC SORT steps. ... View more

Re: seeking help on PROC report.

by Calcite | Level 5 in SAS Procedures
‎08-18-2015 10:36 AM
‎08-18-2015 10:36 AM
Thank you very much RW9 for your solution. It worked fine. ... View more

seeking help on PROC report.

by Calcite | Level 5 in SAS Procedures
‎08-18-2015 09:51 AM
‎08-18-2015 09:51 AM
Hi All, I am novice to SAS and trying to generate a report using PROC report. My requirement is to generate the summary report based on number of users added in last 12 months and display their totals: Sample report: OPEN                       OPEN YEAR      OPEN             TOTAL           MONTH    -----------------------------    2014   08                  46           09                  42           10                  33           11                  61           12                  50    2015   01                  32           02                  34           03                  65           04                  44           05                  57           06                  51           07                  41           08                  13 -----                         ----- TOTAL                         569 This is working fine as long as the onen month is populated as numeric values such as 01,02,03 etc. When I try to format the numeric month value with the corresponding alphabetic name, I am getting a different order. I tried all the options that I have known and of no use. 2014   AUGUST        46         DECEMBER      50         NOVEMBER      61         OCTOBER       33         SEPTEMBER     42 2015   APRIL         44         AUGUST        14         FEBRUARY      34         JANUARY       32         JULY          40         JUNE          51         MARCH         65         MAY           57 -----             ----- TOTAL               569 my proc report sample code is given below: PROC SORT DATA=USER_ENTRY;                                                  BY OPEN_YEAR OPEN_MONTH_YYMM OPEN_MONTH;                                                                                               PROC REPORT DATA = USER_ENTRY SPACING= 2 HEADSKIP HEADLINE NOCENTER;            TITLE  "                                                        ";      TITLE3 "NUMBER OF USERS OPENED IN LAST 12 MONTHS";                 WHERE OPEN_DATE > "&DATE_12MTH";                                       COLUMNS OPEN_YEAR OPEN_MONTH N;                                        DEFINE OPEN_YEAR   /GROUP 'YEAR  ' WIDTH=05;                           DEFINE OPEN_MONTH  /GROUP  'MONTH ' WIDTH=09                                                 FORMAT = $OPEN_MONTH_FMT.;                                                                            DEFINE N /  'TOTAL ' WIDTH=05;                                         RBREAK AFTER /  SUMMARIZE OL;                                              COMPUTE AFTER;                                                            OPEN_YEAR='TOTAL:';                PROC FORMAT;    VALUE $OPEN_MONTH_FMT        '01'      = 'JANUARY'      '02'      = 'FEBRUARY'     '03'      = 'MARCH'        '04'      = 'APRIL'        '05'      = 'MAY'          '06'      = 'JUNE'         '07'      = 'JULY'         '08'      = 'AUGUST'       '09'      = 'SEPTEMBER'    '10'      = 'OCTOBER'      '11'      = 'NOVEMBER'     '12'      = 'DECEMBER'      ;                       Please help me solving this issue. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Quick links