I got nothing from LOG. 1 2 data a; 3 input source_code : $40. b c; 4 cards; NOTE: 数据集 WORK.A 有 2 个观测和 3 个变量。 NOTE: “DATA 语句”所用时间（总处理时间）: 实际时间 0.42 秒 CPU 时间 0.06 秒 7 ; 8 run; 9 data b; 10 input source_code : $40. bb xxxx : $20.; 11 cards; NOTE: 数据集 WORK.B 有 2 个观测和 3 个变量。 NOTE: “DATA 语句”所用时间（总处理时间）: 实际时间 0.00 秒 CPU 时间 0.00 秒 14 ; 15 run; 16 data c; 17 input source_code : $40. bbbbbb; 18 cards; NOTE: 数据集 WORK.C 有 2 个观测和 2 个变量。 NOTE: “DATA 语句”所用时间（总处理时间）: 实际时间 0.02 秒 CPU 时间 0.01 秒 21 ; 22 run; 23 24 25 26 27 %let library= work ; *the library you need to search; 28 %let vname= source_code; *the variable in common you need to search; 29 %let string= KL ; *the string you need to search, it could be uppercase or lowcase; 30 31 proc delete data=want;run; WARNING: 文件“WORK.WANT.DATA”不存在。 NOTE: “PROCEDURE DELETE”所用时间（总处理时间）: 实际时间 0.00 秒 CPU 时间 0.00 秒 32 proc iml; NOTE: 正在写入 HTML Body（主体）文件: sashtml.htm NOTE: IML Ready 33 dsn="&library.."+datasets("&library."); 34 do i=1 to nrow(dsn); 35 use (dsn[i]); 36 read all var {&vname.} into x; 37 flag=(upcase(x)="%upcase(&string)"); 38 if any(flag=1) then do; 39 loc=loc(flag); 40 obs=obs//t(loc); 41 table=table//repeat(dsn[i],ncol(loc)); 42 end; 43 close (dsn[i]); 44 end; 45 create want var {table obs}; 46 append; 47 close; NOTE: Closing WORK.WANT NOTE: 数据集 WORK.WANT 有 3 个观测和 2 个变量。 48 quit; NOTE: Exiting IML. NOTE: “PROCEDURE IML”所用时间（总处理时间）: 实际时间 1.71 秒 CPU 时间 0.31 秒 49 50 proc print noobs;run; NOTE: 从数据集 WORK.WANT. 读取了 3 个观测 NOTE: “PROCEDURE PRINT”所用时间（总处理时间）: 实际时间 0.08 秒 CPU 时间 0.01 秒 But if you are using CAS engine or other engines ,not BASE engine. Could try this one (v9 engine). if it was still not work, then try Tom 's code . libname x v9 'c:\temp\'; data x.a; input source_code : $40. b c; cards; KL 1234567891 1234567891 wwrew 232442 343 ; run; data x.b; input source_code : $40. bb xxxx : $20.; cards; KL 233 2323 kl 1234567891 1234567891 ; run; data x.c; input source_code : $40. bbbbbb; cards; Thisaccount 1234567891 KLsaccount 1234567891 ; run; %let library= x ; *the library you need to search; %let vname= source_code; *the variable in common you need to search; %let string= KL ; *the string you need to search, it could be uppercase or lowcase; proc delete data=want;run; proc iml; dsn="&library.."+datasets("&library."); do i=1 to nrow(dsn); use (dsn[i]); read all var {&vname.} into x; flag=(upcase(x)="%upcase(&string)"); if any(flag=1) then do; loc=loc(flag); obs=obs//t(loc); table=table//repeat(dsn[i],ncol(loc)); end; close (dsn[i]); end; create want var {table obs}; append; close; quit; proc print noobs;run; ... View more

If the goal is to add space on either end of the axis, you can use OFFSETMIN and OFFSETMAX without having to create unused tick values. Just replace you XAXIS statement with the following (adjust the offset values to taste): xaxis offsetmin=0.1 offsetmax=0.1; ... View more

It feels like "something happened" and SAS overreacted. Backward compatibility was imho always an important selling point for SAS. I believe that it would have been more than sufficient for these functions to be disabled as a default but with some option to enable them - something similar to noxcmd. ... View more

John.King , There is a built-in sas macro to make it happen. This built-in macro can change any encoding into other encoding: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/nlsref/p1g1d26os4w0von1cdfh827foo3r.htm   For example: Change EUC-CN(your sas session is EUC-CN encoding) into UTF-8: %let path= C:\temp\原始的SAS数据集\ ; options validvarname=any; libname x v9 "&path."; /* %COPY_TO_NEW_ENCODING(from_dsname, to_dsname, new_encoding) */ %copy_to_new_encoding(x.have, outdata, utf8) ... View more

Use the MacroArray package.   1) Documentation 2) Article   %macro inf_value(ttt,information_value,numeric_Vars,Ind_Failure); %put [&sysmacroname.] &numeric_Vars.; data _null_; &numeric_Vars.=42; put _all_; run; %mend; %loadPackage(macroArray) /* macroarray */ %array(varsList[*] a_Shir_SmlHov_Pigur a_Shir_AKM_HZRHIUV a_Shir_Vetek_age_Balut a_CDO_ExCC_mx_pos_prob ,vnames=Y ,macarray=Y) /* loop over macroarray calling %inf_value() macro */ %do_over(varsList,phrase=%nrstr( %inf_value(ttt,information_value,%varsList(&_i_.),Ind_Failure); )) /* clean up after using macroarray */ %deleteMacArray(varsList,macarray=Y)   Bart ... View more

Yes you are right, that will do the same ... View more

Looks like the moderator has changed the solution to the correct one. Thanks all. ... View more

It explains the matter. Thank you so much! it helps a lot! ... View more

The data step always loops until something stops it.   So I would restate the question as:   How does SAS know when to STOP looping through the data?  What normally stops a data step is when it reads past the end of its inputs.   In your example when the INPUT statement finds there are no more lines to read from Pumpkin.dat.   In the case of a data step that reads in SAS datasets (with SET or MERGE statement for example) it normally stops when the SET or MERGE finds no more observations to read.   Other ways to stop a data step are :  the STOP statement.  a step that has no inputs knows it does not need to loop. A step that does have inputs but because of conditional logic fails to read from any of them in a pass through the implied loop will write a note and stop.   ... View more

Hi SAS-C,   Small update, just FYI.  The BasePlus package version 2.4.0 is available at SAS Packages Archive.    This time changes were done in  %dirsAndFiles()  macro. Release notes provide all the details and some examples. Documentation.   Bart ... View more

Kurt already gave you the answer. 'kad' stands for Keep Alphabet Digit characters, and get rid of others characters. ... View more

@yabwon Wonderful, thank you for sharing! ... View more

@NewUsrStat wrote: Dear all, I'm trying to subset from a dataset all columns (variables) containing a pattern (named "Q1"). I tried the following:   data myout; set mydata; keep Q1; run; but it keeps also Q11,Q12, ... Can anyone help me please? No, the keep statement selects only Q1. Nothing else. ... View more