I hope someone will be able to help me.
I have created a user in SAS Management console and for some reason this profile became read only. So I created a second profile and the user is able to login now , however the user is having issues when running SAS Programs. The user can access the Excel file , but it says invalid sheet name or can't create work table. I could run the same piece of code and it work absolutely fine under my user profile.
Just for narrowing down the issue I would like to delete the read only user profile , how can I delete it ?
Why it became Read only profile ? Please help
As a newbie, your first contact should be your local SAS administrator.
If someone threw you into the lion's den by making you the administrator (something STRONGLY recommended against), go here: https://www.sas.com/en_us/contact/technical-support.geo.html
It will redirect you to the SAS website for your region.
When experiencing unexpected behaviour from the metadata server you can:
1) Inspect the metadata server logs (my mantra: "thou shalt read log files"). Try to delete read-only user and see what the log tells you. You can bump the metadata server log level from sasmc of temporarely replace its logconfig.xml by logconfig.trace.xml.
2) Run an analysis&repair from management console.
This can at times help resolve this kind of issues.
It it doesn't consider restoring a metadata backup from before the creation of the user that is now read-only. But that may be too late as time has progressed and work was been done since.
Hope this helps,
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.