Hi All,   I am trying to resolve the macro variable in the define statement in proc report in order to generate treatment count and name in the tables with below code but the code is not resolving. Can you please help me out to resolve &trt01count. and &trt01.   proc sql; select trtseqp into:trt01 from bign_counts where trtseqpn = 1 ; select count into:trt01count from bign_counts where trtseqpn = 1 ; quit; %put &trt01count; %put &trt01; proc report data=final_tp nowd spacing=1 LS = 200 headline headskip split='|' panels=1 style(header)=header{just=left} style(column)=header{just=left cellwidth=0.3in } missing; title1 bold "Table 1.6 Disc Test"; title2 bold "All Enrolled Subjects" ; columns popfl _1 _2 _999; define popfl / order order=internal left ' ' style ={just=left cellwidth=.47in}; define _1 / order order=internal left '&trt01.|N=&trt01count.|n(%)' style ={just=left cellwidth=.28in} ; define _2 / order order=internal left '&trt02.|N=&trt02count.|n(%)' style ={just=left cellwidth=.28in} ; *by pageit; compute before _page_/style = [JUST=center]; line '^R"\brdrb\brdrs"'; line ''; endcomp; compute after _page_ / style = [JUST=LEFT font_size =9pt font_style=italic];; line " " ; line "Created by %sysfunc(getoption(sysin)) on %left(&rundayf):%left(&runtimef)"; line "Reference: Transfer ID: &_transfer_id. on %left(&_extract_date)"; endcomp; run;     Thanks, Kumar. ... View more

Hi All, I am trying to create below output for variable ADY with attached program but I got something different values. Can anyone please help on this. Required output: subjid avisit ady_orig ady 001 1-week 6 0 001 1-month 27 21 001 3-month 90 63 (63 = 90-21+6) 001 6-month 180 90 (90 = 180- 63-21+6)   Program Used: data od; set od(rename=(ady = ady_orig)); by studyid usubjid avisitn avisit adtm ady_orig epoch alat; retain ADY; if first.usubjid then ADY = ADY_ORIG; else ADY = ADY_ORIG - ADY; run;   Thanks, Kumar. ... View more

By using the below code I am trying to create 2 records. First record should be "JG" and other has to be "VC", but I only get "JG" in 2 records. Can you help me how to create this.   data sub1; subj = "201"; armcd = "JGVC"; run; %let k =1; data sub2; set sub1; armlen = length(armcd); do i = 1 to armlen/2; length split_armcd $200; split_armcd = substr(armcd,&k.,2); split_armcdn = i; %let k=%eval(&k + 2); output; end; run;   Thanks, Kumar. ... View more

In my input dataset I do have a 28 variables which are corresponding to each other like Left10a, Right10a, Left11a, Right11a......................Left24a, Right24a.   I need to compare its corresponding variables like Left10a & Right10a and create a new variable design10 by using do loop/arrary/something because tomorrow the maximum count of 24 may increase to 30.   I tried with below code but its only working for single iteration which is i =10. Please help me how do loop have to work till 24 iterations. Also suggest me is there any other way I can do to create 14 new variables.   Thanks for your time.   data count; set count2; %let i = 10; do i = &i. to 24; if left&i.a ne "" and righ&i.a ne "" then do;         if left&i.a ^=  righ&i.a then design&i. = "NOT EQUAL"; else if left&i.a   = righ&i.a then design&i. = "EQUAL"; end; %let i=%eval(&i + 1); end; run;   Regards, Kumar. ... View more