https://communities.sas.com/t5/SAS-Procedures/How-to-read-header-from-excel-distributed-in-two-lines/m-p/271155#M58299 <P>Can you post some data(attach a excel file) to let us test ?</P> Wed, 18 May 2016 02:14:19 GMT Ksharp 2016-05-18T02:14:19Z https://communities.sas.com/t5/SAS-Procedures/How-to-read-header-from-excel-distributed-in-two-lines/m-p/271044#M58280 <P>I want to import excel file in sas but the header name is splitted in two rows.For ex: suppose header name is "total Price" then total is written in 1 row while price is written just below row .how can i read both as one or can concanate.File extension is .xls.</P> Tue, 17 May 2016 17:46:25 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-read-header-from-excel-distributed-in-two-lines/m-p/271044#M58280 tarunchitkara 2016-05-17T17:46:25Z https://communities.sas.com/t5/SAS-Procedures/How-to-read-header-from-excel-distributed-in-two-lines/m-p/271095#M58289 <P>Is this a one time task or will you be reading multiple files with the same format?</P> <P>&nbsp;</P> <P>If this is a one-time then perhaps merging the cells in Excel.</P> <P>&nbsp;</P> <P>If I were to be reading many of these files I would 1)save them to CSV and 2) write a Datastep to read the files and have the code set the variable names and start reading with OBS=3 on the infile statement.</P> <P>&nbsp;</P> <P>Because of other data issues inherit in Excel I would actuall likely go the CSV route anyway.</P> Tue, 17 May 2016 20:33:16 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-read-header-from-excel-distributed-in-two-lines/m-p/271095#M58289 ballardw 2016-05-17T20:33:16Z https://communities.sas.com/t5/SAS-Procedures/How-to-read-header-from-excel-distributed-in-two-lines/m-p/271155#M58299 <P>Can you post some data(attach a excel file) to let us test ?</P> Wed, 18 May 2016 02:14:19 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-read-header-from-excel-distributed-in-two-lines/m-p/271155#M58299 Ksharp 2016-05-18T02:14:19Z