get names

Aexor — Mon, 17 May 2021 17:57:06 GMT

we have three tables

table1

Fname

RAM

MOHAN

SOHAN

table2

Mname

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

Re: get names

Reeza — Mon, 17 May 2021 18:14:41 GMT

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

topic Re: get names in SAS Programming

get names

Re: get names