Activity 7.02 *;
* 1) Complete the SQL query to display Event and Cost *;
* from PG1.STORM_DAMAGE. Format the values of Cost. *;
* 2) Add a new column named Season that extracts the *;
* year from Date. *;
* 3) Add a WHERE clause to return rows where Cost is *;
* greater than 25 billion. *;
* 4) Add an ORDER BY clause to arrange rows by *;
* descending Cost. Which storm had the highest *;
* cost?
Can someone assist ? How do I format the value of Cost to Billions ?
Thank you
It doesnt specify. 3B?
I think that they would want us to use available formats.
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!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.