BookmarkSubscribeRSS Feed
learner_sas
Quartz | Level 8

Hello everybody,

I have different excel files with multiple tabs to be imported.All excel sheets has data starting row 2 ( 1 row blank and 2nd row header). I saw some online documents but they were not straightforward. I am wondering if any body can help me on that

Thanks

1 REPLY 1
Tom
Super User Tom
Super User

I actually tried creating an excel file with nothing in the first row and data starting in the second row and SAS read it fine.  It found the variable names and everything. Not sure how it knew to do that.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 1 reply
  • 1251 views
  • 0 likes
  • 2 in conversation