cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
knveraraju91
‎12-11-2023
  • 437 Posts
  • 445 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: how to calculate stat values and create a dataset

by Barite | Level 11 in SAS Programming
‎02-28-2017 12:43 AM
‎02-28-2017 12:43 AM
Thank you very much for the code. But why the median and range values are not calculated with the code. Do you any suggestion ... View more

how to calculate stat values and create a dataset

by Barite | Level 11 in SAS Programming
‎02-27-2017 09:34 PM
‎02-27-2017 09:34 PM
Dear,   I need help in my code to get the output i need to create a dataset for my table. Please help. Thank you.   I am calculating n, mean, median, range by variables test,visit,trt   data one; input id trt $ visit $ test $ bas val; datalines; 1 a wk1 pul 2 3 2 b wk1 pul 3 6 3 c wk1 pul 4 9 4 a wk1 pul 3 7 5 b wk1 pul 3 7 6 c wk1 pul 3 7 1 a wk1 bp 10 12 2 b wk1 bp 12 14 3 c wk1 bp 14 16 4 a wk1 bp 12 14 5 b wk1 bp 14 16 6 c wk1 bp 16 18 1 a wk2 pul 2 3 2 b wk2 pul 3 6 3 c wk2 pul 4 9 4 a wk2 pul 3 7 5 b wk2 pul 3 7 6 c wk2 pul 3 7 1 a wk2 bp 10 12 2 b wk2 bp 12 14 3 c wk2 bp 14 16 4 a wk2 bp 12 14 5 b wk2 bp 14 16 6 c wk2 bp 16 18 ; proc means data=one n mean sum range median min max; var val; class test visit trta; output out=two(keep=_stat_ trt visi test val where=(test='pul' and trt ^='' and visi ^='')); run; dataset output needed:   visit   trt   n   mean median min    max   SD wk1    a    2     5         5        3      7      2.82     wk1    b    2     6.5     6.5       6      7      0.7 wk1     c    2      8       8          7      9     1.4 wk2    a    2     5         5        3      7       2.82 wk2    b    2     6.5     6.5       6      7      0.7 wk2     c    2      8       8          7      9     1.4       Table output needed; wk1(pul)                                            a                                     b                                    c n                                          2                                     2                                   2 mean(SD)                              5(2.82)                            6.5(0.7)                           8(1.4) median                                  5                                     6.5                                 8 range(min,max)                      3, 7                                 6, 7                                7, 9   ... View more

Merging datasets where values of a variable become variables in outpu...

by Barite | Level 11 in SAS Programming
‎02-18-2017 01:29 PM
‎02-18-2017 01:29 PM
Dear,   I am merging the two datsets. I got the output I need by several datasteps. But i want to do a better way and reduce the code.Please suggest. Thank you   data one; input id seq; datalines; 1 1 1 2 2 2 2 3 3 1 4 2 5 4 ; data suppone; input id idvar $ nam $ val $; datalines; 1 1 act aaa 2 3 act aab 2 3 act1 bbb 3 1 act ccc 3 1 act1 cc1 3 1 act2 cc2 4 2 act ddd 5 4 act eee 5 4 act1 ee1 ;   /*The suppone dataset in split into multiple datasets by "nam" varibale*/ data act act1 act2 act3; set suppone; if nam='act' then output act; if nam='act1' then output act1; if nam='act2' then output act2; ; data sact; set act; seq=input(idvarval,best.); rename val=act; drop nam; run; Repeated the above step for all and then merged with dataone by id seq. output needed:   ID    seq    act     act1     act2 1       1     aaa 1       2 2       2 2       3     bbb      bb1 3       1     ccc       cc1       cc2 4       2    ddd 5      4     eee       ee1     ... View more

How to transpose data to get desired output data

