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: 
MABRINCH
‎07-05-2024
  • 16 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Extract value when preceding variable has a specific value

by Fluorite | Level 6 in SAS Programming
‎05-08-2022 02:30 PM
‎05-08-2022 02:30 PM
  Can someone help me with a SAS code where a variable, MET, extract the numbers of the second variable, if one of the variables CODE_1-CODE_44 contains one of several codes (T1b, T4a, T3a) and that the first subsequent variable (of CODE_1-CODE_44) contains a 6-character code  that starts with "LND" (LND001-LND200).     CODE_1  CODE_2 CODE_3 CODE_4       CODE_5        MET.1  MET.2  T1b             LND022     C2a         P4                T6B               22        .            T4a             M4            C2a         T4a              LND020          20        .               T4a             LND001     T1b         LND044       LND032          1        44        ... View more

mark a specific combination of two variables next to each other

by Fluorite | Level 6 in SAS Programming
‎04-09-2022 08:36 AM
‎04-09-2022 08:36 AM
Can someone help me with a SAS code where a variable, MET, indicates if one of the variables CODE_1-CODE_44 contains one of several codes (T1b, T4a, T3a) and that the subsequent variable (of CODE_1-CODE_44) contains one of several codes (M1, M2, U3).    CODE_1  CODE_2 CODE_3 CODE_4 .....        MET T1b             M1            C2a         P4                      1 T4a             M4            C2a         T4a                     . T4a             M4            T1b          M1                     1 ... View more

APC - annual percentage change

by Fluorite | Level 6 in SAS Programming
‎06-16-2021 05:38 AM
‎06-16-2021 05:38 AM
Hi I would like to calculate the APC annual percentage change with 95% CI for the crude incidence of a disease in the period 2010 til 2019. Is it necessary to use joinpoint software? (which I have no clue on how to work with).    I have following data       year      incidence rate 2010 3.86 2011 4.89 2012 4.91 2013 4.92 2014 5.96 2015 6.02 2016 6.67 2017 5.62 2018 6.04 2019 6.43 ... View more

Re: how to do a match sequence in SAS

by Fluorite | Level 6 in SAS Programming
‎01-29-2021 03:12 AM
‎01-29-2021 03:12 AM
"matchseq" is the variable I want. ... View more

how to do a match sequence in SAS

by Fluorite | Level 6 in SAS Programming
‎01-29-2021 01:00 AM
‎01-29-2021 01:00 AM
what is the SAS equivalent to SPSS's matchsequence (a sequential count of matching case in each group)?  I want to number cases with same ID by a date(ascending) and if same date then by a stage(descending).  Data want:    ID date stage matchseq 1 01-10-2016 4 1 1 04-06-2019 4 2 2 30-09-2018 4 1 2 30-09-2018 2 2 3 01-10-2016 1 1 3 21-10-2016 3 2 3 04-06-2019 1 3 ... View more

Re: extract value of first variable containing specific value into a n...

by Fluorite | Level 6 in SAS Programming
‎01-24-2021 04:12 AM
‎01-24-2021 04:12 AM
There is a patteren.  What should I fill in where you typed "...", sorry. (I am very new to SAS, normally using SPSS).  array in ett_1-ett_5; array out ett_1-ett_5; do index=1 to dim(in); if in[index] =: 'ETTX' then out[count_ett]=input(substr(in[index],5),32.); else out[count_ett]=input(substr(in[index],4),32.2); end; run; ... View more

Re: extract value of first variable containing specific value into a n...

by Fluorite | Level 6 in SAS Programming
‎01-23-2021 05:31 PM
‎01-23-2021 05:31 PM
Thank you Tom !  The ETT code is a code for thickness in mm, where the numbers are mm from 0,01 mm to 20 mm: ETT001=0,01 mm ETT002=0,02 mm ... ETT100=1,00 mm  ...  ETT999= 9,99 mm ETTX10=10 mm  ETTX11= 11 mm ... ETTX20= 20 mm  Is it possible to convert the codes to mm ? ... View more

Re: extract value of first variable containing specific value into a n...

by Fluorite | Level 6 in SAS Programming
‎01-23-2021 02:23 PM
‎01-23-2021 02:23 PM
the code won't work. I've changed places in the code where I think you've made typos, but still won't work. See code, log and table ( I made a demo with only code_1 to code_4. I'm working on a secured server, so can't copy the SAScode directly in ).                            ... View more

