cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Nehcour0420
Calcite | Level 5 Nehcour0420
Calcite | Level 5

ACLWRITE when try to update SPDS data

Posted 03-29-2012 08:16 AM (1181 views)

Hi Guys,

I got an error message:

ERROR: ACLWRITE access toexisting data set required to open for update.

when I was trying to update a spds table (not a cluster table) using proc sql update.

Anyone has any idea about the solution?

Thanks,

Eric

0 Likes
Reply
1 REPLY 1
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

ACLWRITE when try to update SPDS data

Posted 03-29-2012 09:03 AM (1040 views)  |   In reply to Nehcour0420

It seems that you don't have permission to update the table...?

Data never sleeps
Reply

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Watch How to connect to databases in SAS Viya on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎03-29-2012 08:16 AM
  • 1182 views
  • 3 likes
  • 2 in conversation