Hi all,   I have a variable called subject_ID composed of Site ID (first one or two number are Site and the last 4 digits are subject ID) and  saved as text and I want to add a "-" in between, like 12-0006, 9-0011 or 22-0001 for example, any idea is greatly appreciated!   Subject_ID 120006 120004 120003 120002 120005 90011 90010 90006 90001 90009 220001 220019 220017 ... View more

I have a date of birth variable (brthdtc) saved as text with data captured as 1947/02 (yyyy/mm) and I want to convert it to numeric date as 1947-02-15 (use 15 as convention), does anyone know how to do this? ... View more

  Hi Community,   I want to do a while loop to scan the variables 01 - 09 and if all of them is 'yes' then the last column will be populated as 'yes', otherwise if ther eis one 'no' then the last column will be populated as 'no' usubjid ieorres_incl01 ieorres_incl02 ieorres_incl03 ieorres_incl04 ieorres_incl05 ieorres_incl06 ieorres_incl07 ieorres_incl08 ieorres_incl09 Inclusion 1001 yes yes yes yes yes yes yes yes yes   1002 yes yes yes yes yes yes yes yes yes   1003 yes yes yes yes yes yes yes yes yes   1004 yes yes yes yes yes yes yes yes yes   1005 yes yes yes yes yes yes yes yes yes   ... View more

  Hi Community,   I have a dataset looks like below: apple  fruits apple  fruits apple  fruits apple  fruits apple  vegetables apple  fruits artichoke vegetables artichoke vegetables asparagus vegetables asparagus vegetables broccoli  vegetables broccoli  vegetables carrots vegetables eggplant vegetables eggplant fruits orange fruits orange fruits orange fruits orange fruits orange fruits orange fruits pear vegetables pear fruits pear fruits pear fruits pear fruits pear fruits pepper vegetables pepper fruits   I want to fish out the items which have been assigned as the wrong category as below apple  vegetables apple  fruits eggplant vegetables eggplant fruits pear vegetables pear fruits pepper vegetables pepper fruits   Is there any effective way to do this?   Thanks you! ... View more