BookmarkSubscribeRSS Feed
tarunchitkara
Fluorite | Level 6

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.

2 REPLIES 2
ballardw
Super User

Is this a one time task or will you be reading multiple files with the same format?

 

If this is a one-time then perhaps merging the cells in Excel.

 

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.

 

Because of other data issues inherit in Excel I would actuall likely go the CSV route anyway.

Ksharp
Super User

Can you post some data(attach a excel file) to let us test ?

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1197 views
  • 0 likes
  • 3 in conversation