Hi all,'ve got the next dataset (have): data have; length subjid 8 color1 color2 $20; input subjid $ color1 $ color2; datalines; 1 blue       blue 2 red       grey  3 yellow   blue 4 green     green 5 black     yellow 6 white     pink 7 purple    yellow ; run; I am interested to create a final dataset (want) like this: color2    other blue     blue grey     green   green yellow  yellow pink   as you can see I am interested to know which color in (color2) has been assigned to (color1), and which color in (color2) cant be assigned to (color 1) because  are different (blanck values)...in this example would be grey and pink. Thanks in advance, V. ... View more

Hi everyone, I've got the next dataset (have), and I would like to generate a dataset (want) populating the RESPONSE variable with the LOCF (capital in my final dataset (want)), rather than no change: Any help? Thnaks in advance. V. data have; length subjid visit 8. sys response $10; input subjid visit $ sys $ response; datalines; 1 1 body normal      1 2 body abnormal   1 3 body no change 1 1 heart normal 1 2 heart no change 1 3 heart no change 2 1 body  normal 2 2 body  abnormal 2 3 body  no change 2 4 body  no change 2 5 body  no change 2 6 body  no change 2 7 body  normal 2 1 heart not done 2 2 heart normal 2 3 heart no change ; run; This is the dataset WANT I would like to create (notice now than the no change values has been changed by the LOCF records)  ; 1 1 body normal      1 2 body abnormal   1 3 body ABNORMAL 1 1 heart normal 1 2 heart NORMAL 1 3 heart NORMAL 2 1 body  normal 2 2 body  abnormal 2 3 body  ABNORMAL 2 4 body  ABNORMAL 2 5 body  ABNORMAL 2 6 body  ABNORMAL 2 7 body  normal 2 1 heart not done 2 2 heart normal 2 3 heart NORMAL ; run; ... View more

Hi guys, anyone can help me to simplify my code in the way to format my final dataset want?...maybe using loops rather than write down by hand the 4 combinations (class/type)? data new; input name  class $ type $; datalines; 1 a yes 2 a no 3 a yes 4 b no 5 b yes 6 a  yes 7 b no 8 b no 9 b yes 10 a yes 11 a yes ; run; *creating macrovariables; proc sql noprint; select count(distinct name) into: safea from new where class='a'; quit; proc sql noprint; select count(distinct name) into: safeb from new where class='b'; quit; %put &safea; %put &safeb; proc sql noprint; create table test as select distinct class, type, count(distinct name) as n from new group by class,type; quit; *creating the format of my want dataset; data want; set test; if class='a' and type='yes' then nc=put(n,best12.)||'('||put(n/&safea*100,5.1)||')'; if class='a' and type='no' then nc=put(n,best12.)||'('||put(n/&safea*100,5.1)||')'; if class='b' and type='yes' then nc=put(n,best12.)||'('||put(n/&safeb*100,5.1)||')'; if class='b' and type='no' then nc=put(n,best12.)||'('||put(n/&safeb*100,5.1)||')'; drop n; run; Thanks V. ... View more

Hi everyone, I have these two datasets: data have1; input week $ ord count; datalines; week1 1 2 week2 1 3 week3 1 4 week4 1 3 week5 1 5 ; run; data have2; input week $ ord count; datalines; week1 2 1 week3 2 3 week4 2 4 ; run; I want to obtain the final dataset (you can see, I want to keep the same structure in ord=2 that I have for ord=1): week1 2 1 week2 3 1 week3 4 1 week4 3 1 week5 5 1 week1 1 2 week2 0 2 week3 3 2 week4 4 2 week5 I think CLASSDATA would do this job, but I do not remember How to apply to this particular problem. Thank you. V. ... View more

Hi everyone, anyone can help me with this?; I I have got the dataset have, and I want to convert it in a dataset want , please find below *; data have;   input subjid siteid param $ response $;   datalines;   1 100 u a   1 100 v a   1 100 w a   1 100 u b   1 100 v b   1 100 w b   2 200 u a   2 200 v a   2 200 w a   3 300 u a   3 300 v a   3 300 w a   3 300 u b   3 300 v b   3 300 w b   ;   run; I would like this kind of dataset want, with this structure *:                        response a           response b site 100                                         u  v  w                            u                            v                           w site 200              u                           v                          w site 300             u                          v                         w Thanks in advance, V. ... View more