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: 
milts
‎05-12-2018
  • 339 Posts
  • 30 Likes Given
  • 0 Solutions
  • 23 Likes Received

SAS Config Files Sequence

by Pyrite | Level 9 in Administration and Deployment
‎07-13-2017 09:24 PM
2 Likes
‎07-13-2017 09:24 PM
2 Likes
Hi,   I was checking my SAS Enterprise Guide which connects to our SASApp. When i run proc options and see the CONFIG option, I see multiple config files appended. I would like to inquire on the following:   - Are the config files executed sequentially? - If a certain option was set on the first config file, and set again on the succeeding config file, will it overwrite the setting or ignore the setting on the succeeding file?   Thanks! ... View more

SQL ODBC ERROR: Unable to transcode data to/from UCS-2 encoding

by Pyrite | Level 9 in SAS Programming
‎07-13-2017 10:05 AM
‎07-13-2017 10:05 AM
I have a SQL Server table with chinese characters in it. I am able to view it properly through Base SAS (Unicode Suppport), but when I try to open it in Enterprise Guide, I hit the error "Unable to transcode data to/from UCS-2 encoding" upon clicking the dataset.     libname mydb odbc noprompt="driver=sql server;server=mysrv/db;uid=sa;pwd=pwd;database=mydb;" schema=dbo; Greatly appreciate any inputs on this.   Thanks! ... View more

Adding Authentication Domain for SQL Server

by Pyrite | Level 9 in Administration and Deployment
‎07-09-2017 04:57 AM
‎07-09-2017 04:57 AM
Hi,   I have set-up a metadata object ODBC server that connects to a SQL Server in SAS Management Console with the following settings:   ODBC Data Source Information (Connection String): "Driver=SQL Server;Server=MyServer\SRVR;Database=MYDB;"   Authentication Information: Authentication Type: User/Password Authentication Domain: mysa (SQL Server account only)   When I create a library in SMC and register tables, a prompt will appear to key in the login. I input the mysa account and password but fails. What account should I put in for this to work? Greatly appreciate any help.   Thanks in advance! ... View more

Connection String to SQL Server Not Working

by Pyrite | Level 9 in SAS Programming
‎07-05-2017 11:34 PM
‎07-05-2017 11:34 PM
I'm having trouble connecting to a SQL Server 2016 DB when the string password is encoded.   This works. libname test2 odbc noprompt="server=SRV;Driver=SQL Server;uid=sa;pwd=mypwd;database=DB";   But this doesn't work. libname test2 odbc noprompt="server=SRV;Driver=SQL Server;uid=sa;pwd='{SASENC}12345F';database=DB";   Appreciate any help. Thank you very much! ... View more

Putting a value with Quotes in a File

by Pyrite | Level 9 in SAS Programming
‎06-26-2017 02:35 AM
‎06-26-2017 02:35 AM
I'm having some problems when putting a string with quotes into a file. I starts to get some problems when I assign it into a variable in my data step.   Greatly appreciate any assistance. Thanks!     %let val = -remove "User1":ALL; data _null_; file myfile; tmp = "&val"; put tmp(~); run; ... View more

Re: Updating User Group of Metadata Users

by Pyrite | Level 9 in Administration and Deployment
‎06-13-2017 11:39 PM
‎06-13-2017 11:39 PM
I have managed to make it work based on the documentation link you have provided.   Just to give a summary of the steps I did for other people's reference as well.   1. Called %mduextr to extract metadata tables 2. Called %mducmp comparing it to itself which will give me all the empty _add and _delete tables I need 3. Populate the grpmems_add to include users in the Restricted access and populate the grpmems_delete to include all current groups the users are included 4. Call %mduchglb to perform the update in metadata   Thanks a lot for the help! Greatly appreciate it.   Cheers! ... View more

Re: Sync uner from LDAP to MC - works but fails to add to a group

by Pyrite | Level 9 in Administration and Deployment
‎06-13-2017 10:44 PM
1 Like
‎06-13-2017 10:44 PM
1 Like
You actually save me hours/days trying to figure out how to do update of a user's group assignments!   After pointing out the XML files to a specific path I saw that the Ids were blank as I only populated the keyids and not the objids of my _add and _delete tables. ... View more

Re: Updating User Group of Metadata Users

by Pyrite | Level 9 in Administration and Deployment
‎06-13-2017 06:23 AM
‎06-13-2017 06:23 AM
The challenge on this on our requirement is that the authentication should not be based on the AD, but rather some text file which another source is providing.   Basically the input file is a text file containing the user and the group which is loaded as a table. This username is also defined in SAS Metadata. Everyday the file will be processed and will be compared with the previous data. If there is the change in the user's group, that user should be deleted from all other groups assigned to him in SMC and then will be assigned to another group which have Deny RM in most of the SAS folders. ... View more

