Hi,   I've 2 datasets which has 6 columns in 1 dataset & another has 8 columns. But first 5 columns are same in both. Say first dataset name is A and another B. I want to merge the 2 dataset such that I get 9 total columns. Generally we merge using SQL in the following way:     proc sql; create table example as select a.*,b.var1,b.var2,b.var3 from A as a left join B as b on a.key1 = b.key1 and a.key2 = b.key2 and a.key3 = b.key3 and a.key4 = b.key4 and a.key5 = b.key5; quit; And if I need to merge the table again and again, I've to repeatedly write the 5 keys again and again.   My question is, is there any way I can pass the key in macro and call the macro while merging?    Thanks! ... View more

Hi,   We are using SAS Eminer for our machine learning project. But one part of it's is mixed integer optimization. I want to know if any method (or proc step) can be used for mixed integer optimization in SAS Eminer?   Thanks! ... View more

My data is in this format: data have; input GROUP1 GROUP2 GROUP3 VAR1 VAR2; cards; A A1 A11 10 12 A A1 A11 13 . A A1 A12 15 16 A A2 A12 . 17 A A2 A13 12 12 A A2 A13 19 18 B B1 B11 15 21 B B1 B11 22 29 B B1 B12 31 40 B B2 B12 . . B B2 B13 5 3 B B2 B13 . . ; RUN; And I want the result in this format: data desired; input GROUP1 GROUP2 GROUP3 VAR1 VAR2; cards; A A1 A11 10 12 A A1 A11 13 12 A A1 A12 15 16 A A2 A12 15 17 A A2 A13 12 12 A A2 A13 19 18 B B1 B11 15 21 B B1 B11 22 29 B B1 B12 31 40 B B2 B12 31 31 B B2 B13 5 3 B B2 B13 5 3 ; RUN; I want to impute the missing values by replicating the previous value from the same above group. E.g. for group combinations (B, B2, B13), there's a missing value for variable "Value2". This value will be replicated with 20, which is the above value from the same group. I tried to follow this option. But this does not have multiple value computation option. data imputedData; set mydata; n=_n_; if missing(Value1) then do; do until (not missing(value1)); n=n-1; set mydata(keep=Value1) point=n; *second SET statement; end; end; run; But the problem is it can calculate only 1 variable at a time. And also it was taking a long time to compute. My dataset is around 400K number of rows. If someone please guide me how to do it. Thanks! ... View more