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

[Akaran]

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 

[RW9]

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?  

[Akaran]

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

[RW9]

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.

[art297]

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

Art, CEO, AnalystFinder.com