topic PROC PRINT - BY - unwanted variable in the output in SAS Programming

PROC PRINT - BY - unwanted variable in the output

nrk1787db1 — Fri, 11 Dec 2015 10:28:41 GMT

Hi,

I'm working on a simple report and getting stuck at a point

I'm running below snippet for printing the data after all the work is done

PROC PRINT DATA = R LABEL NOOBS ;
 VAR   TRAN_DATE                 
       DEP_AMTN                  
       TRANRMKS ;                
 SUM   DEP_AMTN ;                
 BY    T_MONTH ;                 
 WHERE DEP_AMTN > 0 ;            
RUN ;

I'm getting the expected output but with a "T_MONTH" on the left side of the total amount generated by SUM(DEP_AMTN) statement as below

TRANSACTION MONTH=1                                                
                                                                   
TRANSACTION         DEPOSIT                                        
   DATE              AMOUNT            TRANSACTION REMARKS         
                                                                   
02-Jan-2015          100.00                 ABCDEF
30-Jan-2015        48953.00                 GHIJKL
-----------    ------------                                        
T_MONTH            49053.00

Could anyone help me to get rid of it ?

Re: PROC PRINT - BY - unwanted variable in the output

data_null__ — Fri, 11 Dec 2015 13:57:07 GMT

RTM

SUMLABEL NOSUMLABEL SUMLABEL='RTM'

Re: PROC PRINT - BY - unwanted variable in the output

nrk1787db1 — Fri, 11 Dec 2015 14:23:00 GMT

Hi data_null_,

Thank you for your response, I'm running this code in z/Os environment, perhaps I should have begin with this in my first post.

If I use SUMLABEL alone with LABEL (as below)

PROC PRINT DATA = R LABEL SUMLABEL NOOBS ;
 VAR   TRAN_DATE                 
       DEP_AMTN                  
       TRANRMKS ;                
 SUM   DEP_AMTN ;                
 BY    T_MONTH ;                 
 WHERE DEP_AMTN > 0 ;            
RUN ;

then I get below output

TRANSACTION MONTH=1                                                       
                                                                          
                          DEPOSIT                                         
TRANSACTION DATE           AMOUNT            TRANSACTION REMARKS          
                                                                          
02-Jan-2015                100.00    		   ABCDEF
30-Jan-2015              48953.00    		   GHIJKL 
-----------------    ------------                                         
TRANSACTION MONTH        49053.00

T_MONTH is now TRANSACTION MONTH

But when I try using NOSUMLABEL or SUMLABEL='RTM' then SAS displays below error message:

ERROR 22-322: Syntax error, expecting one of the following: ;, BLANKLINE, DATA, DOUBLE, HEADING, LABEL, N, NOOBS, OBS, ROUND, ROWS, SPLIT, STYLE, SUMLABEL, UNIFORM, WIDTH.

Can you please help?

Re: PROC PRINT - BY - unwanted variable in the output

ballardw — Fri, 11 Dec 2015 15:22:43 GMT

Please show the code you attempted to use that generated the error message. You may have set the option incorrectly.

Re: PROC PRINT - BY - unwanted variable in the output

nrk1787db1 — Fri, 11 Dec 2015 15:29:53 GMT

Hi ballardw,

I used below code

PROC PRINT DATA = R NOSUMLABEL NOOBS ;     
 VAR   TRAN_DATE                           
       DEP_AMTN                            
       TRANRMKS ;                          
 SUM   DEP_AMTN ;                          
 BY    T_MONTH ;                           
 WHERE DEP_AMTN > 0 ;                      
RUN ;

Re: PROC PRINT - BY - unwanted variable in the output

data_null__ — Fri, 11 Dec 2015 15:40:08 GMT

The extensions to SUMLABEL seem to only exist in SAS 9.4. I Don't see how it can be done using earlier versions.

Re: PROC PRINT - BY - unwanted variable in the output

nrk1787db1 — Mon, 14 Dec 2015 11:15:20 GMT

Hi Data _null_,

Thank you for your promt response, I'm running this on 9.3 so till our SAS gets upgraded to 9.4 I'll keep this in progress