ssn pin ids1 p1 c1as1 p2 c1bs1 c1c
s2 c2s2 c2a
s3 c3s3 c3a
s4 c4as4 p4 c4b
count where pin is missing with pin present for other records : 2 (ssn s1 and s4)
count where pin is not present all : 2 (s2 and s3 )
proc sql;
select sum(all_miss) as all_miss,
sum(miss_count) as miss_count
from
(select count(pin) eq 0 as all_miss,
count(pin) gt 0 as miss_count
from have
group by ssn
having nmiss(pin) gt 0)
;
quit;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.