Need help using SAS procedures to change the data
Here is what my old data looks like
Symbol Date Bucketno Turnover
APX 20140503 22 .005
APX 20140503 23 .023
APX 20140504 17 .021
APX 20140504 21 .025
APX 20140504 24 .38
MMM 20140501 22 .06
MMM 20140501 23 .09
It has buckets variable called “bucketno” that goes from 1-24.
I would like this to be converted into a variable bucket_1 Bucket_2 Etc to Bucket_24. No Bucketno variable in final
There should be one day per row.
The values in the dataset should be Turnover, so there will be no Turnover variable in the final.
This is sorted by Symbol and Date.
I am able to do this using PivotTables in Excel. I have attacked a picture of the final result that I am trying to replicate.
How can i do this using SAS code?
Thank you
... View more