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: 
Smitha9
‎03-11-2025
  • 129 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

move variable to specific position

by Fluorite | Level 6 in New SAS User
‎09-13-2022 10:13 AM
‎09-13-2022 10:13 AM
Hi, I have a dataset with 10 variables: a  b  c  d   e   f   g   h   i   j     I want to change the position of variable " j" to second position and  "d" to 10th position. a   j   b   c   e  f   g   h   i   d   I there any other way other than using retain? A short way. ... View more

format the Date

by Fluorite | Level 6 in New SAS User
‎09-13-2022 09:47 AM
‎09-13-2022 09:47 AM
I have the dataset: 20SEP22:10:00:00 21SEP22:13:30:00 19SEP22:13:30:00   I want the dataset with following format: 09/20/2022 09/21/2022 09/19/2022   thank in advance ... View more

nearest and next nearest date organized accordingly

by Fluorite | Level 6 in New SAS User
‎08-29-2022 06:51 PM
‎08-29-2022 06:51 PM
ID     Sub         Date1                   Date2              Difference       1         A         11/02/1998             08/04/2022            -8676 2         A         06/24/1999             01/12/2022            -8238 2         B         09/16/2019             01/12/2022            -849 3         A          03/11/2019             05/17/2021            -798 4         A          07/11/2005             01/15/2022            -6032 4         B          05/11/2018             01/15/2022            -1345 5         A          09/19/2007             04/09/2020            -4586 5         B          09/19/2007             04/09/2020            -4586 5         C          02/09/2010             04/09/2020            -3712   I want the dataset Date1 near to the Date2. I want only maximum 2 rows per ID and the first would be the nearest and the second would be the next nearest/same difference if Sub is different. ID     Sub         Date1                   Date2              Difference       1         A         11/02/1998             08/04/2022            -8676      ( for ID=1 only one row) 2         B         09/16/2019             01/12/2022            -849       (for ID=2 849 is nearest so this comes first) 2         A         06/24/1999             01/12/2022            -8238      (for ID=2 8238 is second nearest) 3         A          03/11/2019             05/17/2021            -798       (for ID=3 only one row) 4         B          05/11/2018             01/15/2022            -1345    (for ID=4 -1345 is nearest to date2) 4         A          07/11/2005             01/15/2022            -6032     ( for ID=4 next nearest to date2) 5         A          09/19/2007             04/09/2020            -4586     ( for ID=5 first nearest to date2) 5         B          09/19/2007             04/09/2020            -4586     ( for ID=5 same difference -4586 but different Sub                                                                                                       so comes second row)   can I do this in SAS?   thanks in advance.   ... View more

Nearest Date and the next Nearest Date

by Fluorite | Level 6 in New SAS User
‎08-29-2022 05:20 PM
‎08-29-2022 05:20 PM
Hi,  I have a dataset A: ID     Car_part        DateA           Check_Date 1         mirror      01/02/2010        04/16/2020 1         Brake      01/03/2010        04/16/2020 1        mirror        01/23/2014       04/16/2020 2       mirror     12/13/2008          04/15/2018 2       mirror      12/13/2008         04/15/2018 2       mirror       12/18/2012       04/15/2018 3    mirror       07/07/2010         08/09/2015 3    Car          07/07/2010         08/09/2015 3    mirror       07/29/2010         09/08/2016   I want how many days are in between  DateA and CheckDate. Also I want to select 2 dates which are earliest near Check_Date. If there duplicates then delete. But if there are duplicates and Car_Part is  different. Then I want earliest and second earliest the same with different Car_Part. Want Dataset: ID     Car_part        DateA           Check_Date     Difference_Days 1        mirror        01/23/2014       04/16/2020  1         Brake      01/03/2010        04/16/2020 2         mirror       12/18/2012       04/15/2018 2       mirror      12/13/2008         04/15/2018 3        mirror       07/07/2010         08/09/2015          same but car_part is mirror 3        Car          07/07/2010         08/09/2015           same but care_part is car ... View more

Select the values near to the zero by group

by Fluorite | Level 6 in SAS Programming
‎08-25-2022 03:59 PM
‎08-25-2022 03:59 PM
Hi, I have a dataset  ID   Days   1     -78 1     130 2    -98 2   -89 2    -456 3   -57 3     3   I want to select the nearest to the "0" value from the group of ID. ID     Days 1       -78 2       -89 3         3      ... View more

seperate date and time

by Fluorite | Level 6 in SAS Programming
‎08-18-2022 07:26 PM
‎08-18-2022 07:26 PM
I have a dataset: Date: 30AUG2022:11:15:00.000 I want a separate variables for Date and Time  Date                Time 30AUG2022   11:15:00.000   thank you in advance ... View more

first 4digits

