I have a dataset and am trying to split it by the presence of a keyword in a variable string.   data b c;     set a;     if find(school, "ELEMENTARY") then output b;     else output c; run;   I am getting duplications in my dataset b (not all but a few observations are duplicating), none in dataset c. What am I doing wrong? ... View more

I have a string with names with varying formats:   name First middle_initial last first middle last first middle_initial last   I need to extract first and last names into separate variables, but the name may have 2 first names, ie "mary ann l smith" in which case I need the new variables to read: first               last mary ann      smith   or 2 last names such as "mary l smith jones, which would read first              last mary            smith jones   How can I do this taking into acount the names may or may not have a middle initial? none of the names would have a letter count of less than 2, so I feel like that would be my best bet? Perhaps 2 if statements depending on if there is a middle initial or not.. ... View more

I have the below SAS code for a data with 2 groups (tx and control), time (continuous - including baseline at 0), and 2 covariates (cov1 is dichotomous and cov2 is continuous).   proc mixed data=dat;     class id tx (ref='0') cov1 (ref='0');     model y=time|tx cov1 cov2/s cl noint;     random intercept time/type=un sub=id;         estimate 'Control rate' time 1 time*tx 0 1/cl;         estimate 'Tx rate' time 1 time*tx 1 0/cl;         lsmeans tx /at time=0 cl; run;   When I look at the lsmeans output, I see that it is forcing time to be 0 and cov2 to be some value that is the same for both tx levels, cov1 is not in the output. What is the value that lsmeans is setting cov2 to and why is cov1 omitted? How can I interpret this? My intention is to get the mean estimates of y at each tx at baseline (time=0) while adjusting for differences in cov1 and cov2.     ... View more

I have a single group with incidence pre and post some intervention. The populations are different pre and post but I am not sure how to account for this in my analysis. ... View more

I have a dataset that I want to remove the trailing zeros for all decimal numeric variables. Is there any easy way to do this? I used the best and it did not work. ... View more

I have a dataset with patients with at least 2 observations - observed longitudinally. I would like to turn this into an independent dataset as below. What is the most efficient way to do this?     OLD:   ID    YEAR 1        1980 1        1990 2        1975 2        1980 2        1985     NEW:   ID    YEAR     YEARS_UNTIL_2ND  YEARS_UNTIL_LAST      NUM_OBS 1     1980                10                                  10                             2                    2     1975                 5                                   10                             3   ... View more