Updating User Group of Metadata Users

by Pyrite | Level 9 in Administration and Deployment
‎06-12-2017 10:53 PM
‎06-12-2017 10:53 PM
Does anyone know of a good resource with some examples on how to programmatically add/delete/update the group of a user in the SAS Metadata?    I've come across SAS 9.4 Language Interfaces to Metadata (https://support.sas.com/documentation/cdl/en/lrmeta/70119/HTML/default/viewer.htm#titlepage.htm) and the SAS Blog (http://blogs.sas.com/content/sgf/2016/01/13/sas-administrators-tip-keeping-track-of-sas-users/)  but didn't see some concrete examples of what I was looking for as the examples are more to just view but I'll need to either remove or add a group to specific users through a batch processed script.   Greatly appreciate your thoughts. Thanks in advance. ... View more

Re: Double Double Quoting on SYSTASK command

by Pyrite | Level 9 in SAS Programming
‎05-24-2017 10:01 PM
‎05-24-2017 10:01 PM
This partially solved my problem totally not off topic and thanks for the suggestion.   As a workaround I had to put the resolving command to a batch file and let systask execute it.    data _null_; file "&path.\&job..bat"; length command $ 1000; command=<catx portion>; put command; run; /* execute generated batch job script */ systask command "&path.\&job..bat" wait taskname=&taskname status=taskrc;     ... View more

Double Double Quoting on SYSTASK command

by Pyrite | Level 9 in SAS Programming
‎05-24-2017 03:12 AM
‎05-24-2017 03:12 AM
  Hi,   This is in reference to my previous question which has been resolved to use systask to execute a python script   https://communities.sas.com/t5/Base-SAS-Programming/Quoting-on-SYSTASK-command/m-p/340337#M77770     %let command = activate &python_env %nrstr(&&) python %nrquote(""%trim(&python_script_path)\load_data.py"") %nrquote(""%trim(&source)"") %nrquote(""%trim(&target)"") 2> %nrquote(""&logfile..log""); systask command "&command" wait status=taskrc;     While the double double quote is able to successfully execute the python script, I get this note:   NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 49: LINE and COLUMN cannot be determined.   Data is loaded successfully but I get an error due to this problem. Strange that the SAS log says that this is an error when it's a note.   Any help or enlightenment would be greatly appreciated. Thank you!   Thanks!     ... View more

Email Working in SAS Studio University Edition but not in Base SAS

by Pyrite | Level 9 in SAS Programming
‎03-14-2017 10:25 PM
‎03-14-2017 10:25 PM
When I try to send an email in Base SAS I get some error that no default email etc. but when I try to run the same code in my SAS University Edition it was able to execute and send successfully. I tried to compare the configuration using proc options but there was no difference.   filename sendmail email ("myemail@email.com") subject="Testing"; data _null_; file sendmail; put "Testing"; run; Greatly appreciate any suggestions on how to resolve and enable sending email thru Base SAS. My email account runs on a office365 subscription if that helps in anyway.   Thanks! ... View more

Re: Quoting on SYSTASK command

by Pyrite | Level 9 in SAS Programming
‎03-13-2017 10:30 PM
‎03-13-2017 10:30 PM
Thanks a lot for the help. The double quoting works and lets me execute the python script properly.   Oh, and the second suggestion works as well!! Will definitely impose that one!  ... View more

Quoting on SYSTASK command

by Pyrite | Level 9 in SAS Programming
‎03-12-2017 11:15 PM
‎03-12-2017 11:15 PM
I would like to seek help on my script regarding quotes in my systask command; The command string is actually built the way I want it but when it gets resolved in the systask command it already breaks. I need to nrquote the variables I have as it can be possible there are spaces in the paths and filenames.   Greatly appreciate your help. Thanks!   %let pyscripts=C:\pyscripts; %let sourcefile=sample.csv; %let targettable=sample; /* Build string for command line execution */ %let command = activate myenv%nrstr(&&) python %nrquote("&pyscripts\load_source_file.py") %nrquote("&sourcefile") %nrquote("&targettable"); %put &command; /* Call python script for loading files*/ systask command "&command" status=loadstat ;       ... View more

Re: SAS Execute SQL Server BCP Command

by Pyrite | Level 9 in SAS Programming
‎03-01-2017 05:03 AM
‎03-01-2017 05:03 AM
Thanks for your inputs. If I SAS bulk loader, will it require the file to be converted to a sas dataset first before loading to SQL Server?  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-12-2018 02:19 AM
Likes given to
Quick links