topic Re: How to count the number of variables with arguments? in SAS Programming

How to count the number of variables with arguments?

danielhu — Sun, 05 Apr 2015 09:39:19 GMT

Hi, new user here that is trying to learn the ropes. I have a question here, how do I convert table 1 to table 2? table 2 is to calculate the frequency of eg, number of times in year 2005, 2006.. where the index is 6.

table 1

Year	Index
2005	5
2005	8
2005	11
2006	6
2007	13
2007	5
2007	6
2007	5
2008	8
2008	5
2008	5

table 2

	2005	2006	2007	2008
Index<6	1	0	2	2
Index=6	0	1	1	0
Index=8	1	0	0	1
Index>8	1	0	1	0

Re: How to count the number of variables with arguments?

stat_sas — Sun, 05 Apr 2015 17:45:12 GMT

proc format;

value indx low-5='Index<6'

6='Index=6'

8='Index=8'

8-high='Index>8';

run;

proc freq data=table1;

table index*year/nocum nopercent norow nocol;

format index indx.;

run;

Re: How to count the number of variables with arguments?

danielhu — Mon, 06 Apr 2015 10:34:29 GMT

thanks pal! great help!