Dear All, I have a dataset like posted below.  data one; input subjid sodium potassium bicarbonate glucose bloodureanitrogen creatinine SGPT SGOT GGT; cards; 01001 12.2 34.2 33.2 33 22 123 90 89 89.3 01002 13.2 34.2 32.2 23 33 234 45 34 23.2 ; run;    I would like to produce : subjid variable col1 01001 sodium  12.2 01001 potasium  34.2 01001 bicarbonate 33.2 01001 glucose 33 01001 .. .....  01002 Sodium 13.2 01002 potasium  34.2 01002 bicarbonate  32.2 01002 glucose... ........   i tried with proc transpose but didn't work, So below code i have used proc transpose data=one;  by subjid; var _all_; run; any suggestions?                 I would like to produce : subjid variable col1 01001 sodium  01001 sodium  01001 sodium  01001 sodium  01001 sodium  01002 potassium         ... View more

Hi everyone, I have a dataset below. for every subjid i have randno for only the baseline visit . i would like to carry forward that randno value both to screening and subsequent visits like 12weeks ,24weeks,32weeks. it has to be done like that by each subject id both upper row and below rows.    Data main; Input subjid visit randno; Cards 10001    screening            . 10001    baseline               90001 10001    12_weeks           . 10001    24_weeks           . 10002    screening            . 10002    baseline               90010 10002    12_weeks           . 10002    48_weeks           . 10003    screening            . 10003    baseline               90011 10003    12_weeks           . 10003    24_weeks           . 10003    36_weeks           . ; Run;     can you suggest what method would be appropriate to proceed? ... View more

Hi i have a table like below    data dummy; input subjid parcat $ AVAL; cards; 001 CA 5 001 CB . 001 CC . 002 DA 8 002 DB . 003 EA 9 003 EB . 003 EC . 003 ED . ; run;     i want to impute the values of 5 till the end of subjid 001 , similarly for imputation of value 8 for the subjid 002 and so on. any ideas how to go about doing it by retain statement or any other smooth procedure? ... View more

Hi everyone, I have a stored format.   proc format library=RECEIVE.DSTERM_DSDECOD ; value DSTERM 1='Adverse Event' 2='Protocol Nonompliance' 3='Lost to followup' 4='Investigator decision' 5='patient Withdrawn consent' 6='Death' 7='Ineligible' 8='Other'; run;   i would like to assign the character parts of this format to a new variable name DSDECOD but with UPPERCASE. I was thinking bout using upcase(), but don't know how to assign the character values to the DSDECOD variable. Is there any other efficient way out. Kindly help.    ... View more