BookmarkSubscribeRSS Feed
sasemp999
Calcite | Level 5

Hi all,

i want to import excel table into sas

excel file contains:
1st row to 6 th row --------project description(such as case count,event count,code key,...............name of project,desc)----I dont want to import this one..

from 7 th row onwards it contains data i want to import from that row(and the variable names like["name" event = event Heartattack abnormal condition (yes/no)]
i have columns like that field varaible name more than 32 and special characters are there)

How to import such data?

Thanks

1 REPLY 1
shshiva
Calcite | Level 5

Hi ,

Check this link.hope it helps.

https://communities.sas.com/message/123453#123453

Thanks,

Shiva

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 →

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