Help using Base SAS procedures

importing excel from website

Reply
N/A
Posts: 0

importing excel from website

Hi,

I am trying to import an excel file from a webite, but am having trouble because the excel file has merged cells in the first few rows and contains multiple worksheets. I am using an infile statement since it is an url. Is there anyway I can get SAS to read specific cell range or line up the merged cells correctly?

Thanks.
Trusted Advisor
Posts: 1,431

Re: importing excel from website

You probably have to this in 2 steps:
1- download file from URL
2- read local excel file using one of the available methods.
That's because there is no excel-aware mechanism that can use the URL engine afaik.
Ask a Question
Discussion stats
  • 1 reply
  • 72 views
  • 0 likes
  • 2 in conversation