topic Re: Combining several data sets in SAS Programming https://communities.sas.com/t5/SAS-Programming/Combining-several-data-sets/m-p/218680#M267819 <HTML><HEAD></HEAD><BODY><P>Assuming you want to append (stack) all the tables, use the colon shortcut.</P><P></P><P>data want;</P><P>set fixed: ;</P><P>run;</P><P></P><P>If you want them merged, ie the variables side by side that's a different question.</P></BODY></HTML> Mon, 25 May 2015 16:52:06 GMT Reeza 2015-05-25T16:52:06Z Combining several data sets https://communities.sas.com/t5/SAS-Programming/Combining-several-data-sets/m-p/218679#M267818 <HTML><HEAD></HEAD><BODY><P>I have 243 data sets with names as:</P><P></P><P>fixed11</P><P>fixed21</P><P>fixed31</P><P>fixed41</P><P>...</P><P>fixed2411</P><P>fixed2421</P><P>fixed2431</P><P></P><P>All of them have the same variable names, and number of columns.</P><P></P><P>How can I combine them (one above the other) in one data set avoiding several data steps?</P></BODY></HTML> Mon, 25 May 2015 16:45:17 GMT https://communities.sas.com/t5/SAS-Programming/Combining-several-data-sets/m-p/218679#M267818 mauflagrum 2015-05-25T16:45:17Z Re: Combining several data sets https://communities.sas.com/t5/SAS-Programming/Combining-several-data-sets/m-p/218680#M267819 <HTML><HEAD></HEAD><BODY><P>Assuming you want to append (stack) all the tables, use the colon shortcut.</P><P></P><P>data want;</P><P>set fixed: ;</P><P>run;</P><P></P><P>If you want them merged, ie the variables side by side that's a different question.</P></BODY></HTML> Mon, 25 May 2015 16:52:06 GMT https://communities.sas.com/t5/SAS-Programming/Combining-several-data-sets/m-p/218680#M267819 Reeza 2015-05-25T16:52:06Z