Good day!   I am facing a small problem in my SAS code that I can't figure out. The macro below exports all SAS datasets in library MYLIB into csv files. It works seamlessly but the output csv file names come out all uppercase. I need them to be lowercase. Could you please tell me how to achieve it?   Thank you.   Libname MYLIB "C:\mypath";   %MACRO Convert2CSV(LIBNAME); /*do not change it!*/   data members; set sashelp.vmember(where=(LIBNAME = "&Libname")); /*do not change it!*/ retain obs 0; obs = obs+1;   keep memname obs; run; proc sql; select min(obs) into :min from members; quit; proc sql; select max(obs) into :max from members; quit; %Local d; %do d = &min %to &max;   proc sql; select compress(memname) into: Table from members where obs=&d; quit; %let tbl = %trim(&Table); 　 proc export dbms=csv data=&Libname..&Table outfile="C:\mypath\output\&tbl..csv";   run; %end; %mend;   %Convert2CSV(MYLIB);     ... View more

Hi,   I have over 100 datasets in my library and need to add a uniform prefix to each of them, let's say 'bc_25'. Could you please share your knowledge how to do this?   Thanks. ... View more

Hi,   A seemingly easy task of summarizing a variable by group has become challenging when I was asked to find the sum of only top three values in each group. I attached a sample table here. Need to find the totals of top 3 amounts for each industry group (amounts are already sorted in descending order). Some industry groups have only one or two records. Can anybody help me with this?   Thanks. ... View more

Hello, I have difficulties in removing duplicates in my dataset. There are certain conditions that I don’t know how to code. I have a table that lists companies in the form of company id, fiscal year end date (FYE), and date when the company reported some financial statements. Each company may report several statements on a given day for the same FYE, like in rows 2-3 or 5-7. Also, some companies can have more than one FYE falling in the same calendar year like in rows 9-10, 11-12 and 14-15. # company ID FYE reporting date amount 1 330A   31DEC2005   31MAR2006 456 2 330A   31DEC2006   31MAY2007 393 3 330A   31DEC2006   31MAY2007 695 4 350B   31MAY2008   10OCT2008 45 5 350B   31MAY2009   22JUL2009 86 6 350B   31MAY2009   22JUL2009 23334 7 350B   31MAY2009   22JUL2009 866 8 350B   31MAY2010   16OCT2011 299 9 840A   20AUG2011   31DEC2011 3245 10 840A   31OCT2011   31DEC2011 876 11 840A 20AUG2012   31NOV2012 34 12 840A   31OCT2012   31NOV2012 87 13 840A   20AUG2013   30SEP2013 222 14 125N   20JUL2009   28NOV2009 64 15 125N   20SEP2009   18SEP2010 88777 16 125N   20JUL2010   18SEP2010 754 My goal is to ‘clean’ those that have several FYE in the given calendar year leaving only records with the latest FYE. Cases with multiple financial reports for the same FYE should stay as they are. This is what the table should look like after the cleaning: # company ID FYE reporting date amount 1 330A   31DEC2005   31MAR2006 456 2 330A   31DEC2006   31MAY2007 393 3 330A   31DEC2006   31MAY2007 695 4 350B   31MAY2008   10OCT2008 45 5 350B   31MAY2009   22JUL2009 86 6 350B   31MAY2009   22JUL2009 23334 7 350B   31MAY2009   22JUL2009 866 8 350B   31MAY2010   16OCT2011 299 9 840A   31OCT2011   31DEC2011 876 10 840A   31OCT2012   31NOV2012 87 11 840A   20AUG2013   30SEP2013 222 12 125N   20SEP2009   18SEP2010 88777 13 125N   20JUL2010   18SEP2010 754 Can anybody help me please? ... View more