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

Hello!   I'm kind new on hash usage and I was wondering if there is a way to perform a left join with hash without having to load the big table into hash instead the small one. I have been reading multiple papers and articles about this but I haven't been able to came up with an idea of how this could be performed.   This is the code I have by now:   data a ; input key adata ; cards ; 1 1 2 2 3 3 4 4 5 5 6 6 7 7 ; run ; data b ; input key bdata ; cards ; 1 11 1 12 3 31 4 4 6 61 6 62 6 63 7 7 ; run ; data c ; if _n_ = 1 then do ; if 0 then set b ; dcl hash b (dataset: "b", multidata: "y") ; b.definekey ("key") ; b.definedata ("bdata") ; b.definedone () ; end ; set a ; iorc = b.find() ; if iorc ne 0 then call missing (bdata) ; output ; do while (b.find_next() = 0) ; output ; end ; run ; Both of the sample datasets are small here, but I was thinking in an scenario where big table is really big, so I can't load it into memory.   Any suggestion? Thanks guys! ... View more

Hello,   I would like to know if there is any downside on keeping EG opened (with the same session) for many days. We used to have SAS 9.3 and because of network configuration, the inactive sessions were disconnected after a couple hours because of a timeout on the connection. Recently we moved to SAS 9.4 and I configured the keep alive option to avoid that problem. But now I see that the users are keeping their EG opened for many days. Is there any possible problem that they could experience with this way of working?     ... View more