how to get the required column in SAS dataset to Excel

[padmakumariMiriyala]

For example I Have two SAS datasets like

data ds;

infile datalines;

input id;

datalines;

101

102

103;

run;

data ds_1;

infile datalines;

input  id Amount$ ;

datalines

101 10000

103   50000

104   70000;

run;

one Excel file is there ,some information already in excel like

Amt

70000

50000

20000

30000

70000

20000

and how to mapping the id values......

[LinusH]

Not sure exactly what you want. But import the Excel file to SAS, do a three way  SQL join, and export the results back to Excel.