Thx a lot, worked perfect. The only problem I had was that I needed to format dates in Excel as number and than subtract 21916 to form it into a SAS Date.
Thank Youu
One possible Solution for me would be, that I Isolate EVENT2 and generate additional dates for it via a loop function. Then I Will merge it back with EVENT1 data. However I couldn't manage too.
Step 1
ID DATE EVENT2
1 16.10.2003 YES
1 17.02.2004 YES
1 16.05.2005 YES
2 16.10.2003 YES
2...
Hallo all together,
I have a short question. It would be great if someone could help me.
My data looks a follows. I have some events happening on a specific date in Time for several IDs. Now I want to find out if EVENT2 happens in an specific time frame of EVENT1 e.g. Minus 5 days, plus 5 Days...
Hello all together,
i am pretty new to SAS and have a small question.
I want do import a File which is available either in csv, txt or excel. The Variables are Date ID Price. I have several observations per line. and want I want to create a SAS file with only 3 variable. Can somebody help me...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.