ok Patrick, thanks. Sorry but i verified and applied the Code, i think Maybe you have forgotten to calculate the Volatility. If i have very well unterstood the Code you have assigned at a new colomn the Name Volatility but when i checked the numeric data, they are remained unchanged. can't you please checked this? thanks you in Advance.
I thought you've calculated the volatility already and now need just the ranking.
What you're doing here is not really in my area of expertise so I suggest you split up your problem and then ask new questions one step at a time.
I'd start with the transformed data structure (giving the Volatility column the appropriate name) and describe the logic you require to get from the "have" data to a column containing the volatility.
thanks for your Proposition Patrick. and many thanks for your help!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.