by Barite | Level 11 in SAS Programming
‎02-15-2017 02:01 AM
‎02-15-2017 02:01 AM
Dear,   I need to transpose data one by phase, aebod,aede to create a table. My code works fine when there is no phase variable. Please suggest any option in my code to eliminate several data steps   data one; input phase $ aebod $ aede $ trt $ ns; datalines; s c b 15 1 s c p 30 1 t c p 15 3 t c p 30 3 t c p 17 3 ; output needed:   The dose values are prefixed with phase aebod    aede     t17    t15      t30    tT       s17     s15   s30    sT c             b           0     0        0    0           0         1        0     1 c             p           3     3        3     9          0         1        1      2 proc transpose data=NSWTEAEAEDECODD out=all(drop=_NAME_); by aebod aede; var NS; id TRT; run; data all1; set all; array data_17_mg _15_mg _30_mg; do over data; if missing(data) then data=0; end; TOTAL=_17_mg + _15_mg + _30_mg ; run; ... View more

How to calculate number of subject when several treatment periods are ...

by Barite | Level 11 in SAS Programming
‎02-15-2017 12:02 AM
‎02-15-2017 12:02 AM
Dear,   I am using following code to create macro variables for data one.     But my actual data contains three treatments (trt1,trt2,trt3) and I am repeating the code three times to calculate macro variables. Is there any other solution to simplify code for data two; The placebo values should not included in Total.   data one; input id trt1 $; datalines; 1 10 2 10 3 20 4 30 5 20 6 30 7 30 ; proc sql; create table NS as select count(distinct id) as NS,trt1 from one group by trt1; quit; data ns1; set ns; trt1=strip(trt1); if trt1='10' then trt='A'; if trt1='20' then trt='B'; if trt1='30' then trt='C'; run; data ns2; set ns1 end=done; Total + ns; output; if done; ns = TOTAL; trt='D'; trt1='Total'; output; drop Total; run; data _null_; set tnstfd11; call symputx(trt,ns); run;     data two; input id trt1 $; trt2 $ trt3 $ datalines; 1 10 20 30 2 10 30 20 3 20 10 place 4 30 10 place 5 20 30 place 6 30 20 place 7 30 20 place 8 10 30 20 ; ; ... View more

Re: How to exclude the blank OBS while calculating avg values

by Barite | Level 11 in SAS Programming
‎02-14-2017 11:59 AM
‎02-14-2017 11:59 AM
Hi,   Your code working but it gave output with  last OBS only. I added output statement in the code, but it missed the OBS with missing value.   data two; set one; by id; where bp^=.; if first.id then vsum=0; vsum+bp; output; if last.id then do; bp=vsum/ ifn(lag(_N_)=.,_n_,dif(_n_)); test='avg'; output; end; run;   output getting:   id    bp          test 1     86           db 1     80          db 1      83          dbavg   output needed;   id    bp          test 1     86           db 1     80          db 1      .            db 1      83          dbavg     ... View more

Re: How to exclude the blank OBS while calculating avg values

by Barite | Level 11 in SAS Programming
‎02-14-2017 11:43 AM
‎02-14-2017 11:43 AM
Thanks for the code. But I need to use my code as there are sveral other variables to be populated for this avg obs . Please suggest in my code.   eg: for my data output needed;   id    bp          test 1     86           db 1     80          db 1      .            db 1      83          dbavg ... View more

How to exclude the blank OBS while calculating avg values

by Barite | Level 11 in SAS Programming
‎02-14-2017 11:21 AM
‎02-14-2017 11:21 AM
Dear,   I am using the following code to get the avg values. I got the out put I need but please suggest any other function I can use.   Without this statement   "if bp ^=. then n+1" I am getting the output "avg=55.33" . With this statement added I got the out put I need avg=83. Please suggest any other soloution. Thank you   data one; input id bp; datalines; 1 80 1 86 1 . ;   data two; set one; by id; vsum+bp; if bp ^=. then n+1; if first.id then do; n=1; vsum=bp; end; output; if last.id then do; test='AVG'; bp=vsum/n; output; end; run; ... View more

