About Ihsan-Mahdi

Ihsan-Mahdi · ‎11-20-2025

I'm sorry the correct IF statement I'm using is: IF substr(ICD10Code,1,3)="T21" & substr(ICD10Code,8,1) in ("A", "B", "C") THEN MIC=1;

Ihsan-Mahdi · ‎11-20-2025

Hello, I'm using this statement in my code: IF substr(ICD10Code,1,1)="T21" & substr(ICD10Code,8,1) in ("A", "B", "C") THEN MIC=1; However, When ICD10Code value is T21.06XA, SAS is returning MIC =0 Any idea why this is happening? Thank you !

Ihsan-Mahdi · ‎09-15-2025

Thank you for your interest in my post! In my data, "Leave" comes first (records are EMS transports from scene to a hospital). Choosing which variable to change is based on the DAY, MONTH, and TIME parts (the "Leave" field should be earlier then 'Arrived"). The logic if deciding a different year is a problem is that a transport from scene to hospital should not logically be that long. I have identified a specific number of records where the YEAR difference is a problem, none of those records had dates between Dec. and Jan. or contained Feb. 29. I wanted to use the code for changing the specific records identified and not the entire data set. Thanks again 🙂

Ihsan-Mahdi · ‎09-15-2025

Thank you!

Ihsan-Mahdi · ‎09-10-2025

Hello, I have a data set with two date/time variables (leave date/time and arrive date/time). In a couple of hundred records the YEAR part in these two variables is different in the same record, which should not be the case. Is there a way to make the YEAR part equal in both fields in each record without having to do it separately for each record at a time? Below is a sample of the data: data sample; INPUT ID LeaveDT datetime20. ArriveDT datetime20. ; DATALINES; 1 29JAN2016:18:17:00 29JAN2017:01:30:00 2 25MAR2016:15:39:00 25MAR2017:16:54:00 3 23NOV2014:20:23:00 23NOV2019:20:28:00 4 10SEP2018:18:39:00 10SEP2019:18:54:00 5 08FEB2017:20:24:00 08FEB2018:20:47:00 ; RUN; Thank you!

Ihsan-Mahdi · ‎01-30-2025

Thank you!

Ihsan-Mahdi · ‎01-30-2025

Hello, I have a data set that looks something like this: DATA example; INPUT id ais; DATALINES; 1 3 1 4 2 5 2 7 2 3 3 2 3 4 3 1 ; run; I would like to square each "ais" value, then add the squares by each "id" value creating a new variable called "iss". so for "id" (1) the iss should equal 9+16=25. I tried different codes but none worked. Help please!

Ihsan-Mahdi · ‎09-16-2024

It worked after specifying the length!! Thank you Again for your time and brilliance 🙂

Ihsan-Mahdi · ‎09-16-2024

I'm sorry, it seems that I'm doing something wrong! Data want keeps having 0 observations!! To help clarify, the string variables in my set are named "ICD_10_dx_1 to ICD_10_dx_50". This is the code I used based on yours: data want; set have; array x[10] $ _temporary_ ('S00' 'S10' 'S20' 'S30' 'S40' 'S50' 'S60' 'S70' 'S80' 'S90'); array v[*] ICD_10_dx_1-ICD_10_dx_50; output=1; do i=1 to dim(v); if not missing(v{i}) and v{i} not in: x then do;output=0;leave;end; end; if output then output; drop output i; run; data want; set have; array x{10} $ _temporary_ ('S00' 'S10' 'S20' 'S30' 'S40' 'S50' 'S60' 'S70' 'S80' 'S90'); array v{*} $ ICD_10_dx_:; output=1; do i=1 to dim(v); if not missing(v{i}) and v{i} not in: x then do;output=0;leave;end; end; if output then output; drop output i; run; Where am I going wrong?!

Ihsan-Mahdi · ‎09-16-2024

Thank you! Is there a way to make _temporary_ start with the 3 character value rather than equaling it? I selected only 3 characters in my example for simplicity, what I actually have in my data are values with variable numbers of characters. I want the ones that start with the 3 I mention in my example list.

Ihsan-Mahdi · ‎09-16-2024

Hello, I have a data set with multiple string variables, I would like to flag records with specific values AND exclude others. The values I want include S00-S10-S20-S30-S40-S50-S60-S70-S80-S90 only (example below). Is there a way to do that using arrays or something else? Thank you so much 🙂 Example of records wanted are in Red Obs Var1 Var2 Var3 Var4 Var5 Var6 Var7 2 S05 S05 S00 S01 S00 3 S20 S10 4 S29 S60 S60 6 S20 S61 7 S16 S60 S01 S01 S01 S01 S06 10 S01 S50 S50 S00 12 S36 S32 S40 S40 13 S70 14 S42 S42 S70 S80 S80 S80 S70 19 S42 S53 S40 20 S06 S00 S60 S70 21 S00 S40 S70 22 S42 S40 S70 23 S02 S02 S00 S40 S40 S40 S40 24 S32 S70 S01 25 S42 S62 S42 S60 S80 S50 S50

Ihsan-Mahdi · ‎08-28-2024

This code actually worked beautifully! Thank you 🙂

Ihsan-Mahdi · ‎08-28-2024

Hello, I would like to create boxplots for 2 variables (distance and time) compared between two types of transport (air and ground). All variables are numeric with the transport variable having 2 values (1 for air & 0 for ground). Is there a way to produce such boxplots in one graph? Thank you!

Ihsan-Mahdi · ‎06-27-2024

Thank you so much! This is brilliant 🙂

Ihsan-Mahdi · ‎06-27-2024

Small geographic area and the population examined is that of trauma patients only. So I think it would make sense for some strata not to be represented. What would be a code example of combining age strata?

Online Status	Offline
Date Last Visited	‎11-21-2025 06:56 PM

Re: IF statement not working consistently

IF statement not working consistently

Re: Making the year part in two date/time fields equal

Re: Making the year part in two date/time fields equal

Making the year part in two date/time fields equal

Re: squaring vales then adding squares by group

squaring vales then adding squares by group

Re: Flagging records with specific values

Re: Flagging records with specific values

Re: Flagging records with specific values

Re: IF statement not working consistently

Re: IF statement not working consistently

Re: IF statement not working consistently

Re: IF statement not working consistently

Re: IF statement not working consistently

Re: Making the year part in two date/time fields equal

Re: Changing SAS's work library path

Re: IF statement not working consistently

IF statement not working consistently

Re: Making the year part in two date/time fields equal

Re: Making the year part in two date/time fields equal

Making the year part in two date/time fields equal

Re: squaring vales then adding squares by group

squaring vales then adding squares by group

Re: Flagging records with specific values

Re: Flagging records with specific values

Re: Flagging records with specific values

Flagging records with specific values

Re: How to create Boxplots for two discrete variables by group

How to create Boxplots for two discrete variables by group

Re: proc stdrate error

Re: proc stdrate error