About Jeff_DOC

Jeff_DOC

So many good solutions but I accepted the one I found to be easiest to understand and took the least effort. I learned a lot along the way, thank you to all who contributed their time and expertise.

Jeff_DOC

Hello. I have a problem I'm hoping someone can help me with. I have a large list of the type at the bottom. I need to parse out the numbers from the string in var2 and then compare the result to a range. For instance, the range may be from 13 to 35 and I need to find which desks fit into that range. So if I can parse out the numbers and they determine if they are within a particular range that'd be perfect. I've attempted to use: data test_1; set have; if compress(var2,'', 'A') >= &range_1. and compress(var2,'', 'A') <= &range_2. then test = 'YEAH'; run; to parse out the numbers and they come out alpha. I've also tried: data test_1; set have; if input(compress(var2,'', 'A'), 8.) >= &range_1. and input(compress(var2,'', 'A'), 8.) <= &range_2. then test = 'YEAH'; run; When I use either method above in order to convert the result to a number so I can use GE and LE to compare to the criteria range I get an error: ERROR 388-185: Expecting an arithmetic operator. My macro variables are defined as: %let range_1 = 13; %let range_2 = 24; so they appear to be numeric so I'm not sure where my error might be? Thanks to anyone who can take the time to help me out. var1 var2 WANT ROOMA DESK01A 1 ROOMA DESK01B 1 ROOMA DESK05B 5 ROOMA DESK06A 6 ROOMB DESK09A 9 ROOMB DESK09B 9 ROOMC DESK01B 1 ROOMC DESK05A 5 ROOMD DESK10B 10 ROOME DESK15A 15 ROOME DESK15B 15 ROOME DESK16 16

Jeff_DOC · ‎11-19-2025

Sorry about the lateness of my solution acceptance. This works perfectly and gives me what I need to begin building in my conditional logic. It also explained the lag function to me as it's not something I've used before, so thank you for all of that.

Jeff_DOC · ‎11-10-2025

Good afternoon. I need a data step to determine the number of days between succeeding rows based on a group (see the example). I've tried to use RETAIN to achieve this, but I haven't been able to make any progress at all. Could someone point me in the correct direction to perform this? I don't have an example since I haven't gotten anything to work. Thank you very much to anyone willing to help. KEY REVIEW_DATE REVIEW_TYPE Days Comment 380 3/31/2023 INIT 0 All INIT with the same KEY begin with zero 380 9/6/2023 6MONTH 159 Subsequent rows with the same key determine the number of days from the preceding row REVIEW_DATE. 380 3/6/2024 6MONTH 182 Subsequent rows with the same key determine the number of days from the preceding row REVIEW_DATE. 380 9/18/2024 6MONTH 196 Subsequent rows with the same key determine the number of days from the preceding row REVIEW_DATE. 380 4/4/2025 6MONTH 198 Subsequent rows with the same key determine the number of days from the preceding row REVIEW_DATE. 381 2/22/2024 INIT 0 All INIT with the same KEY begin with zero 381 6/30/2024 6MONTH 129 Subsequent rows with the same key determine the number of days from the preceding row REVIEW_DATE. 381 7/1/2025 6MONTH 366 Subsequent rows with the same key determine the number of days from the preceding row REVIEW_DATE.

Jeff_DOC · ‎11-07-2025

That is exactly what I needed. Thank you so much!

Jeff_DOC · ‎11-07-2025

