how to get the required column in SAS dataset to Excel

padmakumariMiriyala — Sat, 07 Feb 2015 08:07:32 GMT

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......

Re: how to get the required column in SAS dataset to Excel

LinusH — Sat, 07 Feb 2015 09:31:10 GMT

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.