Thank you! I have got a suggestion that works very well: %macro test(year); libname inlib "D:\sasdata\test\year&year.\V4"; data want&year; merge inlib.dm&year.ir&year inlib.dm&year.vm&year ; by ID; run; libname inlib clear; %mend; %test(17) %test(18); ... View more

Use PROC MEANS.  The default is to summarize all numeric variable NOT mentioned in other statements.   ods select none; proc means stackods data=sashelp.class; class age; ods output summary=summary; run; ods select all; proc print; run; ... View more

Thank you Quentin! I try to avoid Excel as well. In this case I needed to create 2 variables based on information from a description (multiple strings). In my example the column "beskrivning". In Excel I can look for this particular information and create the variables in a very simple way by writing the Word or words I am looking for using the filter and later on importing it back to SAS. ... View more