by Fluorite | Level 6 in New SAS User
‎08-16-2022 11:15 AM
‎08-16-2022 11:15 AM
Hi, I have a dataset, ID      Barcode 1        48095 2       4807 3        4904 4        49068 5         4906 6          49066   I want the data with specific first 4digits ( 4809 and 4906) doesn't matter what the 5th digit is. ID         Barcode 1           48095 2           49068 3           4906 4           49066   thank you in advance. ... View more

Re: select the observation which has mobile in it

by Fluorite | Level 6 in New SAS User
‎08-16-2022 11:09 AM
‎08-16-2022 11:09 AM
yes it worked. thanks and I accepted as the solution. ... View more

select the observation which has mobile in it

by Fluorite | Level 6 in New SAS User
‎08-15-2022 05:29 PM
‎08-15-2022 05:29 PM
Hi, I have a dataset which is ID       Name 1        fact mobile 2        stay  focus mobile 3        facial 4        free flow in the rest mobile 5       secured locate 6       focus in the center right angle mobile   I want to select all the ID's which has "mobile" word in the Name variable. 1     fact mobile 2     stay focus mobile 3     free flow in the rest mobile 4     focus in the center right angle mobile thank you in advance. ... View more

specific random observations from a variable

by Fluorite | Level 6 in New SAS User
‎08-11-2022 10:01 PM
‎08-11-2022 10:01 PM
Hi, I have a dataset: ID    Memb 1      12345 2     34567 3    45678 4     45632 5     54321 approximate 10,000 observations.   How to select these list of observations only ( 34567 45632 54321 65432 56789 32411 54623 54322 90987 98765 76543 89234 )   thanks in advance. ... View more

Deidentification Dates and the ID

by Fluorite | Level 6 in New SAS User
‎07-28-2022 09:44 AM
‎07-28-2022 09:44 AM
Hi, I have a dataset ID                           Date 253645              01/23/2004 234654              02/05/2001 243657              03/06/1999 243657              05/06/2003 326789              09/03/2009 983211              04/03/2007 983211              08/10/2002   I want to deidentify the ID and the Date and saved it. I also want to run the code  to cancel the deidentified variables to original ID and Date  if needed.    could you let me know if this is done is SAS?   thank you in advance.   ... View more

Same Observation

by Fluorite | Level 6 in New SAS User
‎07-26-2022 09:59 AM
‎07-26-2022 09:59 AM
Hi, I have a dataset ID  Name         DOB 1   Sarah    07/29/1970 1       .                . 1   Sarah      07/29/1970   I want to fill the missing values and dataset which I have has 10000's ID's. ID  Name         DOB 1   Sarah    07/29/1970 1   Sarah     07/29/1970                1   Sarah      07/29/1970   can I do this in SAS?   thanks in advance. ... View more

compare the names in the same dataset

by Fluorite | Level 6 in New SAS User
‎07-25-2022 12:19 PM
‎07-25-2022 12:19 PM
 I have a dataset A and want to compare mom vs mom_new and dad vs dad_new and comment check_mom and check_dad. if the names are correct or wrong like follows Mom  Dad    Mom_new    Dad_new    Check_mom       Check_dad abc     dher     ABC             Dher           correct                correct Bcd     sher     bcd             SHER           correct               correct Fer      Sta       Far             Sta                wrong                correct   thanks in advance ... View more

Date Match to closer

by Fluorite | Level 6 in SAS Programming
‎07-22-2022 11:54 AM
‎07-22-2022 11:54 AM
Hi, I have a dataset ID        Date                Measure  1      01/01/2005        02/03/2007 1      02/03/2008        03/04/2010 1      03/20/2011         05/06/2009   I want the "Measure Date" closer to the "Date" ID            Date            Measure 1          01/01/2005     02/03/2007 1          02/03/2008     02/03/2007 1          03/20/2011     03/04/2010   The measure date 02/03/2007 is closer to both 01/01/2005 and 02/03/2008 and measure date 03/04/2010 is closer to 03/20/2011   Can I do this is SAS?   thanks so much. ... View more

Select the first, second, third variable based on the data

by Fluorite | Level 6 in New SAS User
‎07-21-2022 12:06 PM
‎07-21-2022 12:06 PM
Hi, I have a dataset: ID    Sub_ID   Measure_year         Ht        Wt 1       12             06/06/1995            .           . 1       13             07/08/1997            .        135 1       14             07/29/1987          66          . 1       15             08/01/1988          56       140   I want the dataset: where I need to select the Ht which has the first value in it based on the earliest Measure_year with values in Ht and Wt. ID          Sub_ID        Measure_time           Ht     Wt 1              14               07/29/1987              66     135   Can I do this with more ID's? thank in advance. -Smitha ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-11-2025 07:45 PM
Likes from
View All
Quick links