I need to capture SAS macro variable values that are passed into a multi-use SAS macro that is used by hundreds of SAS jobs at the same time, all day long, 24/7/365, and write them to a common audit trail location so that we know what variable values folks are passing in to the macro to be able to create reports for decision-making for leadership.   How can I write out the variable values to a common location without contention/locking being an issue, AND without writing to an external database?    A SAS dataset seems out of the question because of locking.  Is there a way to change a SAS dataset's properties to be shared, like we used to set DISP=SHR in JCL on mainframe datasets so that multiple users can write to the dataset at the same time?   I did think of a PROC APPEND, only because of the performance being faster since it doesn't have to read in all the data from the base dataset, but still, with hundreds of jobs hitting the macro all at once,  I still think there is a risk of performance issues for our jobs.   A third idea I thought of was to add a txt file write to the macro that would jsut dump the macro variable values to its own txt file in a folder location.  The, to run reports I would read in the hundreds - thousands - of txt files, grabbing the values and writing them to a single SAS dataset for reporting.  It would work but seems clunky/messy, but if that's the only way to do this without adding a database write to the macro (which I also think would have contention issues, due to the heavy and constant use this macro gets.)   Any ideas?  (not an option for running jobs in succession as they come from many different teams from all over the company.) ... View more

I want to be able to 1) read ServiceNow for all unassigned sc tasks under my group 2) read ServiceNow again to obtain the corresponding RITM numbers for each task (we need bits of information from the sc task as well as from the RITM in order to process the ServiceNow request) 3) Update the sc task to show work is in progress and that it has been assigned to the automated process I know this can be done, but am having trouble finding the correct URL syntax that will do items 2 and 3. Here is the syntax I found that does accomplish item #1 and brings back every unassigned sc task out there.  Now I just need to match each task with its RITM, and update the task to show it is work in progress and assigned: libname mylib "/mydir/myfolder/"; %macro get_unassigned_task(); %LET unpw =xxxxxxxxxxx DATA _NULL_; call symput('encode',put("&unpw",$base64X76.)); RUN; filename response TEMP; filename headers TEMP; %let url_query=%nrstr(https://mysite.service-now.com/api/now/table/task?sysparm_query=name%3D); %let url_query_cont=%nrstr(&assignment_group=MYASSIGNMENTGROUP); %put &url_query.&url_query_cont; options set= SSLCALISTLOC="/sas/sas94m5install/SASSecurityCertificateFramework/1.1/cacerts/cacerts.pem"; PROC HTTP url="&url_query.&url_query_cont." out=response headerout=headers; headers "Accept"="application/json" "Content-Type"="application/json" "Authorization"=" Basic &encode"; RUN; LIBNAME RESPONSE JSON fileref=response; PROC SQL NOPRINT; SELECT count(*) into :total_obs FROM RESPONSE.ALLDATA; QUIT; %if &total_obs > 1 %then %do; PROC SQL NOPRINT; SELECT * INTO :my_vAR FROM RESPONSE.RESULT; quit; proc sql noprint; create table mylib.active as select * from RESPONSE.RESULT where sys_class_name = "sc_task" and assigned_to = "" and active="true" ; quit; data mylib.active_in_progress; set mylib.active; run; RUN; %end; %else %do; %PUT No unassigned tasks were found for workgroup MYASSIGNMENTGROUP.; %end; %mend; %get_unassigned_task()   I have been all over the ServiceNow site, so far, I have nothing: Tables | ServiceNow Developers Can someone please advise? Spinning my wheels a bit.... ... View more

How do I unzip a PASSWORD PROTECTED .gz file using SAS code? I know there is a way to unzip .gz files with SAS code, but is there a way to also open password protected .gz files using SAS code?   Example: x gunzip --stdout "/mydir/test_gz_password_protected.sas7bdat.gz" > "/mydir/test_gz_no_password.sas7bdat";   How do I modify this to incorporate the password? ... View more