Append few columns in another table

[Swapnil_21]

I have one dataset Have as below 

ACCOUNT_ID	APPL_LOAN_PCT_GROSS_INC	APPL_LVR	CUSTOMER_ID	APPLICATION_ID	BASEL_RETAIL_CORP_CODE	BROKER_FLG
RAM3000007	1.538430769	0.6667	400001700	400001700	CONS	N
RAM3000015	4.2922	0.7368	400004000	400004000	CONS	N
RAM3000023	4.2922	0.7368	400004000	400004001	CONS	N

Now I want to append the values of ACCOUNT_ID,CUSTOMER_ID and APPLICATION_ID in another 

dataset  called as lookup which should have all these values one below other with only one column

Target table show look like as below 

Lookup Values
RAM3000007
RAM3000015
RAM3000023
400001700
400004000
400004000
400001700
400004000
400004001

I am trying a lot but could not find the solution. Any help is really appreciated

[Ksharp · Accepted solution]

data want;
set have(keep=ACCOUNT_ID rename=(ACCOUNT_ID = LookUp))
have(keep=CUSTOMER_ID rename=(CUSTOMER_ID = LookUp))
have(keep=APPLICATION_ID rename=(APPLICATION_ID = LookUp)) ;
run;