Hi All, I am still somewhat new to SAS (last year) and haven't used it in a while. Can someone please help with using either Proc sql or other data/Proc steps that come to mind to get me started in answering the following: 1. 3, 6, 12month, 1 year, 2 year: - mean Stock returns by company - Standard deviations for these time horizons. 2. Create a new data set for 1 and merge that with original data set by company name only. 3. Employ do loops (if/then?) or macros to create another dataset with the same calculations for 1 and 2 above? The aim is for me to understand how you're using do loops or macros for increased efficiency in future tasks like this. i have attached the CSV file. Any input is appreciated including how you loaded the data (data step with lib reference or Proc import?) thank you.
... View more