Hi, I am trying to run a macro with the following input and it works perfect. %medc(pdrug=drp1|drp2|drp3|drrp4, dset=data1);   But, if any special characters in the input such as the following, the macro doesnt work.   %medc(pdrug=drp1 w/drp5|drp2|drp3 w/drp5/drp6/drp7|drp4, dset=data1);   Any idea to let the macro recognise these special characters?   Thanks   ... View more

Hi all,   I have two datsets (data1 and data2)  to append based on time interval.  data1 ID T D E 200 0 15 0 200 0 0 4 200 0.021 27.1 0 200 0.033 74.9 0 200 0.052 142 0 200 0.094 191 0 200 0.18 197 0 200 0.346 242 0 200 0.51 350 0 200 1.015 442 0 200 2.015 555 0 200 3.01 593 0 200 4.013 540 0 200 5.016 425 0 200 6.016 460 0 200 7.02 610 0 200 9 514 0 200 10.001 466 0 200 11.007 503 0 200 12.014 415 0 200 13.024 458 0 200 14.017 448 0 200 28.035 44.7 0 200 56.02 366 0 200 88.033 278 0 200 120.026 247 0 200 215.973 228 0 200 246.013 186 0 200 276.978 251 0 200 306.206 210 0 200 334.98 190 0 200 365.073 183 0 200 393.094 179 0 200 425.052 217 0 200 456.056 180 0 200 484.043 290 0 200 522.051 317 0 200 550.059 201 0 200 582.078 339 0 200 600.007 203 0 200 600.045 256 0 200 600.068 266 0 200 600.108 183 0 200 600.191 186 0 200 600.358 146 0 200 601.181 81.2 0 200 602.106 65 0 200 603.073 31.5 0 200 604.075 23.2 0 300 0 15.5 0 300 0 0 4 300 0.014 23.9 0 300 0.024 28 0 300 0.035 25.5 0 300 0.045 13.7 0 300 0.094 28.1 0 300 0.17 44.4 0 300 0.337 194 0 300 0.503 336 0 300 1.006 377 0 300 2.008 598 0 300 3 565 0 300 4.049 678 0 300 4.999 639 0 300 6.001 546 0 300 7.274 553 0 300 8.003 641 0 300 9.045 491 0 300 10.122 435 0 300 11.003 415 0 300 12.006 318 0 300 12.997 356 0 300 14.012 331 0 300 28.01 680 0 300 56.008 251 0 300 84.01 228 0 300 116.002 243 0 300 210.965 180 0 300 242.013 152 0 300 273.01 209 0 300 301.009 186 0 300 336.006 175 0 300 368.069 152 0 300 396.027 152 0 300 427.01 135 0 300 459.072 130 0 300 486.017 144 0 300 518.316 193 0 300 557.281 172 0 300 597.971 157 0 300 618.969 138 0 300 646.967 152 0 300 667.969 136 0 300 721.878 115 0 300 757.016 126 0 300 757.073 181 0 300 757.094 157 0 300 757.135 165 0 300 757.219 174 0 300 757.385 182 0 300 758.274 127 0 300 759.326 83.4 0 300 760.078 57.8 0 300 761.014 33 0   data2 ID Period T BSE BSS FRI SPE 200 1 0-90 4.5 7 27.33 4.5 200 1.5 21-110 6 8 27.33 5 200 2 91-180 4.5 9 25 7   Output dataset needed is data3 ID T D E         200 0 15 0 NA NA NA NA 200 0 0 4 NA NA NA NA 200 0.021 27.1 0 NA NA NA NA 200 0.033 74.9 0 NA NA NA NA 200 0.052 142 0 NA NA NA NA 200 0.094 191 0 NA NA NA NA 200 0.18 197 0 NA NA NA NA 200 0.346 242 0 NA NA NA NA 200 0.51 350 0 NA NA NA NA 200 1.015 442 0 NA NA NA NA 200 2.015 555 0 NA NA NA NA 200 3.01 593 0 NA NA NA NA 200 4.013 540 0 NA NA NA NA 200 5.016 425 0 NA NA NA NA 200 6.016 460 0 NA NA NA NA 200 7.02 610 0 NA NA NA NA 200 9 514 0 NA NA NA NA 200 10.001 466 0 NA NA NA NA 200 11.007 503 0 NA NA NA NA 200 12.014 415 0 NA NA NA NA 200 13.024 458 0 NA NA NA NA 200 14.017 448 0 NA NA NA NA 200 28.035 44.7 0 NA NA NA NA 200 56.02 366 0 NA NA NA NA 200 88.033 278 0 NA NA NA NA         200 BSE 4.5 5         200 BSS 7 6         200 FRI 27.33 7         200 SPE 4.5 8   Basically, append needs to be done (after transposing data2) as shown above and the T variable (time interval) to be used for append. The highest value for E in data1 is 4 and E value should be incremented starting with value 5 in output dataset when its populated with a row from data2. ID is the subject ID and T is the time variable. ID and Time are the matching variables. Any help to get this output? Thanks in advance. ... View more