On 12月4日, 下午9时15分, js8...@GOOGLEMAIL.COM (js8765) wrote: > Hi there, > > It would be helpful to know what exactly you mean by "does not work". > What errors are you getting in the log, or is the output not as you wanted? > > Anyway, if you are merging two data sets where only some of the values > match, then the following code should help: > > select coalesce(a.id, b.id) as ID, col1, col2, ... > � � from a > � � � � full join > � � b > � � on a.id = b.id > � � order by id; > > js > > By the way, join is spelt "join" not "jion", maybe that's why it's not > working... > > > > siyuan li wrote: > > hi,all, > > � here has two data sets a and b. they have a varible which is id, > > � I have the code like that: > > � data merge1; > > � merge a b; > > � by id; > > � run; > > � the problem is I want to use the proc sql language to achieve the > > result that like the merge language . > > I try to write that: > > � � proc sql; > > � � select * from a full jion b > > � � on a.id=b.id; > > � � quit; > > but it does not work.can someone help me.- 隐藏被引用文字 - > > - 显示引用的文字 -

sorry, I am a Chinese student,so my english is poor. it does not work means the output is not as i want. I want the same output like the merge language.