SAS Support Communities

Due to a requirement in creating multiple SAS libraries from time to time in the Management Console, I am trying to figure out how to do this programmatically.  These libraries are pointing to external databases. So far, using the available examples I was able to use the following code to create library metadata. SAS Version 9.4M6.   proc metadata in='<AddMetadata> <Metadata> <SASLibrary Name="Test Library" Desc="This is a test" Folder="\Shared Data\Test" Engine="DB2" IsDBMSLibname="1" IsHidden="0" Libref="testlib" IsPreassigned="0" PublicType="Library"> </SASLibrary> </Metadata> <Reposid>A0000001.A849HGWS</Reposid> <NS>SAS</NS> <Flags>268435456</Flags> <Options/> </AddMetadata> '; However this is still missing the resource template, schema name, location (folder name). Is there any way we can add these programmatically as well? Also anyway to update the access templates? Any attributes that I can assign these values to when calling proc metadata? Thanks in advance. ... View more

We are doing a migration from SAS base 9.4 to 9.4M6. This is on a Windows server. The migration of libraries and creation of users are fine. The issue we are facing is in migrating the user projects. The user home directories for each user under "User Folders" gets created for the first time automatically once a user logs in. We cannot wait for all the users to login or ask the users to login and then do an export an import of the projects as we want to make it seamless.    What we tried doing was importing the projects with the user folder itself i.e. we created the our_user folder in the import process itself but when the user actually logged in for the first time it created another folder name our_user(1) and the user was assigned this folder and the projects in our_user folder was not viewable or usable to to the user.    Is there any mechanism where we can create user home folders and map them to the actual user logins so that when the user logs in for the first time it doesn't go and create a new folder but starts using the folder that we've created?    Apologies for any confusion. A newbie here and I've searched all over the forum as well as google but couldn't find anything on this.  ... View more