data a; input m p c; cards; 102 113 114 102 124 134 103 114 115 103 124 135 104 115 116 104 125 136 run; data b; input m p c; cards; 102 103 104 103 104 105 104 105 106 run; data e1; merge a b; by m; run; proc print data=e; run; OUTPUT: Obs m p c 1 102 103 104 2 102 124 134 3 103 104 105 4 103 124 135 5 104 105 106 6 104 125 136   data a; input m p c; cards; 102 103 104 103 104 105 104 105 106 run; data b; input m p c ; cards; 102 113 114 102 103 104 102 124 134 103 114 115 103 104 105 103 124 135 104 115 116 104 105 106 104 125 136 run; data e2; merge a b; by m; run; proc print data=e; run; OUTPUT: Obs m p c 1 102 113 114 2 102 103 104 3 102 124 134 4 103 114 115 5 103 104 105 6 103 124 135 7 104 115 116 8 104 105 106 9 104 125 136 Data A; Input ID Name$ Height; cards; 1 A 1 3 B 2 5 C 2 7 D 2 9 E 2 ; run; Data B; Input ID Name$ Weight; cards; 2 A 2 4 B 3 5 C 4 7 D 5 ; run; Data dummy; Merge A B; by ID; run; proc print data = dummy; run; OUTPUT: Obs ID Name Height Weight 1 1 A 1 . 2 2 A . 2 3 3 B 2 . 4 4 B . 3 5 5 C 2 4 6 7 D 2 5 7 9 E 2 .   I have used a simple merge condition in all the 3 codes, but very confused after seeing the ouput.. Can anyone please clarify my confusion? ... View more

I have a dataset:   id name dm value 101 weight ds 50 101 weight ds 55 101 weight ds 54 101 weight ds 49.8 101 weight ds 53   i need to output: id dm weight 101 ds 50 101 ds 55 101 ds 54 101 ds 49.8 101 ds 53     using proc transpose how can i do it? ... View more

  Hpw do I do this?? Please someone help me   Table A1 : Conisit of 10 columns and there are 100 records create a TABLE B1 from A1 where B1 should contain only the structure of A1 and no records should be copied.   Thank you ... View more