About RandyStan

RandyStan · ‎09-16-2019

Here goes. Thanx. Date VarA VarB VarA_BF VarB_BF 6/20/2019 1 6/20/2019 1 6/20/2019 1 6/20/2019 1 6/21/2019 1 1 6/21/2019 1 1 6/21/2019 1 1 6/22/2019 1 1 1 6/22/2019 1 1 1 6/22/2019 1 1 1 6/22/2019 1 1 1 6/23/2019 1 1 1 6/23/2019 1 1 1 6/23/2019 1 1 1 6/24/2019 1 1 6/24/2019 1 1 6/24/2019 1 1 6/24/2019 1 1 6/26/2019 1 6/26/2019 1 6/27/2019 6/27/2019 6/27/2019 6/28/2019

RandyStan · ‎09-16-2019

The dates are NOT continuous. Sorry for not making it clear. Using the Lag function does not work, as the dates are repeated in the data set. Thanx so much. @novinosrin wrote: Are your dates continuous or not? 25th is missing, otherwise it seems continuous???

RandyStan · ‎09-16-2019

Dear All: I have flags for certain dates. I want to construct two variables, for VarA and VarB, called VarA_BF and VarB_BF, that are lagged two days from the date of the flag and two days forward from the flag date. Thanx in advance My Data is as Follows Date VarA VarB VarA_BF VarB_BF 06/20/2019 1 06/20/2019 1 06/20/2019 1 06/20/2019 1 06/21/2019 1 1 06/21/2019 1 1 06/21/2019 1 1 06/22/2019 1 1 1 06/22/2019 1 1 1 06/22/2019 1 1 1 06/22/2019 1 1 1 06/23/2019 1 1 1 06/23/2019 1 1 1 06/23/2019 1 1 1 06/24/2019 1 1 06/24/2019 1 1 06/24/2019 1 1 06/24/2019 1 1 06/26/2019 1 06/26/2019 1 06/27/2019 06/27/2019 06/27/2019 06/28/2019

RandyStan · ‎04-25-2019

Dear Astounding: If you need any clarification about the question, please do ask. What I need is that the MAX p from the second file when the ID is inactive (and then merged back into the original file). Thanx a lot. Randy @Astounding wrote: There is much about your post that is either incomplete or wrong. So here is a guess that should be close to what you want: data want; set have; by id; retain maxval; drop maxval; if first.id then maxval=p; else do; maxval = max(maxval, p) ; maxp = maxval; end; run; Try it and see how close it comes to what you want.

RandyStan · ‎04-25-2019

Dear All I want to choose the max of variable p between observations. So the data set is as follows. The file is sorted by ID p tno ID Second 5 4657 1144 548 5 4658 1144 548 5.5 4662 1144 551 5.45 4663 1144 551 6.25 4668 1144 554 6.25 4669 1144 554 6 3567 1145 425 6.25 3570 1145 427 What I need is the maximum p between seconds 549 and 551 and Seconds 552 and 553 for ID 1144 and between seconds 425 and 427 The p file can be as follows p second 6 425 6.25 426 6.25 427 5 548 5 548 5.4 549 5.45 550 5.5 550 5.75 551 5.85 551 6.10 552 6.15 552 6.2 553 6.25 553 And the file I need is p tno ID Second Maxp 5 4657 1144 548 5 4658 1144 548 5.5 4662 1144 551 5.5 5.45 4663 1144 551 5.5 6.25 4668 1144 554 6.25 6.25 4669 1144 554 6.25 6 3567 1145 425 6.25 3570 1145 427 6.25 Thanx in Advance Randy

RandyStan · ‎02-10-2019

