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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.