https://communities.sas.com/t5/SAS-Software-for-Learning/How-to-put-the-header-and-the-no-count-in-the-same-row/m-p/900716#M1493 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ericykc_0-1698680805433.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/89248i0FA370B266BB85FF/image-size/medium?v=v2&amp;px=400" role="button" title="ericykc_0-1698680805433.png" alt="ericykc_0-1698680805433.png" /></span></P><P>this is the output, and i want to put the final count and the hhid in the same row. May anyone teach me? Thank a lot.</P><P>Here my code,</P><P>&nbsp;</P><P>data Member;<BR />infile '~/MS3251/Raw Data/Surref.txt' dlm=',';<BR />input dummy_var : $15. @;<BR />if substr(dummy_var,1,1) ^in (0:9) then do;<BR />input @1 hhid : $15. hhtype $;<BR />no_count = 0;<BR />retain dummy_var;<BR />end;<BR />else do;<BR />no_count + 1;<BR />if no_count &gt; 0 then do;<BR />input @1 birthdate : date11. householder_ind $ gender : $6. martial_status : $8. education employment_status $ income ;<BR />if gender='Male' then no_males+1;<BR />mem = no_count;<BR />keep hhid hhtype mem no_count birthdate no_males;<BR />end;<BR />end;<BR />run;</P> Mon, 30 Oct 2023 15:48:01 GMT ericykc 2023-10-30T15:48:01Z https://communities.sas.com/t5/SAS-Software-for-Learning/How-to-put-the-header-and-the-no-count-in-the-same-row/m-p/900716#M1493 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ericykc_0-1698680805433.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/89248i0FA370B266BB85FF/image-size/medium?v=v2&amp;px=400" role="button" title="ericykc_0-1698680805433.png" alt="ericykc_0-1698680805433.png" /></span></P><P>this is the output, and i want to put the final count and the hhid in the same row. May anyone teach me? Thank a lot.</P><P>Here my code,</P><P>&nbsp;</P><P>data Member;<BR />infile '~/MS3251/Raw Data/Surref.txt' dlm=',';<BR />input dummy_var : $15. @;<BR />if substr(dummy_var,1,1) ^in (0:9) then do;<BR />input @1 hhid : $15. hhtype $;<BR />no_count = 0;<BR />retain dummy_var;<BR />end;<BR />else do;<BR />no_count + 1;<BR />if no_count &gt; 0 then do;<BR />input @1 birthdate : date11. householder_ind $ gender : $6. martial_status : $8. education employment_status $ income ;<BR />if gender='Male' then no_males+1;<BR />mem = no_count;<BR />keep hhid hhtype mem no_count birthdate no_males;<BR />end;<BR />end;<BR />run;</P> Mon, 30 Oct 2023 15:48:01 GMT https://communities.sas.com/t5/SAS-Software-for-Learning/How-to-put-the-header-and-the-no-count-in-the-same-row/m-p/900716#M1493 ericykc 2023-10-30T15:48:01Z https://communities.sas.com/t5/SAS-Software-for-Learning/How-to-put-the-header-and-the-no-count-in-the-same-row/m-p/900733#M1495 <P>Data and what you expect the result to look like.</P> <P>Put where? in a data set? A report? What sort of report?</P> <P>&nbsp;</P> Mon, 30 Oct 2023 16:15:00 GMT https://communities.sas.com/t5/SAS-Software-for-Learning/How-to-put-the-header-and-the-no-count-in-the-same-row/m-p/900733#M1495 ballardw 2023-10-30T16:15:00Z