Good afternoon. I am new to proc compare and I wondered if anyone could point me in the direction of any explanations to what the output values mean? It seems to work for me but I wanted to be sure I totally understood what each value in the output means (Ex. XXXX, E, ....,, -35, etc.). All the explanations I can find reference understanding the proc print output, but I wanted to see mine like this in tabular style. I can read the documentation myself but can't seem to find any. _TYPE_ VAR1 VAR2 VAR3 VAR4 VAR5 VAR6 VAR7 VAR8 VAR9 VAR10 VAR11 VAR12 VAR13 VAR14 VAR15 VAR16 VAR17 VAR18 VAR19 VAR20 VAR21 VAR22 VAR23 VAR24 VAR25 VAR26 VAR27 VAR28 VAR29 VAR30 VAR31 DIF 1 32054 20030613 E E .... . .... .... E E .... .... .......... E E .......... . ........................................ E . .... .......... .......... E E .... XXXXXXXX.. .......... -120023 31516 DIF 1 32054 20250415 E E XXXX X .... .... E E .... .... .......... E E .......... . XXXXXXXXXXXXXXXXXXXXXXX..XXXXXXXXXXX.XXX E . .... .......... .......... E E XXXX XXXXXXXX.. ....XXX... -610 54344 DIF 1 33821 20250721 E E .... X .... .... E E .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E .... .......... .......... E E DIF 1 34250 20250702 E E XXXX X .... .... E E .... .... .......... E E .......... X ..XXXXXXXXXX.XXXXXXXXXXXXXXXXXXXXXX..... E . .... .......... .......... -202 -1999 .... .......... .......... -299 48017 DIF 1 35838 20240723 E E XXXX X .... .... E E .... .... .......... E E .......... . XXXX..XXX.XXXXXXXXXX.................... E . .... .......... .......... E E XXXX XXXXXXXX.. ....XXX... -10285 -9590 DIF 1 39678 20250723 E E XXXX X .... .... E -35 .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E XXXX XXXXXXXX.. ....XXX... -1 1016 DIF 1 44757 20250705 E -1 XXXX X .... .... E -2 .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E .... .......... .....X.... E -581 DIF 1 48518 20250722 E E .... X .... .... E E .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E .... .......... .......... E E DIF 1 59462 20250425 E E XXXX X .... .... E E .... .... .......... E E .......... X XXXXXXXXXXXXXXXXXXXX.................... E . .... .......... .......... E E .... XXXXXXXX.. .......... -305 5723 DIF 1 61460 20250723 E E XXXX X .... .... E 70 .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E XXXX XXXXXXXX.. ....XXX... -1 40688 DIF 1 67105 20250514 E E .... . .... .... E E .... .... .......... E E .......... . ...............XXXXXXXXXXXXXXXXXXXXX.... E . .... XXXXXXXX.. .......... -299 -12740 .... XXXXXXXX.. .......... -299 -12740 DIF 1 85268 20250813 E E XXXX X .... .... E 155 .... .... .......... E -20250812 XXXXXXX... X ...............XXXX.XX.XXXXXXX.......... E . .... .......... .......... E E XXXX XXXXXXX... ....XXX... -98 63097 DIF 1 86947 20250723 E E XXXX X .... .... E 200 .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E .XXX XXXXXXX... ....XXX... -1 21765 DIF 1 88047 20250604 E E XXXX X .... .... E E .... .... .......... E E .......... X XXXXXXXXX............................... E . .... .......... .......... E E .... .......... .......... -93 62136 DIF 1 92094 20250723 E E XXXX X .... .... E E .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E XXXX XXXXXXX... ....XXX... -1 -42064 DIF 1 95910 20250722 E E .... X .... .... E E .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E .... .......... .......... E E DIF 1 96247 20240813 E E XXXX X .... .... E E .... .... .......... E E .......... . XXXX..XXX.XXXXXXXXXX.................... E . .... .......... .......... E E XXXX XXXXXXX... ....XXX... -10013 58615 DIF 1 96593 20200114 E E .... . .... .... E E .... .... .......... E E .......... . XXXX..................XXXX.............. E . .... .......... .......... E E .... XXXXXXXX.. .......... -9805 -61513 DIF 1 96593 20210409 E E .... . .... .... E E .... .... .......... E E .......... . XXXX..................XXXX.............. E . .... .......... .......... E E .... XXXXXXXX.. .......... -9805 -61513 DIF 1 101163 20250723 E E XXXX X .... .... E E .... .... .......... E E .......... X ........................................ E . .... .......... .......... E E XXXX XXXXXXX... ....XXX... -1 -42000 DIF 1 126058 20250910 E E XXXX X .... .... E E .... .... .......... E E .......... X .........XXXXXXXXXX.XXXX.XXXXX.XXXXXXXX. E . .... .......... .......... E E XXXX XXXXXXXX.. ....XXX... -208 61629 DIF 1 130552 20250604 E E XXXX X .... .... E E .... .... .......... E E .......... . XXXX..XXX.XXXXXXXXXX.................... E . .... .......... .......... E E XXXX XX.XXXXX.. ....XXX... -404 40771

