Hello, I have an Excel spreadsheet with 17 rows of data. The first column is YEAR, the second column is a continuous value from 0 to 4.29, called RawRate. That's the data. I have run a bootstrapping simulation with 10,000 replications, then a Proc Means to characterise the distribution of the simulated means. This all works, here is the output: The MEANS Procedure (Lower 95%, Upper 95%, Mean, StdDev, Min, Max, n) 1.9854599 1.9982321 1.9918460 1.3434024 0 4.2900000 170000 What I have been struggling with is that I would like to export the 10,000 simulated means to an Excel file. I have tried a DM function but it's not working, it just exports two columns; the first is the number of each iteration and the second is from 1 to 17, 10,000 times. Here is the code - how can I export the simulated means please? data ; do sampnum = 1 to 10000; /* To create 10000 bootstrap replications */ do i = 1 to 17; /* Want same no. obs as in ORIGINAL */ x = round(ranuni(0) * 17); /* x randomly selected from values 1 to NOBS */ set YearRate nobs = nobs point = x; /* This selected the xth observation in ORIGINAL */ output; /* Send the selected observation to the new data set */ end; end; stop; /* Required when using the POINT= command */ run; proc means CLM mean stddev min max n; var RawRate; run;
... View more
