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?
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.