extract value of first variable containing specific value into a new v...

by Fluorite | Level 6 in SAS Programming
‎01-23-2021 03:18 AM
‎01-23-2021 03:18 AM
I have a dataset with tons of material numbers who can have up to 44 codes each (all of 6 characters). I want to create new variables (ETT_1, ETT_2 and so on) which take the value of the codes starting with "ETT". Some of the materialnumbers can have >1 codes containing "ETT", why I have maked a count variable (count_ETT). So I should make a syntax for ETT_1 which says "if count_ETT=1 then ETT_1= the value of the first code (code_1-code_44) containing "ETT"), and a make a syntax for ETT_2 which says "if count_ETT=2 then ETT_2= the value of the second code (code_1-code_44) containing "ETT"). Is this possible??    Matnr Code_1 Code_2 Code_3 Code_4 … Code_44 count_ETT ETT.1 ETT.2 1 P40000 T98000 ETT800 T98000   ETT600 2 ETT800 ETT600 2 P70000 T30300 M87700 ETT600   T98000 1 ETT600   3 P33000 ETT600 M87710 T55500   T98000 1 ETT600   ... View more

Re: create new count variable

by Fluorite | Level 6 in SAS Programming
‎01-22-2021 04:39 PM
‎01-22-2021 04:39 PM
thanks for the syntax, it works perfectly. What should I add to syntax if I only want to count if another variable is a specific value (ex Gen=1)? Dataset want: ID Code_1 Code_2 Code_3 Code_4 Code_5 ...... Code_44 Gen Count_M87 1 M8700 T001 M8741 p0750 M9634 M8788 1 3 2 T001 M8741 M8788 p0750 T001 T001 ... View more

Re: create new count variable

by Fluorite | Level 6 in SAS Programming
‎01-21-2021 05:22 PM
‎01-21-2021 05:22 PM
No to the first rule. if M8700 occurs 5 times and M8741 occurs 2 times it should be counted as 7. yes to the second rule - it needs to be the specific value to be counted. In somehow yes - the M87XX is pathology codes for histotypes of melanoma. ... View more

create new count variable

by Fluorite | Level 6 in SAS Programming
‎01-21-2021 04:13 PM
‎01-21-2021 04:13 PM
I want to create a new variable (Count_M87) which count the occurrences of a group of specific value (ex. 'M8700', 'M8741', 'M8788', 'M87900') through 44 variables (Code_1-Code_44).  Dataset want (not illustrated all 44 code_ variables):    ID    Code_1    Code_2   Code_3    Code_4     Code_5 ......    Code_44     Count_M87 1      M8700         T001     M8741     p0750        M9634             M8788                3 2       T001           M8741   M8788     p0750        T001                T001                  2 ... View more

create new variable if one or more variables contain a specific value

by Fluorite | Level 6 in SAS Programming
‎01-20-2021 07:08 AM
‎01-20-2021 07:08 AM
I would like to make a variable "Diagn"=1 if Code_1 and/or Code_2 and/or Code_3 and/or Code_4 = M870 or M871 dataset with the desired new variable included:  ID Matnr Code_1 Code_2 Code_3 Code_4 Proc diagn 19 1 P200 T500 M870 500 1 19 2 P400 M872 500 20 1 P400 M872 700 20 2 P200 T800 T812 M871 700 1   ... View more

add one specific variable from one dataset to another dataset

by Fluorite | Level 6 in SAS Programming
‎01-20-2021 05:22 AM
‎01-20-2021 05:22 AM
How can I merge only one (or more specific) variables from one dataset (dataset 2) to another (dataset 1) without merging all variables from dataset 2 onto dataset 1 ? Dataset 1:  ID    Matnr     Code_1    Code_2     Code_3     Code_4 19     1             P200        T500        M870     19     2             P400        M871 20     1             P400       M871 20     2             P200       T800         T812           M871       Dataset 2:  ID    Matnr    Proc  City 19     1         500      AA  19     1         500      AA    19     2         500      AA     20     1         700      CP        20     2         700      CP 20     2         700     CP   Dataset 1 with only Proc added from dataset 2:  ID    Matnr     Code_1    Code_2     Code_3     Code_4    Proc 19     1             P200        T500        M870                         500 19     2             P400        M871                                          500  20     1             P400       M871                                           700                                           20     2             P200       T800         T812           M871       700          ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-05-2024 06:21 AM
Likes given to
Quick links