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
That's not about the count but about your input statement which only reads the first field per line (and you have 6 lines).
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;
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.
⏰
Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.
Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.