About DarrylLawrence

DarrylLawrence · ‎03-28-2022

Good day We are using SAS CI Studio 6.6 (SAS 9.4 on Linux) and I need to know who I can call API's to send or receive data from within SAS CI Studio. We use custom code in Stored Procs to run Service Calls and I am sure we could include code to call an API (how would we do this?) - but need to know if this is possible in CI Studio using functionality in CI Studio and not custom code. All the blogs I have seen so far relating to CI Studio and API's are in SAS Viya - so does this mean we need to upgrade to SAS Viya to take advantage of the API integration functionality? Regards Darryl Lawrence

DarrylLawrence · ‎10-09-2021

Thank you, it worked!

DarrylLawrence · ‎10-09-2021

This is the code I am usign - copied from this blog I need to add the owner of the files - so we can send out reports to the owners to delete obsolete files. data filelist; length dname filename $256 dir level 8 lastmod size 8 user $32 ; format lastmod datetime20.; input dname; retain filename ' ' level 0 dir 1; cards4; /sas/analytics/sasdata/users /sas/analytics/projects ;;;; data filelist; modify filelist; rc1=filename('tmp',catx('/',dname,filename)); rc2=dopen('tmp'); dir = not not rc2; if not dir then do; fid=fopen('tmp','i',0,'b'); lastmod=input(finfo(fid,foptname(fid,5)),NLDATM100.); size=input(finfo(fid,foptname(fid,6)),32.); fid=fclose(fid); end; else do; dname=catx('/',dname,filename); filename=' '; lastmod=input(dinfo(rc2,doptname(rc2,5)),NLDATM100.); end; replace; if dir; level=level+1; do i=1 to dnum(rc2); filename=dread(rc2,i); output; end; rc3=dclose(rc2); run;

DarrylLawrence · ‎10-08-2021

This is a great solution. Do you know how I can add the owner (person who created the files) to the report?

DarrylLawrence · ‎11-06-2020

I created a SAS dataset in a folder on our Linux Server. I then opened an EXCEL Spreadsheet and connected to the SAS Dataset from the SAS addin menu. I applied filters to the dataset. I then shared the excel file with other users and asked them to play around with the filters, but the user gets and error when he clicks on "Edit Filters" in EXCEL. Please advise what needs to be changed to enable users - other than myself, who created the EXCEL file with the link to the SAS Dataset - to edit the filters. See attached document for screenshots.

DarrylLawrence · ‎02-05-2020

Thanks Juan Just wondering - would the metadata about each flow - in SAS Management Console, also be migrated so that I am able to edit the flow (add or remove jobs or change the scheduling time/data)?

DarrylLawrence · ‎02-05-2020

Good day All of my LSF flows need to be migrated to a new (AIX/UNIX) server. I can deploy the SAS programs in bulk to the new server, but can all the existing flows be exported (eg like a sas package file used to migrate metadata) and then imported on the new server? I currently have to re-create each flow and each calendar event in SAS Management Console on the new server and then Schedule each flow. With over 100 flows, this is going to take quite some time - so if the migration can be automated, it would be great!

DarrylLawrence · ‎11-19-2019

This works. The filenames to zip will be the same every month except for the date in the filename. I can put this in a macro variable and then reference the rundate in the ODS Package statements. %let rundate=20191028; ods package(reports) open ; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C93 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C94 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C95 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C96 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C97 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C98 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C99 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C100 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C101 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C102 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C103 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C104 &rundate..pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty_Rapid_Input_Validation_&rundate..pdf"; ods package (reports) publish archive properties (archive_name="Online_Models_Summary_&rundate..zip" archive_path="/sas/lsf/Eighty_Twenty/Inputs/PDF/"); ods package (reports) close;

DarrylLawrence · ‎11-19-2019

I tried this and it works - adding more than one file at a time. I will just write a macro for the date in the filename - will always be the 20th of the month ods package(reports) open ; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C93 20191028.pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C94 20191028.pdf"; ods package (reports) publish archive properties (archive_name="Reports.zip" archive_path="/sas/lsf/Eighty_Twenty/Inputs/PDF/"); ods package (reports) close;

DarrylLawrence · ‎11-19-2019

Yep - old school. Someone else said I must try ODS Package - https://blogs.sas.com/content/sasdummy/2014/01/28/create-zip-ods-package/ I tried this and it works - adding more than one file at a time. I will just write a macro for the date in the filename - will always be the 20th of the month ods package(reports) open ; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C93 20191028.pdf"; ods package (reports) add file="/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C94 20191028.pdf"; ods package (reports) publish archive properties (archive_name="Reports.zip" archive_path="/sas/lsf/Eighty_Twenty/Inputs/PDF/"); ods package (reports) close;

DarrylLawrence · ‎11-19-2019

My UNIX DBA helped me with this code. We must use the "tar" command instead of "zip" as zip is a windows based utility. /************************************************************************/ /* Zip the PDF Documents */ /************************************************************************/ data _null_; call system("tar -cvRf- /sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf |compress>>/sas/lsf/Eighty_Twenty/Inputs/Online_Models_Summary.tar.Z"); run;

DarrylLawrence · ‎11-19-2019

