topic comma format in proc report in SAS Procedures

comma format in proc report

braam — Sun, 02 Feb 2020 13:15:23 GMT

How should I change my code? The first one works while the second one doesn't. Like the second code, I would like to get the reported numbers formatted with comma.


	*It works;
	proc report data= sashelp.heart missing;
		column status sex, n;
		define status/ group;
		define sex/ across; run;

	*It doesn' work.;
	proc report data= sashelp.heart missing;
		column status sex, n;
		define status/ group;
		define sex/ across format= comma9.2; run;

Re: comma format in proc report

PaigeMiller — Sun, 02 Feb 2020 13:24:08 GMT

You want to put commas in the variable SEX? I am not understanding this.

Re: comma format in proc report

braam — Sun, 02 Feb 2020 13:35:20 GMT

This is what I get from the first code.

Sex

Female Male

Status n n

Alive 1977 1241

Dead 896
1095

This is what I would like to get.

Sex

Female Male

Status n n

Alive 1,977 1,241

Dead 896 1,095

	Sex
Alive	1977	1241
Dead	896	1095

	Sex
Alive	1,977	1,241
Dead	896	1,095

Re: comma format in proc report

PaigeMiller — Sun, 02 Feb 2020 14:00:23 GMT

So you want the comma in the value of N, not in the value of SEX as originally implied by your program.

I do not know if there is a way to format a statistic like N in the column statement. However, it is possible to format N in the CALL DEFINE statement, but you have to compute the statistic N for a specific variable, such as AGEATSTART (or any other variable you'd like to use)

proc report data= sashelp.heart missing;
	column ("Status" status) sex, ageatstart;
	define status/ group ' ';
	define sex/ across; 
	define ageatstart/n ' ';
	compute ageatstart;
            call define(_col_,'format',"comma8.0");
        endcompute;
run;

Re: comma format in proc report

ed_sas_member — Sun, 02 Feb 2020 15:08:56 GMT

Hi @braam

The sex variable cannot have the format comma9.2 for its modalities.

You need to add as statement for "n" to apply this format:

	proc report data= sashelp.heart missing;
		column status sex, n;
		define status/ group;
		define sex/ across;
		define n /  format= comma9.2;
	run;

Re: comma format in proc report

Cynthia_sas — Sun, 02 Feb 2020 17:21:21 GMT

Hi:

You can't supply a numeric format for a character variable. You want to format the N statistics that is being placed UNDER the value of the SEX variable in the output table. Call Define is one approach. An even simpler approach is to use the format= or f= in a DEFINE statement for the N statistic, as shown below:

Cynthia