Changing the data format Example: Date 19431010 Change Date to: 10/10/1943(mm/dd/yyyy) ... View more

Hi, I have a dataset ID   SubID  Name 1       20       car 1       20       dog 1       20       deer 2      32       fox 2      32        goat   I want to concatenate the Name with comma. ID         SubID        Name 1           20             car, dog, deer 2           32             fox, goat   thank you. ... View more

Hi, I have a dataset ID  Sub_ID      Date 1      23        2020-06-01 1      24        2019-06-02 2      29        2015-05-04 2      33        2012-06-09 2      31        2014-09-09   I want to select the earliest Date of the SubID. ID    SubID         Date 1       24          2019-06-02 2       33          2012-06-09   Can I do this is SAS? thanks in advance. ... View more

  Hi, I have the below SQL script and I want to run in SAS. I have zero knowledge in SQL. Could you help me how to do it in SAS? thanks.   select * from try..a_RAW; 　 select distinct '11111' as ID , a.SUBJID , b.DOB_M || '/' || b.DOB_D || '/' || b.DOB_Y as DOB -- study team need DOB , a.car as type , a.g6m as month , a.g2yr as 24month , a.g1yr as 12month , a.g10yr as decade from try..a_RAW a join try..FINAL b on b.ID = '11111' and a.SNO = b.SNO ; 　 ... View more

Hi, I have a Dataset ID     A       B       C 1      10     11      12 2      20    21      22 3      30    31      32   I want the dataset same ID grouped like below : ID   want 1     10 1     11 1     12 2     20 2     21 2    22 3    30 3    31 3    32   Can I do this in SAS? thanks ... View more

Hi, I have a SQL code and I havent worked on SQL before. Can I run the SQL code in SAS? Are there any rules to run? ... View more

Hi, Data A: ID      Date1         Date 2              Date3 1    20180409     20150506      20140203 2    20170607     20180607     20170607 3   20150809       .                   20150810   I want: ID        TRT 1     20140203 ( I want the earliest date to be selected out of 3 dates) 2     20170607  ( I want earliest and more treatment dates) 3     20150809  ( earliest date selected)   Can I do this is SAS?   thank you. ... View more

I want a code which uses phrase "not missing" or something similar to remove the missing values. Data A: ID total 1     12 2      . 3     14 4     16 5      . Data Want: I want the code with using "not missing" 1   12 3   14 4   16       ... View more

I want to code Treatment=0; when variable "A" is "None; hormone therapy not part of planned first course; autopsy only" else Treatment=1;   please help me in this.   thanks ... View more

Hi, I have no idea of R-programming, I want to understand this script in SAS. Could you help me out.   #--------------------------------------------------------------------------# dt3 <- dt2 %>% mutate(Race_Ethnicity = case_when(    FirstRace %in% c('American Indian/Black', 'Black', 'Black/White') ~ 'Black'    ,Ethnicity == 'Hispanic or Latino' & !(FirstRace %in% c('American Indian/Black', 'Black', 'Black/White')) ~ 'HispanicLatino'    ,FirstRace %in% c('White', 'Middle Eastern') & Ethnicity != 'Hispanic or Latino' ~ 'White'    ,FirstRace %in% c("Asian", "Oriental", "American Indian/Asian", "Asian/White", "American Indian/White") & Ethnicity != 'Hispanic or Latino' ~ "Asian"    ,FirstRace %in% c("*Unknown", "American Indian/Alaska Native","Decline", "Do Not Know", "Multi-Racial" ,                      "Native Hawaiian/Pacific Islande", "Other", "Z") & Ethnicity != 'Hispanic or Latino' ~ 'Other_Unknown'    ,TRUE ~ "Other_Unknown" #some missing value    )) dt3$FirstRace[dt3$FirstRace %in% c("*Unknown", "Do Not Know", "Decline")] <- "Unknown"     thanks ... View more

Hi I would like to change the two different date formats Old: 2018-02-16     New: 20180216 Old:01FEB2018     New: 20180201    I hope this works in SAS.   thanks ... View more