Thanks for the tip. I tried this yesterday but it failed. I have contacted my UNIX dba to find out of the correct syntax as it looks like the zip command does not work. 22 GOPTIONS ACCESSIBLE; 23 filename oscmd pipe "zip -r allpdf.zip /sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf 2>&1"; 24 25 data _null_; 26 infile oscmd; 27 input; 28 put _infile_; 29 run; NOTE: The infile OSCMD is: Pipe command="zip -r allpdf.zip /sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf 2>&1" /usr/bin/ksh: zip: not found. NOTE: 1 record was read from the infile OSCMD. The minimum record length was 30. The maximum record length was 30. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

DarrylLawrence · ‎11-19-2019

Hi there I tried ods package - but you can only attach one file. I need to automatically zip all the files in the folder on a monthly basis. Thanks Darryl

DarrylLawrence · ‎11-18-2019

Thanks for the quick reply Unfortunately I cannot logon to the terminal. I do not have access. Also, this has to be an automated process that runs every month. I can run the unix command in SAS but it does not create the zip file. Is there something wrong with the syntax? data _null_; call system("zip -r allpdf.zip /sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf"); run;

DarrylLawrence · ‎11-18-2019

Good day I have a folder that contains multiple PDF files. I want to create a zip file that must be emailed to someone. When I run this code, it creates the zip file but it only contains the last file written from the folder location. I pasted the log below the code - you can see the code referencing each PDF file but it looks like the individual pdf files are overwritten as the code runs and the zip file only contains the last file. How can I create one zip file that contains all the PDF documents in the (unix) folder? filename source "/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf"; filename tozip ZIP "/sas/lsf/Eighty_Twenty/Inputs/TFG_EIGHTY20_OPM_&FILEDATE..pdf.gz" ; data _null_; infile source; file tozip ; input; put _infile_ ; run; NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C93 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:40:22, File Size (bytes)=167015 NOTE: The file TOZIP is: Filename=/sas/lsf/Eighty_Twenty/Inputs/TFG_EIGHTY20_OPM_20191020.pdf.gz NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C94 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:40:46, File Size (bytes)=165533 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C95 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, 2 The SAS System 13:46 Monday, November 18, 2019 Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:41:10, File Size (bytes)=166410 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C96 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:41:34, File Size (bytes)=166450 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C97 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:41:58, File Size (bytes)=166928 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Cash Model Report_C98 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:42:22, File Size (bytes)=163935 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C100 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:39:33, File Size (bytes)=164781 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C101 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:39:39, File Size (bytes)=164970 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C102 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:39:45, File Size (bytes)=165148 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C103 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:39:51, 3 The SAS System 13:46 Monday, November 18, 2019 File Size (bytes)=165113 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C104 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:39:57, File Size (bytes)=163764 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty Credit Model Report_C99 20191028.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=28Oct2019:13:39:27, File Size (bytes)=165667 NOTE: The infile SOURCE is: Filename=/sas/lsf/Eighty_Twenty/Inputs/PDF/Eighty_Twenty_Rapid_Input_Validation_20191029.pdf, File List=/sas/lsf/Eighty_Twenty/Inputs/PDF/*.pdf, Owner Name=darrylla,Group Name=sas, Access Permission=-rw-rw-r--, Last Modified=29Oct2019:09:49:13, File Size (bytes)=100433 NOTE: 726 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1997. NOTE: 748 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 2113. NOTE: 761 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1997. NOTE: 777 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1997. NOTE: 769 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1997. NOTE: 756 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1997. NOTE: 734 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1806. NOTE: 738 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 2707. NOTE: 754 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 2228. NOTE: 728 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1919. NOTE: 712 records were read from the infile SOURCE. The minimum record length was 0. 4 The SAS System 13:46 Monday, November 18, 2019 The maximum record length was 1861. NOTE: 746 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1954. NOTE: 470 records were read from the infile SOURCE. The minimum record length was 0. The maximum record length was 1639. NOTE: 9419 records were written to the file TOZIP. The minimum record length was 0. The maximum record length was 2707. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.06 seconds

Online Status	Offline
Date Last Visited	‎01-11-2024 01:39 PM

SAS Customer Intelligence Studio - Pop up Window for Errors

Re: Treatment in SAS Customer Intelligence Studio

Treatment in SAS Customer Intelligence Studio

Re: Proc append

Re: Proc append

Re: Proc append

Re: Proc append

Re: Filtering a dataset on an indexed date field takes long

Filtering a dataset on an indexed date field takes long

Re: FCMP Python code works in traditional SAS, but returns errors in E...

Re: Unzipping zip and gz files using SAS

Re: Converting Calculated Item to Character fails in CI Studio

Re: Converting Calculated Item to Character fails in CI Studio

Re: Converting Calculated Item to Character fails in CI Studio

Re: first timers how to get around in Global Forum and Dallas

LSF Migration

Re: Create zip file of all files in a folder

InfoMap Studio - Updating process

Schedule Flow in Management Console Fails

SAS CI Studio 6.6

Re: List of Files in Directory and Subdirectories with File Attributes

Re: List of Files in Directory and Subdirectories with File Attributes

Re: List of Files in Directory and Subdirectories with File Attributes

SAS Addin for EXCEL - Error on Filtering on a SAS Dataset

Re: LSF Migration

LSF Migration

Re: Create zip file of all files in a folder

Re: Create zip file of all files in a folder

Re: Create zip file of all files in a folder

Re: Create zip file of all files in a folder

Re: Create zip file of all files in a folder

Re: Create zip file of all files in a folder

Re: Create zip file of all files in a folder

Create zip file of all files in a folder

SAS Global Forum 2019