Hi all,   I am trying to concatenate three date variables into a single numeric date value. The separate variables are day, month, and year. I am trying to concatenate the three variables into a single numeric date value and am struggling. I am wondering if I am using the wrong informat or if I am  nesting my functions inappropriately. Here is my code:   DATA WORK.Want; SET Work.Have; BirthDt = INPUT(CAT(BirthMonth, BirthDay, BirthYear), ANYDTDTE9.); RUN; Thank you for the help! ... View more

Hi all,   I'm trying to create a new variable for height in inches. I want to convert an existing character variable in the format feet:inches (04:11 for example) to a numeric variable in inches (such as 59).  I am using SAS Studio.   I keep getting this error in my log:   Here is my code: DATA lab.study_cohort_2; FORMAT race_eth $30.; SET lab.study_cohort; /*Calculate BMI and create categories*/ /*FIRST convert height to inches*/ IF MotherHeight = '?' THEN Ht_Inches = 0; ELSE Ht_Inches = (INPUT(SUBSTR(MotherHeight,1,2)3.0)*12) + (INPUT(SUBSTR(MotherHeight,4,2)3.0)); RUN; I am new to SAS and am grateful for some help.   Thanks!   ... View more