I want to generate numbers randomly from a csv table of 40,000 number. I've attached an sample of the table of numbers "sample.csv".   I want to then use the numbers generated to produce 100 iterations of the formula:   iteration(i)  = sum(random number (j)) from j = 1 to x   So, the first cell in the table below will generate 15 numbers from the table sample.csv and then sum them together and output to the cell, the second iteration will do the same but it will be a new set of 15 random numbers from the table sample.csv, and so on.    In the second row, x is 144 so each iteration will sum 144 random numbers from the sample.csv table.   Here is the code to import the csv:   proc import datafile="C:\Users\mbrophy\Downloads\sample.csv" out=mydata dbms=csv replace; getnames=no; run;      ... View more

  Hi,    I am trying to simulate claim amounts and claim numbers over 10,000 simulations. I can figure out how to determine the number of claims but I want to then use that information to simulate the amount of each claim.    The code below simulates the number of claims for 10,000 observations. However, I want to go a step further and to simulate claim amounts for each similation. For example, if the Poisson generates 212 for the first observation I want to produce 212 claim amounts with a lognormal distribution across the columns? My lognormal parameters are mu = 9.1 and shape = 1.5.m    data poisson(keep = x); call streaminit (4321); lambda = 212; do i = 1 to 10000; x = rand("Poisson",lambda); output; end; run;   The resulting dataset would be a 10000 rows by approximately 300 colums.   I would also like to impose caps on the severity but I think I can do this.    Thanks ... View more

I've got a dataset with 100s of companies and historic prices. The data is sorted by company and date (descending order).   I want to calculate a couple of variables and I was hoping to get some guidance on the best functions to use:   Average price in the last 5/10/x periods (but I don't want to overlap with the previous company's data).  Price change in the last 5/10/x periods. Again, there won't be any data for this in the first 4 periods of data FOR EACH company Future price change i.e. the price in 5 periods time/price (this period)   I've attached an extract from the data with Company A and Company B as an example and I've highlighted in grey the columns where I'm trying to calculate the above metrics.    I'm pretty sure I can use lag for the price change but not sure about the average or the future price. Also, not sure how I would go about starting the calculation for each new company i.e. Company A and Company B in the attached   Thanks  ... View more