Modified to support VALIDVARNAME=ANY.   options validvarname=any; %let data=sashelp.shoes(rename=(product='Product type'n Returns='Returns to Store'n)); data size(keep=_name_ _length_); set &data end=_eof; array _c[*] _character_; array _s[10] _temporary_; do _i_ = 1 to dim(_c); _s[_i_] = max(_s[_i_],length(_c[_i_])); end; if _eof then do _i_ = 1 to dim(_c); length _name_ $64; _name_ = nliteral(vname(_c[_i_])); _length_=_s[_i_]; output; end; run; proc print; run; filename FT23F001 temp; options missing=' '; data _null_; file FT23F001; if 0 then set &data; if _n_ eq 1 then link putretain; set size; put 'Length ' _name_ '$' _length_ ';'; return; putretain: /* Preserve VARNUM order in the new dataset. */ length _VNAME_ $64; do while(1); call vnext(_vname_); if upcase(_vname_) eq '_NAME_' then leave; _vname_ = nliteral(_Vname_); put 'Retain ' _Vname_ +(-1) ';'; end; return; run; data resized; %include FT23F001 / source2; set &data; run; proc contents varnum; run; proc contents data=&data varnum; run; @lihongamerica wrote: Hi Jade, I run this code to some data, it works. But for another data there is some error: 29 %let data=sas2012.elig14; 30 %let resized=sas2012.resize_elig14; Do you now how to solve it?   ... View more

PROC PRINTTO @MART1 wrote: Hi @data_null__    I can't find the way to select the outputs from PROC COMPARE to add to PROC PRINT (never used PROC PRINT before unfortunately).   Below is an example with dummy data: data WORK.TABLE_A; input DAY VAL1 VAL2; datalines; 20190106 2 452 20190107 5 658 20190108 2 743 20190109 8 44 20190202 9 698 20190202 9 698 ; run; data WORK.TABLE_B; input DAY VAL1 VAL2; datalines; 20190106 2 58 20190107 5 658 20190108 2 12 20190109 8 44 20190202 9 698 20190202 9 698 ; run; title "Test"; PROC COMPARE BASE = TABLE_A COMPARE= TABLE_B briefsummary ; ID DAY; RUN; (so using PROC PRINT, I'd like to display the 2nd and 3rd boxes, not the one crossed out)           could you please give me an example of how to do this?   many thanks   ... View more

Use PROC PRINTTO to "capture" the default BRIEF report and edit it into the REPORT you need.   @MART1 wrote: Hi @data_null__    Thanks for your suggestion,   Actually I would need a few more info than the dups (I know, that's contrary to what I originally said!!).   Basically I'd like to use a few options from PROC COMPARE (i.e. listing all variables where there is a difference), but without the initial WARNINGs and MESSAGEs (it's just cosmetic, but it may confuse the users of the report).   thanks thanks     (I'm trying to create a high level report with )     ... View more

Perhaps you could use PROC SORT to find dups. 447 proc sort data=sashelp.class out=dups uniout=uni nouniquekey; 448 by sex age; 449 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: 4 observations with unique key values were deleted. NOTE: The data set WORK.DUPS has 15 observations and 5 variables. NOTE: The data set WORK.UNI has 4 observations and 5 variables. duplicates ... View more

Use by-variable directivies in TITLE statement(s).  You will also need a BY statement.   Title5 j=l "#byval1"; ... View more

This paper might be helpful.   Using Memory Resident Hash Tables to Manage Your Lookup Control Files   ... View more