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: 
char22
‎04-03-2017
  • 10 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to Change forgotten SAS Metadata Library (Secured Library) pas...

by Fluorite | Level 6 in Administration and Deployment
‎04-03-2017 09:24 AM
‎04-03-2017 09:24 AM
Hi Anja,   Yes , the error indicating some password entered incorrectly   ERROR: All current secured library passwords must be valid in order to change any. ... View more

How to Change forgotten SAS Metadata Library (Secured Library) passwor...

by Fluorite | Level 6 in Administration and Deployment
‎04-03-2017 07:40 AM
‎04-03-2017 07:40 AM
Hi,   I need to change SAS Metadata bound library (Secured Library) password   http://support.sas.com/documentation/cdl/en/seclibag/66930/HTML/default/viewer.htm#n0cylegyx7e6pcn1naptyqoje8li.htm   The thing is , i lost the old password.   I tried command like this , empty the old password and set new one   proc authlib lib=somd ; remove securedfolder="/System/Secured Libraries" securedlibrary="SOMD" read=/newpass write=/newpass alter=newpass; run;   But it doesn't work. Any suggestion?   Thanks , Charlie ... View more

Re: Pre-Assigned Library Authorization doesn't set correctly

by Fluorite | Level 6 in Administration and Deployment
‎01-26-2017 10:04 PM
‎01-26-2017 10:04 PM
Hi Anja,   Haven't tried the lockdown, is it needed?   Let say I have Library Lib Group A , Group B, Group C   Group A permission to Lib : All permission Group B permission to Lib : Read and Read Metadata Group C permission to Lib : Read and Read Metadata Public permissions are deny all SASUSERS permissions are deny all   The goal are , only Group A can write delete read, while others are read only. Problem is All group can Write delete read.   Additional Info : I set Extended Attributes : AssignMode = 2 and pre assign lib, so the users can access the lib without hassle (assigning the library first before code or using the table are hassle). Is pre assign lib are bypassing the metadata security? I set AD to login to metadata server , I set SAS token authentication for the login to workspace server with single user : sassrv(not sure if it is the cause)   Thanks, Charlie ... View more

Re: Pre-Assigned Library Authorization doesn't set correctly

by Fluorite | Level 6 in Administration and Deployment
‎01-26-2017 04:30 AM
‎01-26-2017 04:30 AM
Hi Linus,   Sorry , my mistake. Already check the libname list command, it run just fine. Already tried the metadata bound library. Looks like it works perfectly, deny create table will prevent some groups from create table in the library But I wonder, why pre assign with metadata engine doesn't prevent user from writing the library(isn't deny access WriteMetadata will prevent user from creating table in the library?)   Hi anja,   I create the library through management console   Regards, Charlie ... View more

Re: Pre-Assigned Library Authorization doesn't set correctly

by Fluorite | Level 6 in Administration and Deployment
‎01-24-2017 03:26 AM
‎01-24-2017 03:26 AM
Hi Linus,   It's SAS EG application Running libname code will grant the user to all permission   libname yourlib list; I have tried read only properties set in the library, It work, but this case, I need to set some group to read write delete, while others are read only   Regards, Charlie ... View more

Pre-Assigned Library Authorization doesn't set correctly

by Fluorite | Level 6 in Administration and Deployment
‎01-24-2017 03:04 AM
‎01-24-2017 03:04 AM
Hi, I am set library properties to pre assigned type By metadata library engine At the authorization , I set the user to read and read metadata only, so it should be error when I am trying to export and delete data in it. Instead of error, it delete and write executed successfully.   I wonder, what setting need to be set?   Regards, Charlie ... View more

Re: Code running slow in SAS 94

by Fluorite | Level 6 in SAS Data Management
‎08-12-2016 12:30 AM
‎08-12-2016 12:30 AM
Hi Patrick, This is quite weird, but, after changing the views to tables. It run normal again. Thanks ... View more

Re: Code running slow in SAS 94

by Fluorite | Level 6 in SAS Data Management
‎08-10-2016 02:56 AM
‎08-10-2016 02:56 AM
Hi Roger,   Thanks for your insight.. I will try to modified the code   Thanks ... View more

Re: Code running slow in SAS 94

by Fluorite | Level 6 in SAS Data Management
‎08-10-2016 02:50 AM
‎08-10-2016 02:50 AM
Hi Linus,   I update the post, so community user know which lines to check..   Thanks ... View more

Code running slow in SAS 94

by Fluorite | Level 6 in SAS Data Management
‎08-09-2016 10:36 PM
‎08-09-2016 10:36 PM
Hi,   Just migrate to SAS 9.4 , and tested some similar Code which consume a lot more time to process in SAS 9.4 The Code are generated from SAS Data Integration. There a slight different, in SAS 9.3 it has   %let SYS_SQL_IP_SPEEDO = Y; %let SYS_SQL_MAPPUTTO = sas_put; %let SYS_SQLREDUCEPUT = DBMS;   But , it automatically generated from SAS Data Integration   Try to query from work.WCUST90 view , it resulted differently in 9.3 and 9.4 The count command : select count(1) from work.WCUST90; on SAS 9.3 consume 39 secs , while in SAS 9.4 it consume 9 hours!!! (On SAS 9.4 it has some warning : "The execution of this query involves performing one or more Cartesian product joins that can not be optimized." while in 9.3, it has no warning)   Warning : the code quite long. Please give attention on the end of code : select count(1) from work.WCUST90 , because that was the major difference   Attached files are the codes , and the logs.   Please help.. Thanks   Regards, Charlie   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-03-2017 11:23 PM
Likes given to
Quick links