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
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?
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
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.
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
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!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.