topic how to export sas dataset into excel file in read only mode in SAS Programming

how to export sas dataset into excel file in read only mode

Akaran — Thu, 03 May 2018 12:27:21 GMT

Hi,

I have a sas job which is running daily basis and export sas dataset into Excel file through proc export with replace option .

I need after generating excel file through proc export it should only open in read only mode.

Thanks

Karan

Re: how to export sas dataset into excel file in read only mode

RW9 — Thu, 03 May 2018 12:36:23 GMT

I don't believe there is currently an automated method of making an Excel file protected. I suppose the question is why do you need to make it read only?

Re: how to export sas dataset into excel file in read only mode

art297 — Thu, 03 May 2018 13:29:21 GMT

If you're on a Windows-based system, here is one way: https://communities.sas.com/t5/ODS-and-Base-Reporting/Can-you-protect-a-Excel-worksheet-from-within-a-SAS-procedure-or/td-p/132791

Art, CEO, AnalystFinder.com

Re: how to export sas dataset into excel file in read only mode

Akaran — Mon, 07 May 2018 07:10:43 GMT

Hi,

we are exporting SAS datasets on daily basis which are directly used by sales team , we want to send them read only .xlsx file so that they will unable to manipulate it and read it only for sales analysis input data.

Thanks

Alok Karan

Re: how to export sas dataset into excel file in read only mode

RW9 — Wed, 09 May 2018 07:01:14 GMT

I would really suggest you look into a file format which is a good method of data transfer. CSV is the simplest, most portable file format - it doesn't have the limitations of Excel such as max row length. Excel is pretty limited in a lot of ways. Assuming that the "sales team" are just importing this data (into what?), they can open CSV files in Excel - note has to abide by Excel limitations then, or can import the data into databases or other software pretty easily.