Hi,
I have a table that contains only alphanumerical values. The column Info1 contains value that are blank (empty).
I usually use the following procedure to count null values in a table, but for this table the result returned is 0, but I see that some values are blank.
proc sql;
select count(Info1) as i from table1
where Info1 is null
;quit;
I also tried this but it also return 0 :
proc sql;
select count(Info1) as i from table1
where Info1=''
;quit;
What am I doing wrong?
Thank you for your help.
COUNT(info1) counts non-missing info1 values. Use COUNT(*) instead. - PG
COUNT(info1) counts non-missing info1 values. Use COUNT(*) instead. - PG
PG is dead on this. Count() has tricked me when I first started using Proc SQL. In comparison, sum() is more predictable.
proc sql;
select sum(missing(Info1)) as i from table1
;quit;
Haikuo
Thank you both for this precision.
Regards.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: