https://communities.sas.com/t5/SAS-Programming/insert-data/m-p/57343#M12371 You can import the excel without the row 1 as headers, SAS will name the columns with some default names. You can then use PROC DATASETS to rename the columns. Wed, 22 Jul 2009 18:36:09 GMT Doc_Duke 2009-07-22T18:36:09Z https://communities.sas.com/t5/SAS-Programming/insert-data/m-p/57342#M12370 One of the excel files I get does not contain header.I use the proc import to create dataset (say A). The first record becomes header.<BR /> <BR /> I created a another dataset with only headers in it (say B).How to append the data from A to B? Wed, 22 Jul 2009 18:06:49 GMT https://communities.sas.com/t5/SAS-Programming/insert-data/m-p/57342#M12370 SASPhile 2009-07-22T18:06:49Z https://communities.sas.com/t5/SAS-Programming/insert-data/m-p/57343#M12371 You can import the excel without the row 1 as headers, SAS will name the columns with some default names. You can then use PROC DATASETS to rename the columns. Wed, 22 Jul 2009 18:36:09 GMT https://communities.sas.com/t5/SAS-Programming/insert-data/m-p/57343#M12371 Doc_Duke 2009-07-22T18:36:09Z https://communities.sas.com/t5/SAS-Programming/insert-data/m-p/57344#M12372 Depending on your input data file definition, the FILENAME statement supports a concatenation technique, where your input file(s) are listed in sequence and are enclosed with parantheses. Have a look at the FILENAME statement documentation in the SAS companion guide for your particular OS environment.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Wed, 22 Jul 2009 18:36:18 GMT https://communities.sas.com/t5/SAS-Programming/insert-data/m-p/57344#M12372 sbb 2009-07-22T18:36:18Z