topic counting number of cells in a column with a given value in Discussions

counting number of cells in a column with a given value

Thu, 04 Aug 2011 20:46:30 GMT

Hi,

I'd like to count the number of cells in a column with zero as the value (or another arbitrary number). Ideally, the results would be outputted as a list of counts. Can someone point me in the right direction? Thank you.

Regards,

Will

counting number of cells in a column with a given value

Thu, 04 Aug 2011 22:09:47 GMT

I would think that the easiest solution would be to simply use proc freq outputting the results to a file and then post-processing the output file for whatever criteria you need.

counting number of cells in a column with a given value

bgouaux — Thu, 04 Aug 2011 23:24:52 GMT

If all you want to know is how many times each value occurs in a given column, you could simply use:

Tables menu -> Summary

Enter the column in the field for 'Group'

The resulting table should have 2 columns, the first being all the values that occur, and the second being the number of times each occurs.

-Ben

counting number of cells in a column with a given value

Fri, 05 Aug 2011 17:50:08 GMT

Something like this should get you close:

dt << Current Data Table();

cols = dt << Get Selected Columns();

counts = NewTable("Counts for "||char(dt<<Get Name),newColumn("Column"),newColumn("Count"));

for(i = 1, i <= NItems(cols), i++,

r = dt << Select Where( ascolumn(eval(cols)) == 0 );

counts << AddRows({:Column = column(dt,cols)<< Get Name, :Count = NItems(r)});

);

I didn't test this.