Hello,
I don't remember but there is a Unix command or a SAS command to reduce the quantity of information into a log file
See the example below
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_workB88B00008C1A_stha8n09z
Libref=TEMP Engine=V9 Member=INFORCE_AUTO_CONTACT_20250806 MemberType=DATA Openmode=OUTPUT Path=/dwh_actuariat/sasprocess/prodmens/InforceCntprep/temp
NOTE: Compressing data set TEMP.INFORCE_AUTO_CONTACT_20250806 decreased size by 54.35 percent.
Compressed is 725 pages; un-compressed would require 1588 pages.
NOTE: Table TEMP.INFORCE_AUTO_CONTACT_20250806 created, with 331772 rows and 30 columns.
Libref=TEMP Engine=V9 Member=INFORCE_AUTO_CONTACT_20250806 MemberType=DATA Openmode=OUTPUT Path=/dwh_actuariat/sasprocess/prodmens/InforceCntprep/temp
NOTE: Compressing data set TEMP.INFORCE_AUTO_CONTACT_20250806 decreased size by 54.35 percent.
Compressed is 725 pages; un-compressed would require 1588 pages.
NOTE: Table TEMP.INFORCE_AUTO_CONTACT_20250806 created, with 331772 rows and 30 columns.
Those "LIBREF=" messages are not generated by SAS. SAS ones usually start with NOTE:, or WARNING: or ERROR:.
Someone in your organisation has added the logic to do that. Talk to your SAS administrator to see if there is any way to switch them off.
Not sure what I see in your log, a bigger sample might help to understand.
And what parts do you want to remove?
Try this to see what option are available, and what they are set to:
proc options group=logcontrol;
run;
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
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.
Those "LIBREF=" messages are not generated by SAS. SAS ones usually start with NOTE:, or WARNING: or ERROR:.
Someone in your organisation has added the logic to do that. Talk to your SAS administrator to see if there is any way to switch them off.
Try system options ERRORS=0 :
options errors=0; data x; set sashelp.class; x=input(sex,best.); run;
10 options errors=0; 11 data x; 12 set sashelp.class; 13 x=input(sex,best.); 14 run; NOTE: 达到 ERRORS= 选项设置的限制。系统将不打印该类型的其他错误。 NOTE: 在以下位置无法执行算术运算。运算结果已设为缺失值。 每个位置的指定方式: (次数)位置(行:列)。 19 次,位于 13:3 NOTE: 从数据集 SASHELP.CLASS. 读取了 19 个观测 NOTE: 数据集 WORK.X 有 19 个观测和 6 个变量。 NOTE: “DATA 语句”所用时间(总处理时间): 实际时间 0.01 秒 CPU 时间 0.01 秒
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.