hello,  I have this data and need to to add a period to the ID variable  to get  to this result "data want" Any thoughts? thank you.     data have; Id; datalines ID 40300 Z01 U900 303037 Z110112 917 3039 L303936 U30501 R00 305 U307G7 ;     data want ID 403 Z01 U90.0 303.037 Z11.0112 917 303.9 L30.3936 U30.501 R00 305 U30.7G7 ... View more

Hello, I have a dataset of patients who reported alcohol consumption during the last  3 months,see below What would be the most efficient  way of coding the patients into  three categories 1- No alcohol drink during the last 3 months 2-moderate  alcohol consumption ( those who reported drinking 25 glasses per month) 3-Excessive alcohol consumption ( those who reported drinking more than 25 glasses  per month    Thank you.     data alcohol;   input ID month1 month2 month3;   datalines; 30300 0 0 3 30301 3 3 6 30302 0 0 0 30303 10 35 35 30390 20 22 21 30391 0 0 0 30392 9 20 22 30393 67 90 45 30501 12 11 32 30500 4 12 19 30502 2 4 2 30503 1 2 2 ;           ... View more

hi, I have a character date variable  11292000  wich I would like to convert into 20001129. I used: data want ; set have ; newdate=input (olddate, yymmdd8. );  but the code does not work. any ideas? thanks     ... View more

  Hello, I have two datasets that I need to merge using the ID variable (Inmatesid)   DATA X   Inmatesid Race 03-000011ID 2 30-000211ID 3 193-004000ID 1 1903-022222ID 1 1903-001244ID 1 1903-001246ID 1 1903-1265790ID 5 1903-123457ID 2 1903-123456ID 2 1903-000055ID 4 1903-122000 2       DATA Y   Inmatesid Tatoo Security level 506-1903-000011 Yes 3 506-1903-000211 No . 506-1903-004000 Yes 1 506-1903-022222 Yes 2 506-1903-001244 Yes 4 506-1903-001246 No . 506-1903-126579 Yes 2 506-1903-123457 No 2 506-1903-123456 Yes 2 506-1903-000055 Yes 3 506-1903-002222 Yes 1 506-1903-011123 No 5 506-1903-122000 Yes 5   My first task  was  to standardize  inmate ID  in both datasets so that 1903-000055ID =>1903-000055    (data x) 506-1903-000055 =>1903-000055  (data y)   1) for data  x,  I used inmatesid=compress(inmatesid, ' ', 'I'); 2) data y,  i used   Inmatesid=trim(left(substr(Inmatesid, index(Inmates id, '-')+1)));    the first issue I have is that  there are some typos for inmatesid (for example  03-000011ID) in data x,  which  does not work well with that above code. so I manually tried to fix  the ID's that were not transformed properly; I will  be curious to know  how to  do this using a  code .   Then I tried to merge the two data sets but I am getting this error. Does anybody know how to debbug this error. Thanks   WARNING: Multiple lengths were specified for the BY variable Inmatesid by input data sets and LENGTH,          FORMAT, INFORMAT, or ATTRIB statements. This may cause unexpected results. WARNING: Multiple lengths were specified for the variable Inmatesid by input          data set(s). This may cause truncation of data ... View more