cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ihsan-Mahdi
Tuesday
  • 71 Posts
  • 29 Likes Given
  • 0 Solutions
  • 3 Likes Received

Re: SAS Heat Map

by Quartz | Level 8 in SAS Programming
Monday
Monday
I did, but the graphs comes up weird: I was hoping for Y axis labels of 0-23 and X axis labels of 1-7 ... View more

Re: SAS Heat Map

by Quartz | Level 8 in SAS Programming
Monday
Monday
Thank you for responding. The referenced paper doesn't seem to contain a map similar to what I want, which would be something like this:   ... View more

SAS Heat Map

by Quartz | Level 8 in SAS Programming
Monday
Monday
Hello, I have a set containing 2 types of injuries (coded 0 & 1), and a date/time field. I'm interested in creating a heat map showing the frequency of occurrence of each injury type by time of day in a week, and another map showing frequency of occurrence by month of year. Is that doable? If so, what would be the code? This is a sample of my set: data sample (compress=binary);       INPUT record_id Injury1 Injury2 year InjuryDateTime:DATETIME20.;    format InjuryDateTime datetime20.;       DATALINES; 2497728 1 0 2021 27APR2021:15:00:00 2590114 1 0 2023 25NOV2023:20:20:00 2590765 1 0 2023 18AUG2023:17:20:00 2590842 1 0 2023 06JUL2023:10:00:00 2591821 1 0 2023 16AUG2023:18:36:00 2591839 1 0 2023 31JUL2023:14:46:00 2591860 1 0 2023 04JUL2023:17:59:00 2599177 1 0 2023 01OCT2023:18:00:00 2599305 1 0 2023 01OCT2023:14:00:00 2600027 1 0 2023 22OCT2023:19:00:00 2600280 1 0 2023 22OCT2023:19:00:00 2502863 0 1 2021 13NOV2021:13:00:00 2507650 0 1 2021 24SEP2021:16:25:00 2507987 0 1 2021 12AUG2021:14:21:00 2508819 0 1 2021 07MAY2021:18:15:00 2516706 0 1 2021 21SEP2021:09:07:00 2516721 0 1 2021 20SEP2021:21:00:00 2516869 0 1 2021 05SEP2021:09:40:00 2517049 0 1 2021 14AUG2021:08:18:00 2517142 0 1 2021 05AUG2021:22:00:00 2517187 0 1 2021 31JUL2021:00:40:00       ;       RUN;   Thank you! ... View more

Re: IF statement not working consistently

by Quartz | Level 8 in SAS Programming
‎11-20-2025 06:55 PM
‎11-20-2025 06:55 PM
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; ... View more

IF statement not working consistently

by Quartz | Level 8 in SAS Programming
‎11-20-2025 06:22 PM
‎11-20-2025 06:22 PM
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 ! ... View more

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

by Quartz | Level 8 in SAS Programming
‎09-15-2025 01:02 PM
‎09-15-2025 01:02 PM
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 🙂 ... View more

Making the year part in two date/time fields equal

by Quartz | Level 8 in SAS Programming
‎09-10-2025 05:07 PM
‎09-10-2025 05:07 PM
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! ... View more

Re: squaring vales then adding squares by group

by Quartz | Level 8 in SAS Programming
‎01-30-2025 03:15 PM
‎01-30-2025 03:15 PM
Thank you! ... View more

squaring vales then adding squares by group

by Quartz | Level 8 in SAS Programming
‎01-30-2025 02:20 PM
‎01-30-2025 02:20 PM
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! ... View more

Re: Flagging records with specific values

by Quartz | Level 8 in SAS Programming
‎09-16-2024 09:51 PM
‎09-16-2024 09:51 PM
It worked after specifying the length!! Thank you Again for your time and brilliance 🙂 ... View more

Re: Flagging records with specific values

by Quartz | Level 8 in SAS Programming
‎09-16-2024 09:47 PM
‎09-16-2024 09:47 PM
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?!  ... View more

Re: Flagging records with specific values

by Quartz | Level 8 in SAS Programming
‎09-16-2024 09:25 PM
‎09-16-2024 09:25 PM
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. ... View more

Flagging records with specific values

by Quartz | Level 8 in SAS Programming
‎09-16-2024 07:24 PM
‎09-16-2024 07:24 PM
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 ... View more

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

by Quartz | Level 8 in Graphics Programming
‎08-28-2024 11:58 PM
‎08-28-2024 11:58 PM
This code actually worked beautifully! Thank you 🙂 ... View more
Contact Me
Online Status
Offline
Date Last Visited
Tuesday
Likes from
View All
Quick links