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.

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
  • 1366 views
  • 0 likes
  • 2 in conversation