Hello SAS community. I am trying to extract a text segment based on a keyword from long, unstandardized text strings.  I need the text string to include 30 characters prior to the key word and 50 characters after the key word.  I am using the following code to do this.  The starting position of the extracted string appears to be accurate, but the end point varies dramatically.  I also get many warning notes in the log.  I've tried any number of parenthetical configurations around the FIND arguments to no avail.  Does anyone have any advice? [jobtext is the variable that I am searching through.  Experience is the key word that I'm looking for.]     extract= substr(jobtext,FIND(jobtext,"experience",'i')-20, FIND(jobtext,"experience",'i')+30); Thank you, Brandi ... View more

Hello SAS community. I am using PROC GLIMMIX for a 2-level, non-repeated measures, logit model.  I would like SAS to produce predicted probabilities for set values of a continuous variable (LMEXPROPI) for each value of a binomial variable (NATCTZN).  My question is: does the ilink option used with lsmeans account for the random effects in the model?  Below is the code that I am using.  Thanks for any help you can give! proc glimmix data= ipums.mex20072011_01_17_14; where year=2007; weight perwt; class oldstatefip natctzn; model moved (desc)= lnlpopn lmexpropi lc4prolaw lc4antilaw lnlavgwage lunempropi centerage lnftotinc child education English indvunemp natctzn lmexpropi*natctzn /dist=binary link=logit ddfm=bw solution residual; random intercept/subject= oldstatefip solution; lsmeans natctzn / om ilink cl; lsmeans natctzn / om ilink cl at lmexpropi=.01; lsmeans natctzn / om ilink cl at lmexpropi=.05; lsmeans natctzn / om ilink cl at lmexpropi=.1; lsmeans natctzn / om ilink cl at lmexpropi=.15; lsmeans natctzn / om ilink cl at lmexpropi=.2; lsmeans natctzn / om ilink cl at lmexpropi=.25; lsmeans natctzn / om ilink cl at lmexpropi=.3; run; ... View more