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!
Nearly 200 sessions are now available on demand in the Innovate Hub.
Watch Now →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.