Dear All: My data set is as follows: Time p ID 9:00:01 56.57 45 9:00:01 67.97 46 9:00:01 67.97 46 9:00:01 68.00 46 9:00:02 69.00 76 9:00:02 69.10 79 9:00:02 70.01 45 9:00:03 69.04 78 9:00:03 68.10 46 and so on The output I want is the p observation. So in this example I need: Time p ID 9:00:01 56.57 45 9:00:01 67.97 46 9:00:01 68.00 46 9:00:02 69.00 76 9:00:02 69.10 79 9:00:02 56.57 45 9:00:03 69.04 78 9:00:03 68.10 46 the code I wrote was data want; set have; by ID p time: If first.p then output; run; Some thing does not seem to work with the code. Thanks in advance. R

RandyStan · ‎12-03-2018

Thanks all. I plan to run it tonight. I hope it excludes the case where all the ID's occur only during a second and not spillover into the other seconds. Randy

RandyStan · ‎12-02-2018

Dear All: My data set is as follows: time ID 10:00:01 5 10:00:01 7 10:00:01 7 10:00:02 7 10:00:02 7 10:00:02 86 10:00:03 145 10:00:03 456 10:00:03 97 10:00:04 1467 10:00:04 1467 10:00:04 1467 10:00:05 1467 10:00:05 1467 10:00:05 1467 10:00:06 1467 10:00:10 55 10:00:11 66 The rule is that if the same ID appears consecutively at different times they are identified as 2 So the data want looks as follows: time ID BA 10:00:01 5 10:00:01 7 2 10:00:01 7 2 10:00:02 7 2 10:00:02 7 2 10:00:02 86 10:00:03 145 10:00:03 456 10:00:03 97 10:00:04 1467 2 10:00:04 1467 2 10:00:04 1467 2 10:00:05 1467 2 10:00:05 1467 2 10:00:05 1467 2 10:00:06 1467 2 10:00:10 55 10:00:11 66 Please help Thanx in Advance Randy

RandyStan · ‎10-29-2018

Dear All: My data is as follows: Date ID Lag_ID 21FEB2014 1 . 21FEB2014 1 1 21FEB2014 1 1 21FEB2014 1 1 21FEB2014 2 1 21FEB2014 3 2 21FEB2014 3 3 21FEB2014 3 3 What I want is the first observation of lag_ID for each ID be '.' so In need Date ID Lag_ID 21FEB2014 1 . 21FEB2014 1 1 21FEB2014 1 1 21FEB2014 1 1 21FEB2014 2 . 21FEB2014 3 . 21FEB2014 3 3 21FEB2014 3 3 i wrote data want; set have; by ID; if first.ID then Lag_ID = . ; run; Am I making a mistake? Randy

RandyStan · ‎10-28-2018

Dear All: May data is as follows Date ID Time 22OCT2018 A 9:00 22OCT2018 A 9:00 22OCT2018 A 9:01 22OCT2018 A 9:02 22OCT2018 B 9:08 22OCT2018 B 9:09 22OCT2018 B 9:10 22OCT2018 B 9:10 I want to construct a variable that groups the ID's by time Date ID Time Group 22OCT2018 A 9:00 1 22OCT2018 A 9:00 1 22OCT2018 A 9:01 2 22OCT2018 A 9:02 3 22OCT2018 B 9:08 1 22OCT2018 B 9:09 2 22OCT2018 B 9:10 3 22OCT2018 B 9:10 3 Please Help. Thanx Randy

RandyStan · ‎09-02-2018

Dear Mr. KSharp: Your solution does not result in the output that I need. Your solution of finding the difference gives the following DATE ID ID_A QUARTER QBT 03JAN2017 1 A 1 0 04JAN2017 1 A 1 1 04APR2017 1 A 2 0 10MAY2017 1 A 2 1 09AUG2017 1 A 3 -50000 What I need is DATE ID ID_A QUARTER QBT 03JAN2017 1 A 1 1 04JAN2017 1 A 1 1 04APR2017 1 A 2 1 10MAY2017 1 A 2 1 09AUG2017 1 A 3 -50000 Please help Thanx R

RandyStan · ‎09-01-2018

