Hi all,   Need some help regarding matrices in SAS. I've got two datasets (large ones) from which I'd like to create matrices and do some calculations. The formula I'm trying to apply is x'(X'X)^-1x. X and x would be two matrices from two datasets. So far I've got the code below but it's incomplete and can't figure out the rest. proc iml; use matrix; read all var {mktcap cash vol price} into X; Xtranspose = X`; XtransX = X*X`; print X Xtranspose XtransX; Any help regarding how to calculate that will be very much appreciated 🙂      ... View more

Hi everyone,   I've got a tricky one here (at least for me).I'd like to get a matrix that tells me how many staff members schools share For example, I start from:   Staff ID         School ID 1                         50 2                         50 3                         80 4                         80 4                        100 5                         50 5                        100   Note that staff 4 and 5 is in two different schools. So in summary:   School_Staff    50 - 1, 2, 5    80 - 3, 4  100 - 4, 5   And ideally, the matrix I'd like to get is this:              50       80     100 50        3         0        1 80        0         2        1    100      1         1        2   Maybe I'll need to use proc iml? But that confuses a bit   Thanks a lot for your help! 🙂 Let me know if you need more info.      ... View more

Hi everyone,    I need help please with turning observations into variables. Here's an example of what I have   ID                   Date                     Event Date                Return 101           01/01/2020                01/01/2020                 0.02 101           02/01/2020                01/01/2020                 0.0015 101           03/01/2020                01/01/2020                 0.001 102           01/01/2020                01/01/2020                 0.0222 102           02/01/2020                01/01/2020                 0.001 102           03/01/2020                01/01/2020                 0.0015 103           01/01/2020                01/01/2020                 0.003 103           02/01/2020                01/01/2020                 0.03 103           03/01/2020                01/01/2020                 0.035   And here's what I want:    Date                           Event date            101         102             103 01/01/2020                01/01/2020           0.02        0.0222         0.003 02/01/2020                01/01/2020         0.0015       0.001          0.03 03/01/2020                01/01/2020         0.001        0.0015         0.035   Hope that makes sense and thank you in advance for your help! ... View more