data test; input id cc_age cc_amt PL_age PL_amt Mort_age Mort_amt bank_age bank_amt; cards; 001 2 1000 . . 8 1600 11 300 001 12 1000 6 3000 . . 6 1300 001 . . 3 4000 . . 4 2430 001 7 900 . . 2 2999 . . 002 5 4000 9 5000 11 2000 . . 002 . . 4 1500 . . 8 990 002 9 900 . . 7 890 10 2600 ; run; data trans; set test; length Type $ 5; type='CC'; age=cc_age; amt=cc_amt;output; type='PL'; age=PL_age; amt=PL_amt;output; type='MORT'; age=MORT_age; amt=MORT_amt;output; type='BANK'; age=BANK_age; amt=BANK_amt;output; keep id type age amt; run; /* report for people to read*/ proc tabulate data=trans; class id type; var age amt; table id, type=''*(Age Amt)*min=*f=best5. /misstext=' '; run; /* data set for further manipulation*/ proc summary data=trans nway; class id type; var age amt; output out=want (drop= _:) min=; run; ... View more

data test; input id cc_age cc_amt PL_age PL_amt Mort_age Mort_amt bank_age bank_amt; cards; 001 2 1000 . . 8 1600 11 300 001 12 1000 6 3000 . . 6 1300 001 . . 3 4000 . . 4 2430 001 7 900 . . 2 2999 . . 002 5 4000 9 5000 11 2000 . . 002 . . 4 1500 . . 8 990 002 9 900 . . 7 890 10 2600 ; run; data trans; set test; length Type $ 5; type='CC'; age=cc_age; amt=cc_amt;output; type='PL'; age=PL_age; amt=PL_amt;output; type='MORT'; age=MORT_age; amt=MORT_amt;output; type='BANK'; age=BANK_age; amt=BANK_amt;output; keep id type age amt; run; /* report for people to read*/ proc tabulate data=trans; class id type; var age amt; table id, type=''*(Age Amt)*min=*f=best5. /misstext=' '; run; /* data set for further manipulation*/ proc summary data=trans nway; class id type; var age amt; output out=want (drop= _:) min=; run; ... View more

Thanks KurtBremser for your solution. I'm using sashelp.vmacro to save the global variable to permenant library and assigning back the global variable in the submodule code. The below solutions is working fine.     Main Module:   /* Global variables */ %global country application_date include_section_personal ; %let country = AU; %let application_date = today()-60;   libname append "F:\SAS Data"; %PUT _GLOBAL_; /* Save Globale variables into Append library */ data Append.vars; set sashelp.vmacro(where=(scope='GLOBAL')); run;   Submodule (Personal): libname append "F:\SAS Data"; /* Place the macro variable(s) back into the GLOBAL symbol table from Append library */ data _null_; set append.vars(where=(scope='GLOBAL')); if substr(name,1,3) ne 'SYS' then do; call execute('%global '||strip(name)||';'); call execute('%let '||strip(name)||'='||strip(value)||';'); end; run;   Thanks for all your help! ... View more