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.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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