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!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.