I have this dataset with. Some IDs are missing values for window=0 data ds1; input ID$ window m1 m2 m3; datalines; 1 3 157 56 111 1 6 145 35 145 1 9 178 78 200 2 0 132 27 201 2 6 124 95 211 2 12 127 37 532 2 15 178 35 465 3 6 148 74 231 3 12 138 49 532 ; run; The dataset that should be used to complement data when window=0 is missing is this: data ds2; input ID$ window m1 m2 m3; datalines; 1 0 145 54 201 2 0 143 45 143 3 0 132 47 165 4 0 131 48 253 9 0 124 52 511 ; run; We need to replace missing window=0 from ds1 with values from ds2. Note that data should be added only when window=0 is missing from ds1. See the desired output below for ID 2, it keeps the data from window=0 from ds1. How can we get the below dataset? ID window m1 m2 m3 1 0 145 54 201 1 3 157 56 111 1 6 145 35 145 1 9 178 78 200 2 0 132 27 201 2 6 124 95 211 2 12 127 37 532 2 15 178 35 465 3 0 132 47 165 3 6 148 74 231 3 12 138 49 532 4 0 131 48 253 9 0 124 52 511 ... View more

I have this output: mean min_max median group 32 1-40 35 Chef/owner 33 2-45 31 Chef's assistant 31 4-39 28 Waiter   With proc transpose I get this: _NAME_ COL1 COL2 COL3 mean 32 33 31 min_max 1-40 2-45 4-39 median 35 31 28 I would like rename the COL1, COL2, COL3 in the same procedure so it can look like this: _NAME_ Chef/owner Chef's assistant Waiter mean 32 33 31 min_max 1-40 2-45 4-39 median 35 31 28 I need the output to look like this since this will be used in a macro. I want to avoid renaming each col with a specific name since this macro will also be used for other grouping variable (other that chef/owner, chef´s assistant and waiter). Thanks! ... View more

Hello,   I cannot find the unicode for the symbol §. Does anyone know what is the unicode? ... View more