what do we do if the denominator look like -1E-16 ?   ... View more

Group=LOGCONTROL CPUID Prints the CPU identification number at the beginning of the SAS log. DATE Prints the date and time that a SAS program started. DECIMALCONV=COMPATIBLE Specifies the binary to decimal conversion and formatting methodology. NODETAILS Does not display additional information when files are listed in a SAS library. DMSLOGSIZE=99999 Specifies the maximum number of rows that the SAS Log window can display. NODTRESET SAS does not update the date and time in the titles of the SAS log and procedure output file. NOECHOAUTO Does not write statements that are in the AUTOEXEC file to the SAS log as they are executed. ERRORS=20 Specifies the maximum number of observations for which SAS issues complete error messages. HOSTINFOLONG Print operating environment information in the SAS log when SAS starts. LIMITPROCNOTES=2147483647 Specifies the number of notes printed by a procedure to the SAS log. LINESIZE=132 Specifies the line size for the SAS log and for SAS procedure output for the LISTING destination. LOGAPPLNAME= Specifies a SAS session name for SAS logging. NOLOGLANGCHG Disables changing the language of the SAS log when the LOCALE= option is changed. LOGPARM=WRITE=BUFFERED ROLLOVER=NONE OPEN=REPLACE Specifies when SAS log files are opened, closed, and according to the LOG= system option, how they are named. MISSING=. Specifies the character to print for missing numeric values. NOMLOGIC Does not trace macro execution or write the results to the SAS log. NOMLOGICNEST Does not display the macro nesting information in the SAS log for MLOGIC output. NOMPRINT Does not display the SAS statements that are generated by macro execution. MSGLEVEL=N Specifies the level of detail in SAS log messages. NEWS=!SASROOT/misc/base/news Specifies the location of the news file that is to be written to the SAS log immediately after the header. NOTES SAS writes notes to the SAS log. NUMBER Prints the page number on the first title line of each page of SAS output. NOOVP Disables overprinting of error messages to make them bold. NOPAGEBREAKINITIAL Does not begin SAS log and procedure output for the LISTING destination on a new page. PAGESIZE=60 Specifies the number of lines that compose a page of the SAS log and SAS output. PRINTMSGLIST Specifies to print the entire list of messages to the SAS log. SOURCE Writes program source statements to the SAS log. NOSOURCE2 Does not write secondary source statements from included files to the SAS log. NOSYMBOLGEN Does not display the results of resolving macro variable references in the SAS log. ECHO= Specifies a message that is echoed to the SAS log while initializing SAS. RTRACE=NONE Specifies whether to produce a list of resources that are read or loaded during a SAS session. NOFULLSTIMER Does not write performance statistics to the SAS log. NOMSGCASE Specifies that SAS writes notes, warning, and error messages in mixed casing. NOOPLIST Does not write SAS system option settings to the SAS log. STIMEFMT=(NLDATM2. HMS TIMEAMPM KB MEMFULL TSFULL NC) Specifies the format that is used to display the FULLSTIMER and STIMER output for timestamp, memory, CPU and elapsed time statistics. STIMER Writes real and CPU time to the SAS log. NOVERBOSE Does not write start-up system options to the SAS log. ... View more