Dear All: My Data is as follows Date ID ID_A Quarter 03JAN2017 1 A 1 04JAN2017 1 A 1 04APR2017 1 A 2 10MAY2017 1 A 2 09AUG2017 1 A 3 16FEB2017 1 B 1 18SEP2018 1 B 7 13JAN2017 2 A 1 15FEB2017 2 A 1 21JUN2017 2 A 2 14MAR2017 2 B 1 21NOV2017 2 B 4 I want to add another variable QBT indicating the quarters between transactions Date ID ID_A Quarter QBT 03JAN2017 1 A 1 1 04JAN2017 1 A 1 1 04APR2017 1 A 2 1 10MAY2017 1 A 2 1 09AUG2017 1 A 3 -50000 /* Just a flag */ 16FEB2017 1 B 1 6 18SEP2018 1 B 7 -50000 13JAN2017 2 A 1 1 15FEB2017 2 A 1 1 21JUN2017 2 A 2 -50000 14MAR2017 2 B 1 3 21NOV2017 2 B 4 -50000 The rules are as follows: For ID = 1 and ID_A = A there are transactions in 3 Quarters -- 1, 2 and 3 so QBT is the difference between Quarter = 2 and Quarter = 1 So for the first two lines QBT = 1; then for the next two lines QBT = 1 also (3 -2). The last row of ID and ID_A is = -50000 The same logic applies to ID = 1 and ID_A = B Thanx in Advance R

RandyStan · ‎08-19-2018

Using the readings suggested by you I constructed the working days file. Now I am having an issue with constructing the variable WORKDAYSBETWEENDATES Do I specify, in the command line, intervalds (have=workingdays) and then use the INTCK function to find the work days between dates? Thanks so much Randy

RandyStan · ‎08-18-2018

The -50000 is because that is the last line for variables ID and ID_A These are not holidays that occur on fixed days of the year. They are random. For example in one year 08FEB2011 is a holiday; in another year the same holiday may fall on, for example, 12FEB2013.

RandyStan · ‎08-18-2018

Dear All I want to compute days between dates, taking account of holidays. The holidays (non working days) and working days that fall on a Saturday are customized. 1. 05JAN2018 (FRIDAY) and 08JAN2018 (MONDAY) were holidays. 2. 17FEB2018 (SATURDAY) and 19FEB2018 (MONDAY) were working days. The last day of each ID_ for each ID should be -50000 ID ID_A Date 1 A 02JAN2018 1 A 03JAN2018 1 A 04JAN2018 1 A 09JAN2018 1 A 12JAN2018 1 B 06FEB2018 1 B 08FEB2018 1 B 12FEB2018 2 A 16FEB2018 2 A 17FEB2018 2 A 20FEB2018 2 B 02FEB2018 2 B 05FEB2018 I want to construct a variable WORKDAYSBETWEENDATES ID ID_A Date WORKDAYSBETWEENDATES 1 A 02JAN2018 1 1 A 03JAN2018 1 1 A 04JAN2018 1 1 A 09JAN2018 1 1 A 12JAN2018 -50000 1 B 06FEB2018 2 1 B 08FEB2018 1 1 B 12FEB2018 4 2 A 16FEB2018 1 2 A 17FEB2018 2 2 A 20FEB2018 -50000 2 B 02FEB2018 1 2 B 05FEB2018 -50000 Thank you in Advance

Online Status	Offline
Date Last Visited	‎12-23-2022 05:36 PM

Re: Removing Duplicates by ID 1

Removing Duplicates by ID 1

Removing Duplicates by classes

Changing Format and Informat

Importing Files

Dropping a group while taking the mean

If then statement with conditions

First and last observations

Re: Forming time groups

Forming time groups

Previous observatio as last observation if missing

Re: Dates backward and forward

Re: Dates backward and forward

Dates backward and forward

Re: Maximum Value between observations

Maximum Value between observations

Outputting the first observation

Re: Numbering observations

Numbering observations

first.[variable], last.[variable] question

Grouping

Re: Differences between quarters

Differences between quarters

Re: Computing days between Dates with customized holidays and work day...

Re: Computing days between Dates with customized holidays and work day...

Computing days between Dates with customized holidays and work days