https://communities.sas.com/t5/New-SAS-User/Combining-tables/m-p/760686#M30308 <P>Hello,</P><P>&nbsp;</P><P>I'm trying to combine multiple datasets across several years (17/18, 18/19, etc) but first, I want to create a new variable with season, household id and participant number e.g. 171800101 such that the index case in the first household enrolled in 1718 season (other members would be 02, 03, 04, etc.) and household number would be three digits (001, 002, ...188, etc) and the seasons would be 4 digits (1718, 1819, 1920). The variables are not already in the dataset. How do I create them for each of the dataset and merge by this common new variable?</P> Tue, 10 Aug 2021 15:08:47 GMT Oversea_rep 2021-08-10T15:08:47Z https://communities.sas.com/t5/New-SAS-User/Combining-tables/m-p/760686#M30308 <P>Hello,</P><P>&nbsp;</P><P>I'm trying to combine multiple datasets across several years (17/18, 18/19, etc) but first, I want to create a new variable with season, household id and participant number e.g. 171800101 such that the index case in the first household enrolled in 1718 season (other members would be 02, 03, 04, etc.) and household number would be three digits (001, 002, ...188, etc) and the seasons would be 4 digits (1718, 1819, 1920). The variables are not already in the dataset. How do I create them for each of the dataset and merge by this common new variable?</P> Tue, 10 Aug 2021 15:08:47 GMT https://communities.sas.com/t5/New-SAS-User/Combining-tables/m-p/760686#M30308 Oversea_rep 2021-08-10T15:08:47Z https://communities.sas.com/t5/New-SAS-User/Combining-tables/m-p/760689#M30309 <P>Please provide us with (a small portion of) your data sets. Please follow <A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_self">these instructions</A>. (Do not attach files or provide data as a screen capture)</P> Tue, 10 Aug 2021 15:26:17 GMT https://communities.sas.com/t5/New-SAS-User/Combining-tables/m-p/760689#M30309 PaigeMiller 2021-08-10T15:26:17Z