Hello guys,
I'm kinda stuck here, hoping someone can give me some light...
I have a column with a string that represents status on transactions on a certain period (monthly), something like this:
data test;
input status $50.;
datalines;
02010103
01020301
;
run;
Each period is two characters lenght, then I have to split the string onto multiple columns, and repeat those columns 4 times so I have weeks instead of months) something like this:
w1 w2 w3 w4 w5 w6.....
--------------------------------
02 02 02 02 01 01 ...
01 01 01 01 02 02 ....
This is causing me a headache, because I can think in a way to split, but no way to make columns names be in order. Any idea?
... View more