Hi, I am a new user in SAS and i have encountered a problem that I need help to solve. I have an issue when using the split column function in SAS EG. I have a Data-set with the following example columns: User_ID Segment Product Period Revenue 12345 Retail Shoes 2016-02 500 I would like to use the split function in order to get the period spltted into several new columns for each month of the year, instead rows. Somehow, when I perform the split column task, it adds about 20% to the total revenue. Before making the split I have used the sum function for the revenue. Can someone please tell me what I am doing wrong here? 🙂
... View more