topic Re: Count in SAS Programming

Count

Steelers_In_DC — Tue, 24 Sep 2013 17:13:09 GMT

I would like to add a variable that counts the number of variables each row has in a dataset, in excel I use =COUNT(B2:D2) to get the desired result. Can someone help to do this in SAS? I have 4 variables, pcpid, date2011,date2012, date2013. I want to have a count from 0-3 regarding the dates. If something was returned from a pcp the date field will be populated. I will then sort by the count field to have the pcp that returned all three surveys at the top.

Thanks,

Mark

Re: Count

Reeza — Tue, 24 Sep 2013 17:33:46 GMT

Assuming that date columns are actually SAS date variables, use the n() function.

n(date2011, date2012, date2013);

n(of date2011-date2013);

Re: Count

Steelers_In_DC — Tue, 24 Sep 2013 17:46:43 GMT

Thanks, I was using transpose and count() then trying to merge back and not getting what I wanted. I thought there was a simpler way that I was missing.

Thank You,