CODEWITHSUNDEEP
sas
Malaka Thilakaratne
Malaka Thilakaratne

Reputation: 31

Output values to excel in sas

Can some one please help me to output the data generated from the following code(yt) to an excel data set?

proc iml;

d = 0.4;

call farmasim(yt, d) n=10 sigma=2 seed=123457;

print yt;

run;

Upvotes: 1

Views: 234

Answers (1)

Joe
Joe

Reputation: 63424

ods tagsets.excelxp file="myfile.xml";
proc iml ... etc. ... quit;
ods tagsets.excelxp close;

For more info google "tagsets.excelxp" or see http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

Alternately, you can move yt into a dataset, and use PROC EXPORT, either to EXCEL if you have ACCESS to PC FILES licensed, or to CSV if not.

Upvotes: 1

Related Questions