Hi everybody   I am always confuse with IN option. We use IN option in MERGE. How idoes it works?  What's going internally if we mention IN?   data x; merge dsn1(in=a) dsn2(in=b); by var; run;   what happens if we give if a=1 or b=0                                     a=1 and  b=1                                     b=0 or b=0                                      a=0 and b=0 .................................................................     Can anybody help me to understand this concept?   Thanks in advance Regards Rawindarreddy ... View more

how can we write a code i need to create a macro variables with each observation into one macro variable.Can you help me to write a code using PROC SQL eno ename sal 1 a 1000 2 b 2000 3 c 3000 .............. i need to assign first observation in to m1                         2nd obs into m2                         3rd obs into m3 ................................................ Thanks in advance regards Rawindarreddy ... View more