topic Re: Help in count function in SAS Programming

Help in count function

Kalai2008 — Mon, 17 Jul 2017 19:02:28 GMT

I dont want to use Proc SQL in my program.

I am trying to calculate a new column (Acc) with the count of all variables. pin_id1 is numeric.

data test.id;
set test.data ;
Acc= count(pin_id1,pin_id1,pin_id3);
run;

ERROR 72-185: The COUNT function call has too many arguments.

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
25:12 25:20 25:28 25:36 25:44
NOTE: The SAS System stopped processing this step because of errors.

Output like:

pin_id1 pin_id2 Pin_id3 Acc

235 465 987 3

223 777 2

Re: Help in count function

PaigeMiller — Mon, 17 Jul 2017 19:07:08 GMT

COUNT is not the proper function to use in this case.

You want to use the N function

acc=n(pin_id1,pin_id2,pin_id3);

Re: Help in count function

Kalai2008 — Mon, 17 Jul 2017 19:14:29 GMT

Thank you!..It worked.I was confused with the proc sql.