![]() Chapter Contents |
![]() Previous |
![]() Next |
The SQL Procedure |
Procedure feature: |
| |
Table: | SURVEY |
Input Table |
Program |
options nodate pageno=1 linesize=80 pagesize=60;
![]() | %macro countm(col); count(&col) "Valid Responses for &col", |
![]() | count(case when &col is missing then put(&col, 2.) end) "Missing or NOT VALID Responses for &col", |
![]() | proc sql; title 'Counts for Each Type of Missing Response'; select count(*) "Total No. of Rows", %countm(educ) from survey; |
Output |
![]() Chapter Contents |
![]() Previous |
![]() Next |
![]() Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.