Hello all,     I have a 2 part question.   The first part is that I want my testdata to be split into different datasets based on the order field. I can do this statically by writing something like this:   data testdata; infile datalines dsd truncover; input ordernum:$3. order:1. code:$3. ; datalines; 111, 1, qwe 111, 2, gfd 111, 3, sdf 222, 1, erw 222, 2, fgh 333, 1, saa 333, 2, ath 333, 3, gdw 444, 1, etg 444, 2, hef 444, 3, sfy 444, 4, hrl 555, 1, mmj 555, 2, bhg 555, 3, dgy 555, 4, ggd 555, 5, dss ;;; data ordernum1 ordernum2 ordernum3 ordernum4 ordernum5; set testdata; if Order = 1 then output ordernum1; if Order = 2 then output ordernum2; if Order = 3 then output ordernum3; if Order = 4 then output ordernum4; if Order = 5 then output ordernum5; run;   However, with this approach I can't be assured that there will always only be a total of 5 orders; there could be any number.     I'm having trouble getting a macro working and was looking for some additional eyes. This may not even be the best way to do this but I appreciate any input.       proc sql noprint; select max(Order) into : order_num from testdata; quit; %put Max Count = &order_num; options mlogic mprint; %macro split; data %do i = 1 %to &order_num; ordernum&i %end; ; set test_Data; select(Order); %do i = 1 %to &order_num; when Order = &i then output ordernum&i; %end; otherwise; end; run; %mend split; %split;   And lastly, I have a master table of ordernums I want to join these separated datasets back to. How do I approach writing the join logic dynamically? For example, I could do this manually if I knwo the number of tables the testdata will be split into by writing something like this:  proc sql; create table New_Table as select a.*, b.code as code1, c.code as code2, d.code as code3, e.code as code4, f.code as code5 from master a left join ordernum1 b on a.ordernum = b.ordernum left join ordernum2 c on a.ordernum = c.ordernum left join ordernum3 d on a.ordernum = d.ordernum left join ordernum4 e on a.ordernum = e.ordernum left join ordernum5 f on a.ordernum = f.ordernum ; quit; However, if I don't know how many datasets will be created how can I include this join logic into the macro?   As always, appreciate any assistance. Thanks!   ... View more

Is there a non DDE option to hide an excel worksheet after data is exported to an excel file?   I am exporting data via proc append and despite my best efforts everytime I open the workbook after successfully exporting the data, the sheet I want to remain hidden is always visible. I've tried setting it to very hidden in the VBA editor but that doesnt work; when ever I export data to the file it unhides the sheet.   Any tips/suggestions are appreciated. Thanks.  ... View more