https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574068#M162132 <P>I have a number of tables that I would just like to write a bit of code to just show the headings of the columns and the count of the rows with data in under each column.&nbsp;</P> Wed, 17 Jul 2019 04:49:21 GMT RALL 2019-07-17T04:49:21Z https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574068#M162132 <P>I have a number of tables that I would just like to write a bit of code to just show the headings of the columns and the count of the rows with data in under each column.&nbsp;</P> Wed, 17 Jul 2019 04:49:21 GMT https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574068#M162132 RALL 2019-07-17T04:49:21Z https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574069#M162133 <P>Welcome to the SAS Community <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>&nbsp;</P> <P>Where do you want the counts to be displayed? In a report or in a new data set or?</P> Wed, 17 Jul 2019 05:08:00 GMT https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574069#M162133 PeterClemmensen 2019-07-17T05:08:00Z https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574070#M162134 <P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> , just in a report.&nbsp;</P> Wed, 17 Jul 2019 05:14:51 GMT https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574070#M162134 RALL 2019-07-17T05:14:51Z https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574220#M162210 Have you looked at PROC CONTENTS and OUT= data sets?<BR /><BR />A data set has the same number of rows for each column so you may want to be more descriptive than count of rows. <BR /><BR />If you're looking for table and # of rows per table check out sashelp.vtable. <BR /><BR />For column information check out sashelp.vcolumn Wed, 17 Jul 2019 15:29:23 GMT https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574220#M162210 Reeza 2019-07-17T15:29:23Z https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574438#M162321 <P>Thanks the&nbsp;<SPAN>sashelp.vtable did the trick.</SPAN></P> Thu, 18 Jul 2019 03:55:42 GMT https://communities.sas.com/t5/SAS-Programming/Get-headings-of-tables-and-counts/m-p/574438#M162321 RALL 2019-07-18T03:55:42Z