how to get the required column in SAS dataset to Excel

Reply
Occasional Contributor
Posts: 15

how to get the required column in SAS dataset to Excel

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

Super User
Posts: 5,260

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

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.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 181 views
  • 3 likes
  • 2 in conversation