topic Re: Summary table based on PROC CONTENTS - need to add N and NMISS in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Summary-table-based-on-PROC-CONTENTS-need-to-add-N-and-NMISS/m-p/26281#M5995 SAS doesn't do that in one procedure. You are going to have to splice together the information from multiple procedures. You can use the ODS datasets to output the data and then merge it back together. You may actually find the Enterprise Guide "Characterize data" task gives you the additional information that you need; the statisticians will appreciate the additional distribution information from that task. Sun, 23 May 2010 17:34:37 GMT Doc_Duke 2010-05-23T17:34:37Z Summary table based on PROC CONTENTS - need to add N and NMISS https://communities.sas.com/t5/SAS-Procedures/Summary-table-based-on-PROC-CONTENTS-need-to-add-N-and-NMISS/m-p/26280#M5994 Hi,<BR /> <BR /> I'm trying to produce a brief but comprehensive report on tables extracted from a database with SAS, for delivery to a third party for statistical analysis. The table below produced with PROC CONTENTS is just the sort of thing I'm aiming for, but there are two columns I'd like to add - N and NMISS for every variable (character, numeric or date).<BR /> <BR /> Can anyone help with this? I'm running 9.2 on Windows XP.<BR /> <BR /> Thanks in advance,<BR /> <BR /> Norman.<BR /> <BR /> Here is a sample of a table - sorry about the formatting; the columns align in my document!<BR /> <BR /> TT01 Form<BR /> <BR /> The CONTENTS Procedure<BR /> <BR /> Variables in Creation Order<BR /> # Variable Type Len Format Informat Label<BR /> 1 TSTAMP Num 8 DATE9. DATE9. TSTAMP<BR /> 2 TT Char 50 $50. $50. TT<BR /> 3 PTIDENT Char 50 $50. $50. PTIDENT<BR /> 4 PTTRIALID Char 50 $50. $50. PTTRIALID<BR /> 5 UK Num 8 11. 11. UK<BR /> 6 INCRIT1 Num 8 11. 11. INCRIT1<BR /> 7 INCRIT2 Num 8 11. 11. INCRIT2<BR /> 8 INCRIT3 Num 8 11. 11. INCRIT3<BR /> 9 INCRIT4 Num 8 11. 11. INCRIT4<BR /> 10 INCRIT5 Num 8 11. 11. INCRIT5<BR /> 11 EXCRIT1 Num 8 11. 11. EXCRIT1<BR /> 12 EXCRIT2 Num 8 11. 11. EXCRIT2<BR /> 13 EXCRIT3 Num 8 11. 11. EXCRIT3<BR /> 14 EXCRIT4 Num 8 11. 11. EXCRIT4<BR /> 15 EXCRIT5 Num 8 11. 11. EXCRIT5<BR /> 16 PSNAME1 Char 50 $50. $50. PSNAME1<BR /> 17 PFNAME1 Char 50 $50. $50. PFNAME1<BR /> 18 HOSPNO1 Char 50 $50. $50. HOSPNO1<BR /> 19 DOB1 Num 8 DATE9. DATE9. DOB1<BR /> 20 DPTINFO Num 8 DATE9. DATE9. DPTINFO<BR /> ...etc. Sun, 23 May 2010 16:02:43 GMT https://communities.sas.com/t5/SAS-Procedures/Summary-table-based-on-PROC-CONTENTS-need-to-add-N-and-NMISS/m-p/26280#M5994 Norman21 2010-05-23T16:02:43Z Re: Summary table based on PROC CONTENTS - need to add N and NMISS https://communities.sas.com/t5/SAS-Procedures/Summary-table-based-on-PROC-CONTENTS-need-to-add-N-and-NMISS/m-p/26281#M5995 SAS doesn't do that in one procedure. You are going to have to splice together the information from multiple procedures. You can use the ODS datasets to output the data and then merge it back together. You may actually find the Enterprise Guide "Characterize data" task gives you the additional information that you need; the statisticians will appreciate the additional distribution information from that task. Sun, 23 May 2010 17:34:37 GMT https://communities.sas.com/t5/SAS-Procedures/Summary-table-based-on-PROC-CONTENTS-need-to-add-N-and-NMISS/m-p/26281#M5995 Doc_Duke 2010-05-23T17:34:37Z