topic Re: how to count id number in SAS Programming

how to count id number

padmakumariMiriyala — Fri, 03 Jul 2015 07:06:23 GMT

I have data like this

data have;

infile datalines;

input policynumber$8.;

datalines;

m2227eqw,wy3747387,hsdahah

schaxnbbxc

847e7w87

47ew7837

ds6778989

fg848484,rt222222,y72378w

;

run;

how to find out count policy number ?

actual count is 10 but it count came 6.;

thanks in advanc

Re: how to count id number

Patrick — Fri, 03 Jul 2015 07:35:29 GMT

That's not about the count but about your input statement which only reads the first field per line (and you have 6 lines).

Re: how to count id number

Steelers_In_DC — Fri, 03 Jul 2015 11:39:36 GMT

Two things to point out. You your length assignments are incorrect and you are only loading one column when you have three.

Hope this helps:

data have;

infile datalines dsd;

length policynumber1 policynumber2 policynumber3 $10.;

input policynumber1$ policynumber2$ policynumber3$;

datalines;

m2227eqw,wy3747387,hsdahah

schaxnbbxc,,

847e7w87,,

47ew7837,,

ds6778989,,

fg848484,rt222222,y72378w

;

run;

proc sql;

create table want as

select sum(count(policynumber1),count(policynumber2),count(policynumber3)) as count

from have;

Re: how to count id number

Astounding — Fri, 03 Jul 2015 14:50:24 GMT

Here's an alternative that uses your original version of the data:

data have;

infile datalines dsd;

length policynumber $ 10;

input policynumber @@;

datalines;

m2227eqw,wy3747387,hsdahah

schaxnbbxc

847e7w87

47ew7837

ds6778989

fg848484,rt222222,y72378w

;

This code doesn't count the policy numbers, because your original code didn't count them. But it does give you each policy number as a separate observation.

Good luck.