@paul2877 Still a no go, files won't open in Excel and if I change the extension to HTML there's no HTML so that approach won't work.
Please test your files before uploading. You should be able to open it with Excel and if you change the extension to HTML I'd expect to see HTML if I open it in a text editor rather than gibberish. Please also include a screenshot of what the file should look like so that we can ensure it's opening correctly because at this point I'm not sure I'd trust what I'd see.
do you have any other options to be able to upload a file of this sort without seeing it?
@paul2877 wrote:
do you have any other options to be able to upload a file of this sort without seeing it?
I'm not sure what you mean? You can upload the file to a public dropbox type if you think you're having issues with the forum, but in general, there's no way we can help with your problem without a sample file.
You can attempt to read the file as HTML/text and see what you get I suppose. Most likely a lot of text, but perhaps you can figure out how to parse that. There are the HTMLDECODE functions to help with some of that. Good Luck.
data test;
length x $32000;
infile 'path to xls file' lrecl=32000;
input;
x=_infile_;
run;
I do not think that attached file represents a complete file. It's missing the data sheets (Sheet001.htm) referenced inside of it.
Oh, but that second on (samplefile2.xls) has some data I see.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.