DATA Step, Macro, Functions and more

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

Reply
New Contributor
Posts: 4

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

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 

Super User
Super User
Posts: 9,211

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

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?  

New Contributor
Posts: 4

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

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

Super User
Super User
Posts: 9,211

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

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.

PROC Star
Posts: 8,114

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

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

 

Ask a Question
Discussion stats
  • 4 replies
  • 103 views
  • 0 likes
  • 3 in conversation