Jeff_DOC · ‎09-05-2025

Sorry, I'm not good enough to clearly state the problem and/or solution. That data step performed other functions and when I moved the age determination outside of the problematic data step it worked just fine and that's the most important thing. The data step performed other functions so I'm assuming one conflicted or one of the variables in my function was dependent on that and I was attempting to this age calculation. Moving it outside of the data step eliminated that conflict and it runs just fine. The key concept from Cynthia and Paige was that perhaps my function wasn't to blame (since I did not change it, I just moved it). So it wasn't the particular function at fault, which is what I had focused on. A good reminder to me to check other possibilities.

Jeff_DOC · ‎09-05-2025

I don't believe that's accurate. The key information in your responses was "there's something else going on here" since neither of you could replicate my issue given my (or your own data). Therefore, what/where I thought the issue was, was not and I was forced to "back up a step" and consider the input information not just the result.

Jeff_DOC · ‎09-05-2025

Thank you to everyone who took the time to reply to me. I accepted Cynthia's solution because that was the response I was reading when what Paige and Cynthia were saying finally got through to me. I so wish I could split solutions into percentages.

Jeff_DOC · ‎09-04-2025

Certainly. dob date_01 age_on_date -1 23386 . -1 23386 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 0 22551 . 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 8 17322 47 9 19345 52 9 19345 52 9 19345 52 9 19345 52 9 19345 52 9 19345 52

Jeff_DOC · ‎09-04-2025

Thanks to all who are contributing. You can see by the attached data example why I'm thinking this is a 1/1/1960 issue. I know the log states a divide by zero option but both dates do exist for those records without an age showing even in the log warning. I believe the warning most likely coming from a unrelated function in the same data step since the step has other included work. The missing data begins prior to 1/1/1960 (date zero) and picks up the first date after 1/1/1960 even though the two dates clearly exist. dob=12/31/1959 date_01=1/11/2024 age_on_date=. Data temp; Set temp_01; age_on_date = int(yrdif(dob, date_01, 'AGE')); run; NOTE: Division by zero detected at line 229 column 32. dob date_01 age_on_date 12/31/1959 1/11/2024 . 12/31/1959 1/11/2024 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 4/28/1987 . 1/1/1960 9/28/2021 . 1/1/1960 9/28/2021 . 1/1/1960 9/28/2021 . 1/1/1960 9/28/2021 . 1/1/1960 9/28/2021 . 1/1/1960 9/28/2021 . 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/9/1960 6/5/2007 47 1/10/1960 12/18/2012 52 1/10/1960 12/18/2012 52 1/10/1960 12/18/2012 52 1/10/1960 12/18/2012 52 1/10/1960 12/18/2012 52

Jeff_DOC · ‎09-04-2025

Hello there. I am trying to determine age over many, many records. I'm using the function: int(yrdif(dob, date_01, 'AGE')). Both DOB and Date_01 are formatted MMDDYY10. However, I get no results for some records. The only pattern I can see is that the no result records are for people born prior to January 1, 1960. I'm assuming this is because prior to that the result is negative but that's only an assumption. I've tried the option yearcutoff=1910 but that doesn't seem to help. Can anyone tell me if there's a better way to determine age in the situation where some records are pre and some are post? Thank you very much.

Jeff_DOC · ‎05-28-2025

