Proc export to xlsb always opens to the last row and it looks like sheet is empty

jerry898969 — Tue, 10 Jun 2014 13:29:53 GMT

I'm doing the following proc export on a SAS 9.3 64-bit TS1M0 server version. I'm using the pc file server. I was unable to create an xlsx file so I read that it has to be an xlsb file. But when it generates it always goes to the last row of data but you can't see that row. I have to scroll up to see any data at all. Is there an option to correct this? proc export data = test outfile="d\test.xlsb" replace dbms=excelcs ; run; Thank you

Re: Proc export to xlsb always opens to the last row and it looks like sheet is empty

Cynthia_sas — Tue, 10 Jun 2014 23:42:38 GMT

Hi:

I don't understand why it "has to be an xlsb file" -- when I run the code in the screen shot to make an XLS file, using SAS 9.4, I get an XLS file. I don't "have" to make it XLSB. But if you find that there are problems making an XLSB file, you might want to work with Tech Support. For example, this Tech Support note 40597 - The SAS® PC Files Server engine ignores the FILENAME statement even though the SAS® log indicates that files are created shows the creation of .XLSB files in the sample code, but it doesn't say that XLSB is the ONLY file type that you "have to" create.

cynthia

topic Proc export to xlsb always opens to the last row and it looks like sheet is empty in SAS Procedures

Proc export to xlsb always opens to the last row and it looks like sheet is empty

Re: Proc export to xlsb always opens to the last row and it looks like sheet is empty