BookmarkSubscribeRSS Feed
sheren_deep1
Calcite | Level 5

Hi, 

 

I have the following proc tabulate codes 

 

TITLE j=left "Jadual 5.1: Jumlah penduduk mengikut taraf perkahwinan, kumpulan umur, jantina dan negeri, Malaysia, 2010";
Title2 font=bold italic j=left "Table 5.1: Total population by marital status, age group, sex and state, Malaysia, 2010";
title3 j=left " ";
title4 j=left "Jumlah:Malaysia";
Title5 font=bold italic j=left "Total";
ods escapechar='^';

proc tabulate data=work.table5dot1 class AGE_GROUP GENDER Marital_status1;
	var ID;
	table (GENDER={LABEL=' '} ALL='Grand Total') * (AGE_GROUP={LABEL=' '} 
		ALL='Jumlah ^S={font_style=italic}/ Total'), 
		ALL='Jumlah ^S={font_style=italic}/ Total' 
		Marital_status1='Taraf Perkahwinan
	^S={font_style=italic} / Marital status' / 
		Box='Jantina dan kumpulan umur ^S={font_style=italic} / Sex and age group';
	keylabel N=' ';
run;

The above codes generate the following table: 

 

 

 

 

Proc tabulate.PNG

 

However, I need the line separator to be eliminated from the body of the table and only the headers has lines to separate the rows . The output has to be like the following image 

proc tabulate result.PNG

 

 

Could anyone please help me on how to get the output as per the above image. 

 

Thank you. 

1 REPLY 1
SAS_Cares
SAS Employee

Sheren,

See SAS Documentation under Tabulate Procedure - Indenting Row Headings and Eliminating Horizontal Separators http://support.sas.com/documentation/cdl/en/proc/65145/HTML/default/viewer.htm#n1azfrb23t8082n1jk3xq... Appears that might resource might be helpful to you!  

SAS Innovate 2025: Register Now

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!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 687 views
  • 0 likes
  • 2 in conversation