06-02-2017 04:14 AM
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?
06-02-2017 04:20 AM
Is period a date variable? If so you wouldn't split it (which is for character strings) but rather extract the various parts using year() or month() functions. E.g.:
data want; set have; yr=year(period); mnth=month(period); run;
06-02-2017 04:51 AM
@RW9 Period is formated as charachter string and revenue in number format. :/
First I assumed that it would be better to use the "Transpose function"? But as i understood it, the transpose function is preferably used in the opposite way, whenever you would like to transpose a column into a row? It feels like i'm swimming in the deep water over here haha.
06-02-2017 05:28 AM
All I can think is that with the extra variables its grouping the data differently. Sorry, I don't use EG so can't be further help as I only use code. Transpose can be used either way, normalised to transposed and vice versa. If you have multiple variables or different types then arrays can be more effective.