too many libref information Libref=CNTPDMU Engine=SNOW Member=FCT_PL_COV_DRVR_PREM MemberType=DATA Openmode=INPUT Path=ifcedpnprd.ca-central-1.privatelink.snowflakecomputing.com Libref=CNTPDMU Engine=SNOW Member=DIM_PL_CNTRCT_VER MemberType=DATA Openmode=INPUT Path=ifcedpnprd.ca-central-1.privatelink.snowflakecomputing.com Libref=CNTPDMU Engine=SNOW Member=DIM_PL_CNTRCT_VER MemberType=DATA Openmode=INPUT Path=ifcedpnprd.ca-central-1.privatelink.snowflakecomputing.com Libref=CNTPDMU Engine=SNOW Member=DIM_PL_RSK_VER_AUP MemberType=DATA Openmode=INPUT Path=ifcedpnprd.ca-central-1.privatelink.snowflakecomputing.com Libref=CNTPDMU Engine=SNOW Member=DIM_PL_ROLE_VER_INSRD MemberType=DATA Openmode=INPUT Path=ifcedpnprd.ca-central-1.privatelink.snowflakecomputing.com Libref=CNTPDMU Engine=SNOW Member=DIM_PL_COV_VER MemberType=DATA Openmode=INPUT Path=ifcedpnprd.ca-central-1.privatelink.snowflakecomputing.com Libref=CNTPDMU Engine=SNOW Member=DIM_PL_COV_VER MemberType=DATA Openmode=INPUT Path=ifcedpnprd.ca-central-1.privatelink.snowflakecomputing.com Libref=WORK Engine=V9 Member=TEMPTBL MemberType=DATA Openmode=INPUT Path=/saswork/sw_dev/SAS_workF60E0000F839_stha8n09z Libref=TEMP Engine=V9 Member=INFORCE_AUTO_CONTACT_20250807 MemberType=DATA Openmode=OUTPUT Path=/dwh_actuariat/sasprocess/prodmens/InforceCntprep/temp NOTE: Compressing data set TEMP.INFORCE_AUTO_CONTACT_20250807 decreased size by 54.37 percent. Compressed is 725 pages; un-compressed would require 1589 pages. NOTE: Table TEMP.INFORCE_AUTO_CONTACT_20250807 created, with 331988 rows and 30 columns. usually One line for libref cntpdmu will be sufficient, no libref work  ... View more

filename oscmd pipe "unzip -l /dwh_actuariat/sasdata_controlled/current/be/othr/bel.prod0030.saf3fm.data/saf3fm_billing.zip 2>&1"; data _null_; infile oscmd; input; put _infile_; run; What I am getting: Archive: /dwh_actuariat/sasdata_controlled/current/be/othr/bel.prod0030.saf3fm.data/saf3fm_billing.zip Length Date Time Name --------- ---------- ----- ---- 297385440 07-30-2025 06:06 SAF3FM.XPORT --------- ------- 297385440 1 file Is there a way to put the file name into a macro function and execute the next unix command in work as we may have the file name ? ... View more

This script works perferctly. However, I would like to understand the signification of the exclamation mark ... View more

the option -type -name ‘*_prm*’ is working but not with the -path option  or the path option is working but not the -type option    please provide an example with the grep v option       -type f -name '*_prm*' -path '/dwh_actuariat/sasdata/Data_Retention/Data_Retention_CleanFiles' -prune -o -print   ... View more

Hello,   I can not filter the information into the test dataset.  I need to find the good unix command to do what I want, because, I am going to delete those file after.   I am looking for something like below but it is like either I am able to filter the directories but not search for file containing _prm   filename oscmd pipe "find /dwh_actuariat/sasdata/Data_Retention/ -type f -name '*_prm*' -path '/dwh_actuariat/sasdata/Data_Retention/Data_Retention_CleanFiles' -prune -o -print -path '/dwh_actuariat/sasdata/Data_Retention/Data_Retention_Anonymized' -prune -o -print -path '/dwh_actuariat/sasdata/Data_Retention/Data_Retention_list' -prune -o -print -path '/dwh_actuariat/sasdata/Data_Retention/temp' -prune -o -print -path '/dwh_actuariat/sasdata/Data_Retention/Audit' -prune -o -print -path '/dwh_actuariat/sasdata/Data_Retention/Validation' -prune -o -print -path '/dwh_actuariat/sasdata/Data_Retention/sas2001b' -prune -o -print "; data test; length text $1000.; infile oscmd; input; text= _infile_; run; ... View more

I have tested my code and I have found that for the else condition, an output statement is fine.  But for the if condition, I do not need to replace the dataset but to append the data generated. So my question is how do we do that. How do we convert the condtion  if inlist and inbase then output dest2.&filename._Anonym;   if inlist and inbase then do; proc append base=dest2.&filename._Anonym; data= what do we put here; run;   ... View more