get names

[Aexor]

we have three tables

table1

Fname

RAM

MOHAN

SOHAN

table2

Mname

K

M

table3

LName

deo

ken

zen

;

I want to create a table final , where we can have fname,mnane,lname value.

if mname is missing then fname and lname should print;

e.g

final

RAM K deo

Mohan deo

and so on 

[Reeza]

Cross Joins?

proc sql;
create table want as
select name, mname, lname
from table1, table2, table3
order by 1, 2, 3;
quit;

---

@Aexor wrote:

we have three tables

table1

Fname

RAM

MOHAN

SOHAN

table2

Mname

K

M

table3

LName

deo

ken

zen

;

I want to create a table final , where we can have fname,mnane,lname value.

if mname is missing then fname and lname should print;

e.g

final

RAM K deo

Mohan deo

and so on 

---