You are correct in that my dates have a specific format, I didn't think that would matter since SAS seems to understand it's a date regardless. Also, the time, both trip_time and trip_return_time, are both numeric. I now see why the substr function didn't work. Thanks for that. The time variables have no specific formatting-they are simply numeric. Using a trip_date of 7/11/2009 and a trip time of 1416 here's what I get - Your initial suggestion: datetime =dhms(date,0,0,time); format datetime datetime19.; Seems to get most of the way there so I'm assuming I've not addressed something in there. The result I get using the below: datetime =dhms(trip_date,0,0, trip_time); format datetime datetime19.; is: 11JUL2009:00:23:36 I believe what I should be getting is 11JUL2009:14:16:00 so I can use subtraction to determine the difference between the trip information and the trip return information. I obviously do not understand working with time values as well as I need to.

Jeff_DOC · ‎05-28-2025

Hi. You are correct in the non-variability of the data. I only used the first few rows so as to not overwhelm the issue. My assumption is that if it worked for one record I could make it work for others.

Jeff_DOC · ‎05-27-2025

Good morning. Any help would be greatly appreciated. I am using the SAS examples from other questions but can't seem to get either to work. It may not be the best approach so I'm open to any help. I have a standard start date and a numeric time (in two separate fields) and a standard end date and numeric time (in two separate fields). I need to find the number of hours between the two-it could be a start date with a return date a day or two later-it may not always be the same date. On attempt one I only get missing results, on attempt two I get a conversion like 1405 = 14:05 I have a feeling there's a simple solution, but I can't seem to work it out. Thank you very much. Attempt one: trip_time_standard = hms(input(substr(trip_time, 1, 2), best.), input(substr(trip_time, 3, 2), best.), 0); I get all missing results. Attempt two: data court_19; set court_18; trip_time_test = trip_time; trip_return_time_test = trip_return_time; t = input(trip_time, best.); trip_time_DT = hms(int(t/100), mod(t,100), 0); t = input(trip_return_time, best.); trip_return_time_DT = hms(int(t/100), mod(t,100), 0); format trip_time_DT trip_return_time_DT hhmm5.; run; reference_date idnum trip_date TRIP_TIME trip_return_date TRIP_RETURN_TIME trip_time_test trip_return_time_test t trip_time_DT trip_return_time_DT 1/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 2/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 3/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 4/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 5/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 6/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 7/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 8/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50 9/1/2018 636 7/11/2009 1416 7/11/2009 1950 1416 1950 1950 14:16 19:50

Online Status	Offline
Date Last Visited	3 weeks ago

Re: Extract Number From String and Convert to Number

Extract Number From String and Convert to Number

Re: Use Retain to Determine Number of Days Between Dates

Use Retain to Determine Number of Days Between Dates

Re: Proc Compare Output Explanation

Proc Compare Output Explanation

Re: Determine age when DOB is prior to 1960

Re: Determine age when DOB is prior to 1960

Re: Determine age when DOB is prior to 1960

Re: Determine age when DOB is prior to 1960

Re: Proc Compare Output Explanation

Re: creating an excel output: running proc sql and proc print

Re: Build a macro variable of multiple values based on day of week

Re: ODS Excel Options to insert page numbers

Re: User does not have appropriate authorization level for file...

Re: Determine age when DOB is prior to 1960

Create datetime from numeric time and find number of hours between

Re: Determine days from dynamic date

Re: Determine days from dynamic date

Re: Determine days from dynamic date

Re: Extract Number From String and Convert to Number

Extract Number From String and Convert to Number

Re: Use Retain to Determine Number of Days Between Dates

Use Retain to Determine Number of Days Between Dates

Re: Proc Compare Output Explanation

Proc Compare Output Explanation

Re: Determine age when DOB is prior to 1960

Re: Determine age when DOB is prior to 1960

Re: Determine age when DOB is prior to 1960

Re: Determine age when DOB is prior to 1960

Re: Determine age when DOB is prior to 1960

Determine age when DOB is prior to 1960

Re: Create datetime from numeric time and find number of hours between

Re: Create datetime from numeric time and find number of hours between

Create datetime from numeric time and find number of hours between