topic question on count and format in SAS Programming

question on count and format

soujik — Mon, 27 Mar 2023 19:39:24 GMT

Hi,

Quick question on count and format

select xx_yy,

count(1) format = comma12. as aci_knt

From wkly_wxxx_fnl

what does the count and format do in this code. please help me

Re: question on count and format

PaigeMiller — Mon, 27 Mar 2023 19:52:24 GMT

Count(1) counts the number of records in column 1 (which is the variable named xx_yy), which is also the same as the number of records in the data set; and format displays the result using the COMMA. format (in other words, with appropriate commas).

Re: question on count and format

soujik — Mon, 27 Mar 2023 19:56:39 GMT

what does the comma12.

is it put comma after 12 digits?

Re: question on count and format

Kurt_Bremser — Mon, 27 Mar 2023 20:00:16 GMT

You can follow Maxim 4 and simply try it.

Or you follow Maxim 1 and Read the Documentation: COMMAw. Format

Re: question on count and format

PaigeMiller — Mon, 27 Mar 2023 21:12:33 GMT

@soujik wrote:

what does the comma12.

is it put comma after 12 digits?

As I said, it adds commas properly to your number. I have never seen a number with a comma after 12 digits. Since two people have given you a link to the documentation for the COMMA format, you can also look at the examples there.

Re: question on count and format

Tom — Mon, 27 Mar 2023 21:17:21 GMT

COUNT() counts the number of times is argument is not missing. So COUNT(1) is the same thing as COUNT(*), it just counts the number of observations.

FORMAT= is used to attach a format to the variable. The COMMA format is used to display number with a comma as the thousands separator. 12 is the width of the format, how many bytes it prints. So COMMA12 will show numbers in the style of ,234,678,012 . So use 12 is a little silly for positive numbers. Either use COMMA11. if you expect numbers smaller than 1 billion or use something wider than 12 if you expect counts over 1 billion.