BookmarkSubscribeRSS Feed
scournoy
Calcite | Level 5

I have a SAS file which is opened under SERVER=SHARE, because it can be used by multiple users.  However, for the majority of users, we want to disable the DELETE command, so they can view / Add / Dup / MOD, but they will NOT be able to delete ay record.    And for some power users, we want to keep the DELETE command on and operational.

 

Can this be done using SCL code  ?   I have tried to use a special "PROC FSEDIT DATA=dataset_name NOBORDER NODELETE;" for them,  and a standard PROC FSEDIT DATA=dataset_name NOBORDER; for the other users, but as soon as the first one (with teh NODELETE) is used once, the whole dataset becomes in a "NODELETE" for everyone 😞  

 

Thanks for giving me any way to have SAS makes my expectations come true.

 

Sylvain

 

1 REPLY 1
Patrick
Opal | Level 21

Copy/paste your question into MS Copilot 365.

I can't fully validate the answer I've got, but it looked sensible to me.

 

Be aware that SAS/AF, SAS/FSP have been discontinued under SAS Viya (as well as "PC SAS") and though whatever you build using this technology becomes "technical debt".

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 337 views
  • 0 likes
  • 2 in conversation