Hi again! I need to export my data to an excel file. So far I get perfectly exported my six column names from my variable names and the actual data. Now the problem is that the column names need to be on the second row of the sheet (A2, B2, C2, D2, E2, F2), and they need to have two title texts, for example Maintitle1 at merged cells A1:C1, and Maintitle2 at merged cells D1:F1.   So the desired output would be:             A          B          C          D          E          F 1     [  M  a  i  n  t  i  t  l  e  1 ][  M  a  i  n  t  i  t  l  e  2  ] 2        var1       var2       var3       var4       var5       var6 3         1          6          3          2          7          0 4         0          2          5          8          9          2 5         4          6          0          1          5          8 6        etc..      etc..      etc..      etc..      etc..      etc..        Where the actual data that's exported starts at row three. Is there a way to achieve this directly from ODS EXCEL? Thank you so much already in advance! Edit: The logic should be something like using a TITLE1, but having two title1s with specified excel cells to be merged. Normally the title1 does a merge spanning across all the columns, in this case it would do a title at merged cells A1:F1. Somehow just need to divide this to two titles. Maybe some kind of groups assigned to the variables, the logic would go somewhat like group1=var1-var3 and group2=var4-var6; title1(group1)=maintitle1; title1(group2)=maintitle2; ... View more

Hi everybody! Suppose I have three tables named TABLE1, CODES1 and CODES:   ---------------------------------------------------- TABLE1 name, category_broad, category_exact BANANA, 1 (foods), 101 (fruits) APPLE, 1 (foods), 101 (fruits) CAR, 2 (things), 201 (cars) HOUSE, 2 (things), 202 (houses) BALL, 2 (things), 203 (balls) BREAD, 1 (foods), 102 (breads) ---------------------------- CODES1 category_broad, code 1 (foods), 34 2 (things), 35 ---------------------------- CODES2 category_exact, code 101 (fruits), 463 102 (breads), 464 202 (houses), 564 203 (balls), 565 ----------------------------------------------------   What I would like to achieve is two merges: -first merge where if the category_broad from codes1 matches with category_broad from table1, then the code is added to the row that matched, and only matched rows are included. -second merge where if the category_exact from codes2 matches with category_exact from table1, then the code is added to the row that matched, and only matched rows are included. So for example the row with "car" would be left out from the merge with codes2 table. So the desired resulting tables would be: TABLE1xCODES1 name, category_broad, category_exact, code BANANA, 1 (foods), 101 (fruits), 34 APPLE, 1 (foods), 101 (fruits), 34 CAR, 2 (things), 201 (cars), 35 HOUSE, 2 (things), 202 (houses), 35 BALL, 2 (things), 203 (balls), 35 BREAD, 1 (foods), 102 (breads), 34 TABLE1xCODES2 name, category_broad, category_exact, code BANANA, 1 (foods), 101 (fruits), 463 APPLE, 1 (foods), 101 (fruits), 463 HOUSE, 2 (things), 202 (houses), 564 BALL, 2 (things), 203 (balls), 565 BREAD, 1 (foods), 102 (breads), 464 I know this should not be too difficult but I am having trouble in achieving this. Regarding the second merge, I have so far tried using this: ------------------------------------- proc sort data=table1; by category_exact; run;   proc sort data=codes2; by category_exact; run;   data merged; merge table1 codes2; by category_exact; run; ------------------------------------------- The problem with this approach is that it brings to the resulting table also the row that did not match, which is the CAR row. And in that row, the value for column "code" is missing. This is something I don't understand regarding the 'merge by' option in SAS, since the by-variable did not match there. What is the correct way to solve this? Thank you so much in advance! 🙂 ... View more