Hi , You can try the following if you can use the PROC SQL for your solution. data ds1; input ID $ ID2 $; cards; X C25 X C23 G C24 G C5 D C8 D C9 ; data ds2; input ID $ price1 price2 price3; cards; X .5 .9 1.4 G .6 .7 .9 D .4 1.3 .8 ; proc sql; create table ds3 as select * from ds1,ds2 where ds1.id = ds2.id; quit; Thanks, Amar Mundankar. ... View more

Hi CharlesR, You can also make use of substr() funtion. data have; input id; datalines; 107 204 508 359 ; run; data want; set have; length id2 $1; id2 = substr(put(id,best12.),1,1); put id2=; run; Thanks, Amar Mundankar. ... View more

Hi Lawrence, Try the following: data temp; input Visitno Room Bed InDate & $20.; datalines; 1234 1 1 JAN 1, 2011 1234 1 1 JAN 2, 2011 1234 5 2 JAN 3, 2011 1234 5 2 JAN 4, 2011 1234 5 2 JAN 5, 2011 1234 5 2 JAN 10, 2011 1234 1 1 JAN 11, 2011 1234 1 1 JAN 12, 2011 ; data first last; set temp; by room bed indate notsorted; if first.room = last.room then delete; if first.room then output first; if last.room then output last; run; data x; merge first last(keep = indate rename=(indate = lastdate)); run; Thanks, Amar Mundankar. ... View more