topic Create groups by reading next records in SAS Programming https://communities.sas.com/t5/SAS-Programming/Create-groups-by-reading-next-records/m-p/925037#M364080 <P>I have this data set:</P><TABLE><TBODY><TR><TD>ID</TD><TD>HOH</TD></TR><TR><TD>903</TD><TD>1</TD></TR><TR><TD>AB4</TD><TD>0</TD></TR><TR><TD>26A</TD><TD>0</TD></TR><TR><TD>E52</TD><TD>1</TD></TR><TR><TD>53D</TD><TD>0</TD></TR><TR><TD>40</TD><TD>0</TD></TR><TR><TD>7B6</TD><TD>0</TD></TR><TR><TD>E8D</TD><TD>1</TD></TR><TR><TD>A80</TD><TD>0</TD></TR><TR><TD>AA6</TD><TD>0</TD></TR><TR><TD>63A</TD><TD>1</TD></TR><TR><TD>3DB</TD><TD>0</TD></TR><TR><TD>A57</TD><TD>0</TD></TR><TR><TD>D27</TD><TD>0</TD></TR><TR><TD>450</TD><TD>0</TD></TR><TR><TD>F4D</TD><TD>0</TD></TR><TR><TD>0A2</TD><TD>0</TD></TR><TR><TD>37F</TD><TD>1</TD></TR><TR><TD>E52</TD><TD>1</TD></TR><TR><TD>282</TD><TD>1</TD></TR><TR><TD>268</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The IDs are individuals and HOH = 1 is the head of household for the next records with HOH = 0.&nbsp; Then the next HOH = 1 start the next household group.&nbsp; I need to group those like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>HOH</TD><TD>Household</TD></TR><TR><TD>903</TD><TD>1</TD><TD>903</TD></TR><TR><TD>AB4</TD><TD>0</TD><TD>903</TD></TR><TR><TD>26A</TD><TD>0</TD><TD>903</TD></TR><TR><TD>E52</TD><TD>1</TD><TD>E52</TD></TR><TR><TD>53D</TD><TD>0</TD><TD>E52</TD></TR><TR><TD>40</TD><TD>0</TD><TD>E52</TD></TR><TR><TD>7B6</TD><TD>0</TD><TD>E52</TD></TR><TR><TD>E8D</TD><TD>1</TD><TD>E8D</TD></TR><TR><TD>A80</TD><TD>0</TD><TD>E8D</TD></TR><TR><TD>AA6</TD><TD>0</TD><TD>E8D</TD></TR><TR><TD>63A</TD><TD>1</TD><TD>63A</TD></TR><TR><TD>3DB</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>A57</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>D27</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>450</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>F4D</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>0A2</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>37F</TD><TD>1</TD><TD>37F</TD></TR><TR><TD>E52</TD><TD>1</TD><TD>E52</TD></TR><TR><TD>282</TD><TD>1</TD><TD>282</TD></TR><TR><TD>268</TD><TD>1</TD><TD>268</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>So create groups where groups do not exist.&nbsp; The file comes sorted so the first HOH = 1 and HOHs = 0 are in the same household.</P><P>&nbsp;</P><P>Thanks</P> Fri, 19 Apr 2024 16:32:36 GMT Mousemo1 2024-04-19T16:32:36Z Create groups by reading next records https://communities.sas.com/t5/SAS-Programming/Create-groups-by-reading-next-records/m-p/925037#M364080 <P>I have this data set:</P><TABLE><TBODY><TR><TD>ID</TD><TD>HOH</TD></TR><TR><TD>903</TD><TD>1</TD></TR><TR><TD>AB4</TD><TD>0</TD></TR><TR><TD>26A</TD><TD>0</TD></TR><TR><TD>E52</TD><TD>1</TD></TR><TR><TD>53D</TD><TD>0</TD></TR><TR><TD>40</TD><TD>0</TD></TR><TR><TD>7B6</TD><TD>0</TD></TR><TR><TD>E8D</TD><TD>1</TD></TR><TR><TD>A80</TD><TD>0</TD></TR><TR><TD>AA6</TD><TD>0</TD></TR><TR><TD>63A</TD><TD>1</TD></TR><TR><TD>3DB</TD><TD>0</TD></TR><TR><TD>A57</TD><TD>0</TD></TR><TR><TD>D27</TD><TD>0</TD></TR><TR><TD>450</TD><TD>0</TD></TR><TR><TD>F4D</TD><TD>0</TD></TR><TR><TD>0A2</TD><TD>0</TD></TR><TR><TD>37F</TD><TD>1</TD></TR><TR><TD>E52</TD><TD>1</TD></TR><TR><TD>282</TD><TD>1</TD></TR><TR><TD>268</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>The IDs are individuals and HOH = 1 is the head of household for the next records with HOH = 0.&nbsp; Then the next HOH = 1 start the next household group.&nbsp; I need to group those like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>ID</TD><TD>HOH</TD><TD>Household</TD></TR><TR><TD>903</TD><TD>1</TD><TD>903</TD></TR><TR><TD>AB4</TD><TD>0</TD><TD>903</TD></TR><TR><TD>26A</TD><TD>0</TD><TD>903</TD></TR><TR><TD>E52</TD><TD>1</TD><TD>E52</TD></TR><TR><TD>53D</TD><TD>0</TD><TD>E52</TD></TR><TR><TD>40</TD><TD>0</TD><TD>E52</TD></TR><TR><TD>7B6</TD><TD>0</TD><TD>E52</TD></TR><TR><TD>E8D</TD><TD>1</TD><TD>E8D</TD></TR><TR><TD>A80</TD><TD>0</TD><TD>E8D</TD></TR><TR><TD>AA6</TD><TD>0</TD><TD>E8D</TD></TR><TR><TD>63A</TD><TD>1</TD><TD>63A</TD></TR><TR><TD>3DB</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>A57</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>D27</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>450</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>F4D</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>0A2</TD><TD>0</TD><TD>63A</TD></TR><TR><TD>37F</TD><TD>1</TD><TD>37F</TD></TR><TR><TD>E52</TD><TD>1</TD><TD>E52</TD></TR><TR><TD>282</TD><TD>1</TD><TD>282</TD></TR><TR><TD>268</TD><TD>1</TD><TD>268</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>So create groups where groups do not exist.&nbsp; The file comes sorted so the first HOH = 1 and HOHs = 0 are in the same household.</P><P>&nbsp;</P><P>Thanks</P> Fri, 19 Apr 2024 16:32:36 GMT https://communities.sas.com/t5/SAS-Programming/Create-groups-by-reading-next-records/m-p/925037#M364080 Mousemo1 2024-04-19T16:32:36Z Re: Create groups by reading next records https://communities.sas.com/t5/SAS-Programming/Create-groups-by-reading-next-records/m-p/925040#M364081 <P>UNTESTED CODE</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; retain household; set have; if hoh=1 then household=id; run;</CODE></PRE> Fri, 19 Apr 2024 16:38:14 GMT https://communities.sas.com/t5/SAS-Programming/Create-groups-by-reading-next-records/m-p/925040#M364081 PaigeMiller 2024-04-19T16:38:14Z