Append few columns in another table

Swapnil_21 — Sat, 12 Feb 2022 05:01:37 GMT

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

Re: Append few columns in another table

Ksharp — Sat, 12 Feb 2022 07:00:57 GMT

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;

topic Re: Append few columns in another table in SAS Programming

Append few columns in another table

Re: Append few columns in another table