How to increase a column width using proc report

by Barite | Level 11 in SAS Programming
‎02-10-2017 10:44 PM
‎02-10-2017 10:44 PM
Dear,   With my code I am getting the output with truncated last value. In the last value the parenthesis is missing. I tried several times didnot get fixed. Please suggest. Thanks.   output getting: Subjects with at Least One  07 ( 05.0) 04 ( 02.7) 08 ( 68.2) 06 ( 62.9) 02 ( 60.5) 030 ( 02.2   proc report data=one center headskip nowd missing split='|' style(report)={outputwidth=100% cellpadding=3 rules=groups frame=above} style(header)={font_weight=bold fontsize=10pt fontstyle=ROMAN} style(lines)={cellpadding=3 fontsize=3pt}; column aebodsys aedecod aetext cnt_pct6 cnt_pct1 cnt_pct2 cnt_pct3 cnt_pct4 cnt_pct5; define aebodsys/group noprint; define aedecod/group noprint; define aetext/"System Organ Class| Preferred Term, n (%) " style(column)={asis=on cellspacing=.25pt just=left width=10%} style(HEADER)={JUST=l} flow; define cnt_pct6/ "Placebo|N=&e" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow; define cnt_pct1/ "07.5 mg|N=&a" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow; define cnt_pct2/ "05 mg|N=&b" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow; define cnt_pct3/ "050 mg|N=&c" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow; define cnt_pct4/ "000 mg|N=&d" style(column)={cellspacing=.20pt just=left width=6%} style(HEADER)={JUST=l} flow ; define cnt_pct5/"Combined|OOO-000|N=&f" style(column)={cellspacing=.20pt just=left width=12%} style(HEADER)={JUST=l} flow; run; ... View more

Re: How to reduce number of rows in the proc transpose output

by Barite | Level 11 in SAS Programming
‎02-10-2017 09:50 PM
‎02-10-2017 09:50 PM
Thank you for the support. I should have sorted the dataset before transposing. After sorting I got the output needed with my code. Thank you for your code.   Thank you ... View more

How to reduce number of rows in the proc transpose output

by Barite | Level 11 in SAS Programming
‎02-10-2017 08:53 PM
‎02-10-2017 08:53 PM
Dear,   I need help in my proc transpose procedure to get output. I am not getting the output I need. Please help in my code.   data one; input trt $ aebod $ ns; datalines; a ca 4 b ca 6 e ca 2 d ca 4 c ge 4 e ge 7 a ge 6 ; proc transpose data=one out=two(drop=_NAME_); by aebod notsorted; var NS; id TRT; run; data three; set two; array data e a b c d; do over data; if missing(data) then data=0; end; TOTAL=a+ b+ c+ d; run; proc sort data=three; by aebod; run;   output getting:   aebod a b c d e Total ca      4 0 0 0 0 4 ca      0 6 0 0 0 6 ca      0 0 0 4 0 0 ca      0 0 0 0 2 0 ge      6 0 0 0 0 6 ge      0 0 0 0 7 0   output needed:   aebod a b c d e Total ca      4 6 0 4 2 14 ge      6 0 0 0 7 6 ... View more

Re: How to give different sub title names for two tables produced one ...

by Barite | Level 11 in SAS Procedures
‎02-09-2017 10:53 PM
‎02-09-2017 10:53 PM
Sorry. Here is  my code: Thank you very much for your time.   options nonumber noquotelenmax orientation=landscape topmargin=1in leftmargin=0.6in bottommargin=0.7in rightmargin=1in linesize=256; ods listing close; ods escapechar = '^'; ods rtf file="\Desktop\a.rtf" style=rtfstyle; title1 justify=right 'page ^{pageof}'; title2 "Table 1 Overall Summary of  (as) by oompliant and-oompliant Use of Therapy (Population)"; title3 justify=left "oompliant Use of a "; %let s = %sysfunc(repeat(%str(_), 149 )) ; footnote1 j=c h=1 "^S={fontstyle=ROMAN fontweight=bold}&s";   proc report data=all1 center headskip nowd missing split='|' style(report)={outputwidth=100% cellpadding=3 rules=groups frame=above} style(header)={font_weight=bold fontsize=9pt fontstyle=ROMAN} style(lines)={cellpadding=1 fontsize=3pt}; column text ont_oct6 ont_oct1 ont_oct2 ont_oct3 ont_oct4 ont_oct5; define text/ "Number (%) of Subjects with" style(column)={asis=on cellspacing=.2pt just=left width=25%} style(HEADER)={JUST=l} flow; define ont_oct6/ "Placebo|N=&e" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_oct1/ "07.5 mg|N=&a" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_oct2/ "05 mg|N=&b" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_oct3/ "050 mg|N=&c" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_oct4/ "000 mg|N=&d" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow ; define ont_oct5/"Combined|dd|N=&f" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; run;   proc report data=all2 center headskip nowd missing split='|' style(report)={outputwidth=100% cellpadding=3 rules=groups frame=above} style(header)={font_weight=bold fontsize=9pt fontstyle=ROMAN} style(lines)={cellpadding=1 fontsize=3pt}; column text ont_pct6 ont_pct1 ont_pct2 ont_pct3 ont_pct4 ont_pct5; define text/ oumber (%) of Subjects with" style(column)={asis=on cellspacing=.2pt just=left width=25%} style(HEADER)={JUST=l} flow; define ont_pct6/ "olacebo|N=&e" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_pct1/ "07.5 mg|N=&a" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_pct2/ "05 mg|N=&b" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_pct3/ "050 mg|N=&c" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; define ont_pct4/ "000 mg|N=&d" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow ; define ont_pct5/"0ombined|DD|N=&f" style(column)={cellspacing=.25pt just=left width=8%} style(HEADER)={JUST=l} flow; run; ods rtf close; ... View more

How to give different sub title names for two tables produced one ODS ...

by Barite | Level 11 in SAS Procedures
‎02-09-2017 09:50 PM
‎02-09-2017 09:50 PM
Dear, I am using the following code to produce two tables with first one on first two pages and second one in next two pages.   I need to put same mainheading title on both tables and different subtitle names   Also the subheading characters need to be just above the header line without gap. Please help. Thank you very much     title1 "MAIN HEADING"; title2 justify=left "subheading1"; title3  justify=left "subheading2";   ods rtf file="c:\temp\both_reports_one_file.rtf"; proc report data=a1 center headskip nowd missing split='|' style(report)={outputwidth=100% cellpadding=3 rules=groups frame=above} style(header)={font_weight=bold fontsize=9pt fontstyle=ROMAN} style(lines)={cellpadding=1 fontsize=3pt}; ** proc report data=a2 enter headskip nowd missing split='|' style(report)={outputwidth=100% cellpadding=3 rules=groups frame=above} style(header)={font_weight=bold fontsize=9pt fontstyle=ROMAN} style(lines)={cellpadding=1 fontsize=3pt}; ods rtf close;  outputneeded:                          MAIN HEADING sub heading1 _________________________________ _________________________________                            MAIN HEADING sub heading2 ________________________________ ________________________________      ... View more

how to calculate sum value for only a few rows of values

by Barite | Level 11 in SAS Programming
‎02-08-2017 12:41 PM
‎02-08-2017 12:41 PM
Dear,   In the following data I need to calculte a sum value for a few OBS.   For my data I need to calculate a total value for trt in (15,30,37).   data have; input ns trt $ trtc $; datalines; 20 15 A 30 30 B 10 37 C 50 Place D ; output needed; 20 15 A 30 30 B 10 37 C 50 Place D 60 Total E ; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-11-2023 01:43 PM
Likes given to
Likes from
View All
Quick links