topic i want to append three excel files data into one dataset in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/i-want-to-append-three-excel-files-data-into-one-dataset/m-p/160317#M41756 <HTML><HEAD></HEAD><BODY><P>1. have.xls</P><P></P><P>id&nbsp; name&nbsp; salary</P><P>1&nbsp; sri&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>2&nbsp; ram&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>3&nbsp; tango&nbsp;&nbsp;&nbsp; 3000</P><P></P><P>2 .&nbsp; temp.xls </P><P></P><P>id&nbsp; name&nbsp; salary</P><P>1&nbsp;&nbsp;&nbsp; gang&nbsp; 5000</P><P>2&nbsp;&nbsp;&nbsp; hunk&nbsp; 300</P><P>5&nbsp;&nbsp;&nbsp; pen&nbsp;&nbsp;&nbsp; 600</P><P></P><P>3. test.xls</P><P></P><P>id&nbsp; name&nbsp;&nbsp; salary</P><P>6&nbsp; geoge&nbsp;&nbsp; 560</P><P>7&nbsp; john&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450</P><P></P><P>above there are 3 excel files i want to import data into dataset and append in to one dataset</P></BODY></HTML> Thu, 15 May 2014 16:31:41 GMT chittamsri1_gmail_com 2014-05-15T16:31:41Z i want to append three excel files data into one dataset https://communities.sas.com/t5/SAS-Procedures/i-want-to-append-three-excel-files-data-into-one-dataset/m-p/160317#M41756 <HTML><HEAD></HEAD><BODY><P>1. have.xls</P><P></P><P>id&nbsp; name&nbsp; salary</P><P>1&nbsp; sri&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>2&nbsp; ram&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>3&nbsp; tango&nbsp;&nbsp;&nbsp; 3000</P><P></P><P>2 .&nbsp; temp.xls </P><P></P><P>id&nbsp; name&nbsp; salary</P><P>1&nbsp;&nbsp;&nbsp; gang&nbsp; 5000</P><P>2&nbsp;&nbsp;&nbsp; hunk&nbsp; 300</P><P>5&nbsp;&nbsp;&nbsp; pen&nbsp;&nbsp;&nbsp; 600</P><P></P><P>3. test.xls</P><P></P><P>id&nbsp; name&nbsp;&nbsp; salary</P><P>6&nbsp; geoge&nbsp;&nbsp; 560</P><P>7&nbsp; john&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450</P><P></P><P>above there are 3 excel files i want to import data into dataset and append in to one dataset</P></BODY></HTML> Thu, 15 May 2014 16:31:41 GMT https://communities.sas.com/t5/SAS-Procedures/i-want-to-append-three-excel-files-data-into-one-dataset/m-p/160317#M41756 chittamsri1_gmail_com 2014-05-15T16:31:41Z Re: i want to append three excel files data into one dataset https://communities.sas.com/t5/SAS-Procedures/i-want-to-append-three-excel-files-data-into-one-dataset/m-p/160318#M41757 <HTML><HEAD></HEAD><BODY><P>proc import + proc append</P></BODY></HTML> Thu, 15 May 2014 17:27:08 GMT https://communities.sas.com/t5/SAS-Procedures/i-want-to-append-three-excel-files-data-into-one-dataset/m-p/160318#M41757 LinusH 2014-05-15T17:27:08Z