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: 
sam369
‎01-10-2023
  • 172 Posts
  • 18 Likes Given
  • 1 Solutions
  • 35 Likes Received

Re: Check the dates in loop

by Obsidian | Level 7 in SAS Procedures
‎11-07-2014 08:08 PM
‎11-07-2014 08:08 PM
yes!!! beginning date. in original data beginning date is not missing for both dataset Thanks Sam ... View more

Re: Check the dates in loop

by Obsidian | Level 7 in SAS Procedures
‎11-07-2014 07:21 PM
‎11-07-2014 07:21 PM
Hi Arthur, Thanks for you help... I applied your code and still some glitch I changed temp dataset which resembles to my original data data temp; informat dstdt  dendt date9.; format dstdt    dendt date9.; input subjid dstdt  dendt; cards; 100 25OCT2013 17MAR2014 100 18MAR2014 28APR2014 101 11OCT2013 . ; run; find the output                           subjid      STDT         ENDT       flag flg                             100     02OCT2013    08OCT2013     N N                             100     09OCT2013    15OCT2013     N N                             100     16OCT2013    22OCT2013     N N                             100     23OCT2013    29OCT2013     Y Y                             100     30OCT2013    05NOV2013     Y Y                             100     06NOV2013    12NOV2013     Y Y                             100     13NOV2013    19NOV2013     Y Y                             100     20NOV2013    26NOV2013     Y Y                             100     27NOV2013    03DEC2013     Y Y                             100     04DEC2013    10DEC2013     Y Y                             100     11DEC2013    17DEC2013     Y Y                             100     18DEC2013    24DEC2013     Y Y                             100     25DEC2013    31DEC2013     Y Y                             100     01JAN2014    07JAN2014     Y Y                             100     08JAN2014    14JAN2014     Y Y                             100     15JAN2014    21JAN2014     Y Y                             100     22JAN2014    28JAN2014     Y Y                             100     29JAN2014    04FEB2014     Y Y                             100     05FEB2014    11FEB2014     Y Y                             100     12FEB2014    18FEB2014     Y Y                             100     19FEB2014    25FEB2014     Y Y                             100     26FEB2014    04MAR2014     Y Y                             100     05MAR2014    11MAR2014     Y Y                             100     12MAR2014    18MAR2014     Y Y                             100     19MAR2014    25MAR2014     Y Y                             100     26MAR2014    01APR2014     Y Y                             100     02APR2014    08APR2014     Y Y                             101     24SEP2013    30SEP2013     N N                             101     01OCT2013    07OCT2013     N N                             101     08OCT2013    14OCT2013     Y N                             101     15OCT2013    21OCT2013     N N                             101     22OCT2013    28OCT2013     N N                             101     29OCT2013    04NOV2013     N N                             101     05NOV2013    11NOV2013     N N                             101     12NOV2013    18NOV2013     N N                             101     19NOV2013    25NOV2013     N N                             101     26NOV2013    02DEC2013     N N                             101     03DEC2013    09DEC2013     N N                             101     10DEC2013    16DEC2013     N N                             101     17DEC2013    23DEC2013     N N                             101     24DEC2013    30DEC2013     N N                             101     31DEC2013    06JAN2014     N N                             101     07JAN2014    13JAN2014     N N                             101     14JAN2014    20JAN2014     N N                             101     21JAN2014    27JAN2014     N N                             101     28JAN2014    03FEB2014     N N                             101     04FEB2014    10FEB2014     N N                             101     11FEB2014    17FEB2014     N N                             101     18FEB2014    24FEB2014     N N                             101     25FEB2014    03MAR2014     N N                             101     04MAR2014    10MAR2014     N N                             101     11MAR2014    17MAR2014     N N                               101     18MAR2014    24MAR2014     N N                             101     25MAR2014    31MAR2014     N N Thanks Sam ... View more

Re: Check the dates in loop

by Obsidian | Level 7 in SAS Procedures
‎11-07-2014 05:57 PM
‎11-07-2014 05:57 PM
Hi Arthur, i Changed dataset in proc transpose dataset instead of have i changed to temp, Something is going wrong with this code, 101 subject doesn't have  dendt  is missing and dstdt :11OCT2013 but code is considering the subj 100 dendt and dstdt proc transpose data=temp out=formerge1  prefix=_dstdt;   var dstdt;   by subjid; run; proc transpose data=temp out=formerge2  prefix=_dendt;   var dendt;   by subjid; run; data formerge;   set formerge1;   set formerge2; run; data want;   merge temp formerge;   by subjid;   array temp1(*) _dstdt:;   array temp2(*) _dendt:;   i=0;   do until (eof2);     set have end=eof2;     flg='N';     do i=1 to dim(temp1);       if STDT <= temp1(i) < ENDT then do;         if (temp1(i) <= temp2(i) < ENDT) or (temp2(i) >= ENDT) then flg='Y';       end;       if  temp1(i) < STDT then do;         if (STDT <= temp2(i) < ENDT) or (temp2(i) > ENDT) then flg='Y';       end;       if flg eq 'Y' then leave;     end;     output;   end; run; output: subjid      dstdt        dendt        STDT         ENDT       flg                    100     25OCT2013    17MAR2014 02OCT2013    08OCT2013     N 100     25OCT2013    17MAR2014 09OCT2013    15OCT2013     N 100     25OCT2013    17MAR2014 16OCT2013    22OCT2013     N                    100 25OCT2013    17MAR2014    23OCT2013 29OCT2013     Y 100     25OCT2013    17MAR2014 30OCT2013    05NOV2013     Y 100     25OCT2013    17MAR2014 06NOV2013    12NOV2013     Y 100     25OCT2013    17MAR2014 13NOV2013    19NOV2013     Y 100     25OCT2013    17MAR2014 20NOV2013    26NOV2013     Y 100     25OCT2013    17MAR2014 27NOV2013    03DEC2013     Y 100     25OCT2013    17MAR2014 04DEC2013    10DEC2013     Y 100     25OCT2013    17MAR2014 11DEC2013    17DEC2013     Y 100     25OCT2013    17MAR2014 18DEC2013    24DEC2013     Y 100     25OCT2013    17MAR2014 25DEC2013    31DEC2013     Y 100     25OCT2013    17MAR2014 01JAN2014    07JAN2014     Y 100     25OCT2013    17MAR2014 08JAN2014    14JAN2014     Y 100     25OCT2013    17MAR2014 15JAN2014    21JAN2014     Y 100     25OCT2013    17MAR2014 22JAN2014    28JAN2014     Y 100     25OCT2013    17MAR2014 29JAN2014    04FEB2014     Y 100     25OCT2013    17MAR2014 05FEB2014    11FEB2014     Y 100     25OCT2013    17MAR2014 12FEB2014    18FEB2014     Y 100     25OCT2013    17MAR2014 19FEB2014    25FEB2014     Y 100     25OCT2013    17MAR2014 26FEB2014    04MAR2014     Y 100     25OCT2013    17MAR2014 05MAR2014    11MAR2014     Y 100     25OCT2013    17MAR2014 12MAR2014    18MAR2014     Y 100     25OCT2013    17MAR2014 19MAR2014    25MAR2014     Y 100     25OCT2013    17MAR2014 26MAR2014    01APR2014     Y 100     25OCT2013    17MAR2014 02APR2014    08APR2014     Y 101     25OCT2013    17MAR2014 24SEP2013    30SEP2013     N                    101     25OCT2013    17MAR2014 01OCT2013    07OCT2013     N 101     25OCT2013    17MAR2014 08OCT2013    14OCT2013     N 101     25OCT2013    17MAR2014 05OCT2013    21OCT2013     N                    101     25OCT2013    17MAR2014 22OCT2013    28OCT2013     Y 101     25OCT2013    17MAR2014 29OCT2013    04NOV2013     Y 101     25OCT2013    17MAR2014 05NOV2013    11NOV2013     Y 101     25OCT2013    17MAR2014 12NOV2013    18NOV2013     Y 101     25OCT2013    17MAR2014 19NOV2013    25NOV2013     Y 101     25OCT2013    17MAR2014 26NOV2013    02DEC2013     Y 101     25OCT2013    17MAR2014 03DEC2013    09DEC2013     Y 101     25OCT2013    17MAR2014 10DEC2013    16DEC2013     Y 101     25OCT2013    17MAR2014 17DEC2013    23DEC2013     Y 101     25OCT2013    17MAR2014 24DEC2013    30DEC2013     Y 101     25OCT2013    17MAR2014 31DEC2013    06JAN2014     Y 101     25OCT2013    17MAR2014 07JAN2014    13JAN2014     Y 101     25OCT2013    17MAR2014 14JAN2014    20JAN2014     Y 101     25OCT2013    17MAR2014 21JAN2014    27JAN2014     Y 101     25OCT2013    17MAR2014 28JAN2014    03FEB2014     Y 101     25OCT2013    17MAR2014 04FEB2014    10FEB2014     Y 101     25OCT2013    17MAR2014 11FEB2014    17FEB2014     Y 101     25OCT2013    17MAR2014 18FEB2014    24FEB2014     Y 101     25OCT2013    17MAR2014 25FEB2014    03MAR2014     Y 101     25OCT2013    17MAR2014 04MAR2014    10MAR2014     Y 101     25OCT2013    17MAR2014 11MAR2014    17MAR2014     N 101     25OCT2013    17MAR2014 18MAR2014    24MAR2014     Y 101     25OCT2013    17MAR2014 25MAR2014    31MAR2014     Y Thanks Sam ... View more

Re: Check the dates in loop

by Obsidian | Level 7 in SAS Procedures
‎11-07-2014 05:27 PM
‎11-07-2014 05:27 PM
Hi Arthur, I tried your approach, but almost every flag is 'Y' , did i miss something i got unexpected output: subjid      STDT         ENDT       flg 100     02OCT2013    08OCT2013     Y 100     09OCT2013    15OCT2013     Y 100     16OCT2013    22OCT2013     Y 100     23OCT2013    29OCT2013     Y 100     30OCT2013    05NOV2013     Y 100     06NOV2013    12NOV2013     Y 100     13NOV2013    19NOV2013     Y 100     20NOV2013    26NOV2013     Y                                 100 27NOV2013    03DEC2013     Y 100     04DEC2013    10DEC2013     Y 100     11DEC2013    17DEC2013     Y 100     18DEC2013    24DEC2013     Y                                 100     25DEC2013    31DEC2013     Y 100     01JAN2014    07JAN2014     Y 100     08JAN2014    14JAN2014     Y 100     15JAN2014    21JAN2014     Y 100     22JAN2014    28JAN2014     Y 100     29JAN2014    04FEB2014     Y 100     05FEB2014    11FEB2014     Y 100     12FEB2014 18FEB2014     Y 100     19FEB2014    25FEB2014     Y 100     26FEB2014    04MAR2014     Y 100     05MAR2014    11MAR2014     Y 100     12MAR2014    18MAR2014     Y 100     19MAR2014    25MAR2014     Y 100     26MAR2014    01APR2014     Y 100     02APR2014    08APR2014     Y 101     24SEP2013    30SEP2013     N 101     01OCT2013    07OCT2013     Y 101     08OCT2013    14OCT2013     Y 101     05OCT2013    21OCT2013     Y 101     22OCT2013    28OCT2013     Y 101     29OCT2013    04NOV2013     Y   101 05NOV2013    11NOV2013     Y 101     12NOV2013    18NOV2013     Y 101     19NOV2013    25NOV2013     Y 101     26NOV2013    02DEC2013     Y   101     03DEC2013    09DEC2013     Y 101     10DEC2013    16DEC2013     Y 101     17DEC2013    23DEC2013     Y I applied your piece of code!!!! am i missing something? Thanks Sam ... View more

Re: Check the dates in loop

by Obsidian | Level 7 in SAS Procedures
‎11-07-2014 03:14 PM
‎11-07-2014 03:14 PM
Hi Arthur, Thank you so much for the help. It work for sample code , not accommodated on real one. I am keeping another loop to pass individual subjects and appending the dataset. i have more than 1500 unique subjid. data have; informat STDT   ENDT date9.; format STDT     ENDT date9.; input subjid STDT ENDT; cards; 100 02Oct2013  08Oct2013 100 09Oct2013  15Oct2013 100 16Oct2013  22Oct2013 100 23Oct2013  29Oct2013 100 30Oct2013  05Nov2013 100 06Nov2013  12Nov2013 100 13Nov2013  19Nov2013 100 20Nov2013  26Nov2013 100 27Nov2013  03Dec2013 100 04Dec2013  10Dec2013 100 11Dec2013  17Dec2013 100 18Dec2013  24Dec2013 100 25Dec2013  31Dec2013 100 01Jan2014  07Jan2014 100 08Jan2014  14Jan2014 100 15Jan2014  21Jan2014 100 22Jan2014  28Jan2014 100 29Jan2014  04Feb2014 100 05Feb2014  11Feb2014 100 12Feb2014  18Feb2014 100 19Feb2014  25Feb2014 100 26Feb2014  04Mar2014 100 05Mar2014  11Mar2014 100 12Mar2014  18Mar2014 100 19Mar2014  25Mar2014 100 26Mar2014  01Apr2014 100 02Apr2014  08Apr2014 101 24Sep2013  30Sep2013 101 01Oct2013  07Oct2013 101 08Oct2013  14Oct2013 101 5Oct2013   21Oct2013 101 22Oct2013  28Oct2013 101 29Oct2013  04Nov2013 101 05Nov2013  11Nov2013 101 12Nov2013  18Nov2013 101 19Nov2013  25Nov2013 101 26Nov2013  02Dec2013 101 03Dec2013  09Dec2013 101 10Dec2013  16Dec2013 101 17Dec2013  23Dec2013 101 24Dec2013  30Dec2013 101 31Dec2013  06Jan2014 101 07Jan2014  13Jan2014 101 14Jan2014  20Jan2014 101 21Jan2014  27Jan2014 101 28Jan2014  03Feb2014 101 04Feb2014  10Feb2014 101 11Feb2014  17Feb2014 101 18Feb2014  24Feb2014 101 25Feb2014  03Mar2014 101 04Mar2014  10Mar2014 101 11Mar2014  17Mar2014 101 18Mar2014  24Mar2014 101 25Mar2014  31Mar2014 ; run; data temp; informat dstdt  dendt date9.; format dstdt    dendt date9.; input subjid dstdt  dendt; cards; 100 25OCT2013 17MAR2014 100 18MAR2014 28APR2014 101 11OCT2013    . ; run; want: SUBJID STDT         ENDT       FLG 100     02OCT2013    08OCT2013     N 100     09OCT2013    15OCT2013     N 100     16OCT2013    22OCT2013 N 100     23OCT2013    29OCT2013     Y 100     30OCT2013    05NOV2013     Y 100     06NOV2013    12NOV2013     Y 100     13NOV2013    19NOV2013     Y 100     20NOV2013    26NOV2013     Y 100     27NOV2013    03DEC2013     Y 100     04DEC2013    10DEC2013     Y 100     11DEC2013    17DEC2013     Y 100     18DEC2013    24DEC2013     Y 100     25DEC2013    31DEC2013     Y 100     01JAN2014    07JAN2014     Y 100     08JAN2014    14JAN2014     Y 100     15JAN2014    21JAN2014     Y 100     22JAN2014    28JAN2014     Y 100     29JAN2014    04FEB2014     Y 100     05FEB2014    11FEB2014     Y 100     12FEB2014    18FEB2014     Y 100     19FEB2014    25FEB2014     Y 100     26FEB2014    04MAR2014     Y 100     05MAR2014    11MAR2014     Y 100     12MAR2014    18MAR2014     Y 100     19MAR2014    25MAR2014     Y 100     26MAR2014    01APR2014     Y 100     02APR2014    08APR2014     Y 101     24SEP2013    30SEP2013     N 101     01OCT2013    07OCT2013     N 101     08OCT2013    14OCT2013     Y 101     15OCT2013    21OCT2013     N 101     22OCT2013    28OCT2013     N 101     29OCT2013    04NOV2013     N 101     05NOV2013    11NOV2013     N 101     12NOV2013    18NOV2013     N 101     19NOV2013    25NOV2013     N 101     26NOV2013    02DEC2013     N 101     03DEC2013    09DEC2013     N 101     10DEC2013    16DEC2013     N 101     17DEC2013    23DEC2013     N 101     24DEC2013    30DEC2013     N 101     31DEC2013    06JAN2014     N 101     07JAN2014    13JAN2014     N 101     14JAN2014    20JAN2014     N 101     21JAN2014    27JAN2014     N 101     28JAN2014    03FEB2014     N 101     04FEB2014    10FEB2014     N 101     11FEB2014    17FEB2014     N 101     18FEB2014    24FEB2014     N 101     25FEB2014    03MAR2014     N 101     04MAR2014    10MAR2014     N 101     11MAR2014    17MAR2014     N 101     18MAR2014    24MAR2014     N 101     25MAR2014    31MAR2014     N Thanks Sam ... View more

Check the dates in loop

by Obsidian | Level 7 in SAS Procedures
‎11-07-2014 10:14 AM
‎11-07-2014 10:14 AM
Hi All, I need to check the dates and need to flag them. I have more than 1500 unique subjid . Below is one example data have; informat STDT   ENDT date9.; format STDT     ENDT date9.; subjid=100; input STDT ENDT; cards; 02Oct2013  08Oct2013 09Oct2013  15Oct2013 16Oct2013  22Oct2013 23Oct2013  29Oct2013 30Oct2013  05Nov2013 06Nov2013  12Nov2013 13Nov2013  19Nov2013 20Nov2013  26Nov2013 27Nov2013  03Dec2013 04Dec2013  10Dec2013 11Dec2013  17Dec2013 18Dec2013  24Dec2013 25Dec2013  31Dec2013 01Jan2014  07Jan2014 08Jan2014  14Jan2014 15Jan2014  21Jan2014 22Jan2014  28Jan2014 29Jan2014  04Feb2014 05Feb2014  11Feb2014 12Feb2014  18Feb2014 19Feb2014  25Feb2014 26Feb2014  04Mar2014 05Mar2014  11Mar2014 12Mar2014  18Mar2014 19Mar2014  25Mar2014 26Mar2014  01Apr2014 02Apr2014  08Apr2014 ; run; data temp; informat dstdt  dendt date9.; format dstdt    dendt date9.; subjid=100; input dstdt  dendt; cards; 25OCT2013 17MAR2014 18MAR2014  28APR2014 ; run; want: STDT      ENDT    FLG 02Oct2013  08Oct2013 N 09Oct2013  15Oct2013 N 16Oct2013  22Oct2013 N 23Oct2013  29Oct2013 Y 30Oct2013  05Nov2013 Y 06Nov2013  12Nov2013 Y 13Nov2013  19Nov2013 Y 20Nov2013  26Nov2013 Y 27Nov2013  03Dec2013 Y 04Dec2013  10Dec2013 Y 11Dec2013  17Dec2013 Y 18Dec2013  24Dec2013 Y 25Dec2013  31Dec2013 Y 01Jan2014  07Jan2014 Y 08Jan2014  14Jan2014 Y 15Jan2014  21Jan2014 Y 22Jan2014  28Jan2014 Y 29Jan2014  04Feb2014 Y 05Feb2014  11Feb2014 Y 12Feb2014  18Feb2014 Y 19Feb2014  25Feb2014 Y 26Feb2014  04Mar2014 Y 05Mar2014  11Mar2014 Y 12Mar2014  18Mar2014 Y 19Mar2014  25Mar2014 Y 26Mar2014  01Apr2014 Y 02Apr2014  08Apr2014 Y I have two consideration to make, Below are the rules 1) if STDT <= dstdt  < ENDT then we need to consider flg      if dstdt <= dendt < ENDT then flg=Y;      if dendt >= ENDT then flg=Y; 2) if  dstdt < STDT then we need to consider flg     if STDT <= dendt < ENDT then flg=Y;     if dendt > ENDT then flg=Y; if these criteria no met then flg=N Thanks Sam ... View more

Re: proc template

by Obsidian | Level 7 in Graphics Programming
‎11-05-2014 10:56 PM
‎11-05-2014 10:56 PM
Thank you Sanjay!!! I am working on one your forest plot example. i am just trying to achieve different layout which i attached in my first post. i got unexpected plot, the following is sample data and code data: data test;   informat subgroup $25.;   input Subgroup & allpat Count med &$13 mean low high _count _med &$13 _mean _low _high hr &$13;   datalines;   Overall  4432 2166 1.30(.90-1.5) 1.3 0.90 1.50 2266 1.00(.60-1.2) 1.0 0.60 1.20 1.30(.90-1.5)    Age         .    .                .   .    .      .                .   .    .    <= 65 Yr 3168 1534 1.50(1.1-1.9) 1.5 1.05 1.90 1634 1.20(.75-1.6) 1.2 0.75 1.60 1.50(1.1-1.9)    > 65 Yr  1364  632 0.80(.60-1.3) 0.8 0.60 1.25  732 0.50(.30-.95) 0.5 0.30 0.95 0.80(.60-1.3) ; run; proc template; define statgraph Forest; dynamic _show_bands; begingraph /designwidth=1000px designheight=600px;; layout lattice / columns=8 columngutter=0 columnweights=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35); /*--Column headers--*/ sidebar / align=top; layout lattice / rows=2 columns=8 columnweights=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35); entry textattrs=(size=8) halign=left "Subgroup"; entry textattrs=(size=8) " All Patients"; entry " "; entry textattrs=(size=8) "Control group"; entry " "; entry halign=right textattrs=(size=8) "Other group" ; entry halign=right textattrs=(size=8) "Hazard Ratio(95%)" ; entry " "; entry " "; entry " "; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) " "; entry " "; endlayout; endsidebar; /*--First Subgroup column, shows only the Y2 axis--*/ layout overlay / walldisplay=none xaxisopts=(display=none) y2axisopts=(reverse=true display=(tickvalues) tickvalueattrs=(weight=bold)); scatterplot y=subgroup x=zero / markerattrs=(size=0) yaxis=y2; endlayout; /*--Second column showing Count and percent--*/ layout overlay / xaxisopts=(display=none) y2axisopts=(reverse=true display=none) walldisplay=none; if (exists(_show_bands)) referenceline y=ref / yaxis=y2 lineattrs=(thickness=15 color=cxf0f0f0); endif; scatterplot y=subgroup x=zero / markercharacter=allpat yaxis=y2 markercharacterattrs=graphvaluetext; endlayout; /*--3rd column showing PCIGroup and Group columns--*/ layout overlay / x2axisopts=(display=(tickvalues) offsetmin=0.25 offsetmax=0.25) y2axisopts=(reverse=true display=none) walldisplay=none; if (exists(_show_bands)) referenceline y=ref / yaxis=y2 lineattrs=(thickness=15 color=cxf0f0f0); endif; scatterplot y=subgroup x=pat_lbl / markercharacter=count xaxis=x2 yaxis=y2 markercharacterattrs=graphvaluetext; endlayout; /*--4th column showing PCIGroup and Group columns--*/ layout overlay / x2axisopts=(display=(tickvalues) offsetmin=0.25 offsetmax=0.25) y2axisopts=(reverse=true display=none) walldisplay=none; if (exists(_show_bands)) referenceline y=ref / yaxis=y2 lineattrs=(thickness=15 color=cxf0f0f0); endif; scatterplot y=subgroup x=med_lbl / markercharacter=med xaxis=x2 yaxis=y2 markercharacterattrs=graphvaluetext; endlayout; /*--5th/6th column showing PCIGroup and Group columns--*/ layout overlay / x2axisopts=(display=(tickvalues) offsetmin=0.25 offsetmax=0.25) y2axisopts=(reverse=true display=none) walldisplay=none; if (exists(_show_bands)) referenceline y=ref / yaxis=y2 lineattrs=(thickness=15 color=cxf0f0f0); endif; scatterplot y=subgroup x=pat_lbl / markercharacter=_count xaxis=x2 yaxis=y2 markercharacterattrs=graphvaluetext; endlayout; /*--5th/6th column showing PCIGroup and Group columns--*/ layout overlay / x2axisopts=(display=(tickvalues) offsetmin=0.25 offsetmax=0.25) y2axisopts=(reverse=true display=none) walldisplay=none; if (exists(_show_bands)) referenceline y=ref / yaxis=y2 lineattrs=(thickness=15 color=cxf0f0f0); endif; scatterplot y=subgroup x=med_lbl / markercharacter=_med xaxis=x2 yaxis=y2 markercharacterattrs=graphvaluetext; endlayout; /*--7th column showing PCIGroup and Group columns--*/ layout overlay / x2axisopts=(display=(tickvalues) offsetmin=0.25 offsetmax=0.25) y2axisopts=(reverse=true display=none) walldisplay=none; if (exists(_show_bands)) referenceline y=ref / yaxis=y2 lineattrs=(thickness=15 color=cxf0f0f0); endif; scatterplot y=subgroup x= zero/ markercharacter=hr xaxis=x2 yaxis=y2 markercharacterattrs=graphvaluetext; endlayout; /*--Third column showing odds ratio graph--*/ layout overlay / xaxisopts=(label=' <---Favour Contorl group ---- ----Favour Other group--->' linearopts=(tickvaluepriority=true tickvaluelist=(0.0 0.2 0.5 1.0 1.2 1.5 2.0))) y2axisopts=(reverse=true display=none) walldisplay=none; if (exists(_show_bands)) referenceline y=ref / yaxis=y2 lineattrs=(thickness=15 color=cxf0f0f0); endif; scatterplot y=subgroup x=mean / xerrorlower=low xerrorupper=high yaxis=y2 markerattrs=(symbol=circle); *scatterplot y=subgroup x=_mean / xerrorlower=_low xerrorupper=_high yaxis=y2 markerattrs=(symbol=circle); referenceline x=1/ lineattrs=(pattern=solid);; endlayout; endlayout; entryfootnote halign=left textattrs=(size=7) 'The p-value is from the test statistic for testing the interaction between the ' 'treatment and any subgroup variable'; endgraph; end; run; proc template; define style listingSF; parent = Styles.Listing; style GraphFonts from GraphFonts "Fonts used in graph styles" / 'GraphDataFont' = ("<sans-serif>, <MTsans-serif>",7pt) 'GraphValueFont' = ("<sans-serif>, <MTsans-serif>",7pt) 'GraphLabelFont' = ("<sans-serif>, <MTsans-serif>",7pt, bold); ; end; run; ods graphics / reset width=7in height=5in imagename='Forest_Ref_92'; proc sgrender data=test template=Forest; dynamic _show_bands='YES'; run; Thanks sam ... View more

Re: proc template

by Obsidian | Level 7 in Graphics Programming
‎11-05-2014 06:44 PM
‎11-05-2014 06:44 PM
Hi Ballardw, Working!!! no error message on the log, but output is not reflecting the layout what i required(attached) and in log: NOTE: COLUMNWEIGHTS=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35) is invalid. The default will be used. NOTE: COLUMNWEIGHTS=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35) is invalid. The default will be used. Thanks Sam ... View more

Re: proc template

by Obsidian | Level 7 in Graphics Programming
‎11-05-2014 06:38 PM
‎11-05-2014 06:38 PM
Thank you ballardw, I adopted from the above mentioned paper.. but my layout is bit different that where i struck Thanks Sam ... View more

Re: proc template

by Obsidian | Level 7 in Graphics Programming
‎11-05-2014 06:35 PM
‎11-05-2014 06:35 PM
Hi All, My template code is as follows, not working properly proc template; define statgraph Forest; dynamic _show_bands; begingraph /designwidth=1000px designheight=600px;; entrytitle halign=left "Company Name" halign=right "Study Phase"/ pad=(bottom=5px); entrytitle halign=left "Drug Name" halign=right "Detailed Study information"/pad=(bottom=5px); entrytitle "Table 1"/ pad=(bottom=5 px); entrytitle "Duration of Survival by Overall Survival Status"/ pad=(bottom=5px); entrytitle "Randomized Patients"/ pad=(bottom=5px); entrytitle " "/ pad=(bottom=5px); entrytitle halign=left "Treatment Group I Treatment Group II"/pad=(bottom=0px); entrytitle halign=left "-------------------------------------- ---------------------------------------"/pad=(bottom=0px); layout lattice / columns=8 columngutter=0 columnweights=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35); /*--Column headers--*/ sidebar / align=top; layout lattice / rows=2 columns=8 columnweights=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35); entry textattrs=(size=8) halign=left "Baseline Risk Factor"; entry textattrs=(size=8) " Total"; entry " Event"; entry textattrs=(size=8) "Median (95%CI) mo"; entry " Event"; entry halign=right textattrs=(size=8) " Median (95%CI) mo " ; entry halign=right textattrs=(size=8) "Hazard Ratio(95%)" ; entry " "; entry " "; entry " "; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) "_________________________________"; entry halign=right textattrs=(size=6) " "; entry " "; endlayout; endsidebar; and in log: NOTE: COLUMNWEIGHTS=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35) is invalid. The default will be used. NOTE: COLUMNWEIGHTS=(0.21 0.09 0.4 0.15 0.4 0.15 0.15 0.35) is invalid. The default will be used. ... View more

proc template

by Obsidian | Level 7 in Graphics Programming
‎11-05-2014 05:53 PM
‎11-05-2014 05:53 PM
HI All, I am working on per-processed data under proc template for forest plot. I am using sas9.2. i attached the file which i am working for the layout. Any example is very helpful Thanks Sam ... View more

how to read this data in to dataset

by Obsidian | Level 7 in SAS Procedures
‎11-05-2014 11:25 AM
‎11-05-2014 11:25 AM
Hi All, I took this from one of the sas sample "http://support.sas.com" . I need to read this data to dataset but data not reading properly. Any help is greatly helpful data : data test; input Subgroup $1-25 Count Percent Mean Low High PCIGroup Group PValue; zero=0; PCI_lbl='PCI group'; grp_lbl='group'; pval_lbl='-'; if count ne . then CountPct=put(count, 4.0) || "(" || put(percent, 3.0) || ")"; val=mod(_N_-1, 6); if val eq 1 or val eq 2 or val eq 3 then ref=subgroup; datalines; Overall 2166 100 1.3 0.9 1.5 17.2 15.6 . Age . . . . . . . 0.05 <= 65 Yr 1534 71 1.5 1.05 1.9 17.0 13.2 . > 65 Yr 632 29 0.8 0.6 1.25 17.8 21.3 . Sex . . . . . . . 0.13 Male 1690 78 1.5 1.05 1.9 16.8 13.5 . Female 476 22 0.8 0.6 1.3 18.3 22.9 . Race or ethnic group . . . . . . . 0.52 Nonwhite 428 20 1.05 0.6 1.8 18.8 17.8 . White 1738 80 1.2 0.6 1.6 16.7 15.0 . From MI to Randomization . . . . . . . 0.81 <= 7 days 963 44 1.2 0.8 1.5 18.9 18.6 . > 7 days 1203 56 1.15 0.75 1.5 15.9 12.9 . Infract-related artery . . . . . . . 0.38 LAD 781 36 1.4 0.9 1.9 20.1 16.2 . Other 1385 64 1.1 0.8 1.4 15.6 15.3 . Ejection Fraction . . . . . . . 0.48 < 50% 1151 54 1.2 0.8 1.5 22.6 20.4 . >= 50% 999 46 0.9 0.6 1.4 10.7 11.1 . Diabetes . . . . . . . 0.41 Yes 446 21 1.4 0.9 2.0 29.3 23.3 . No 1720 79 1.1 0.8 1.5 14.4 13.5 . Killip class . . . . . . . 0.39 I 1740 81 1.2 0.8 1.6 15.2 13.1 . II-IV 413 19 0.95 0.6 1.5 25.3 26.9 . ; run; Thanks Sam ... View more

Re: datetime to character date

by Obsidian | Level 7 in SAS Procedures
‎10-01-2014 06:30 PM
‎10-01-2014 06:30 PM
Thank you Arthur !!! that is what exactly what i am looking for. I tried datepart but i was not succeed with month section. I got error .. thank you  today i know how to and where to use worddate3. format Thanks Sam ... View more

datetime to character date

by Obsidian | Level 7 in SAS Procedures
‎10-01-2014 06:03 PM
‎10-01-2014 06:03 PM
Hi All, I have a variable with numeric datetime, but i need to create a new variable character variable Have: subj        stdt(numeric) 100          10OCT2013:12:15:32 want: subj        stdt(numeric)                                     newvar 100          10OCT2013:12:15:32                     10 OCT 2013 My try: newvar=scan(put(stdt,datetime20.),1,':'); I got: 10OCT2013 but i want 10 OCT 2013 Thanks Sam ... View more

keep selected records

by Obsidian | Level 7 in SAS Programming
‎09-09-2014 11:34 AM
‎09-09-2014 11:34 AM
Hi All, I have to keep, if certain grp have both "ABC' and 'DEF' types for that grp i need to keep Type "ALL" Have data: grp       type 1          All 1          All 1          All 1          All 1         ABC 1         ABC 1         ABC 1         ABC 2         All 2          All 2          All 2          All 2         ABC 2         ABC 2         ABC 2         ABC 2         DEF 2         DEF 2         DEF 2         DEF 3         All 3         All 2          All 3          All 3         DEF 3         DEF 3         DEF 3         DEF want: grp       type 1         ABC 1         ABC 1         ABC 1         ABC 2         All 2          All 2          All 2          All 2         ABC 2         ABC 2         ABC 2         ABC 2         DEF 2         DEF 2         DEF 2         DEF 3         DEF 3         DEF 3         DEF 3         DEF This is my try: data want; do until(last.grp); set have(keep=group type); by grp type; flg=(TYPE eq 'ALL')*1+(TYPE eq 'ABC')*2+(TYPE eq 'DEF')*3; if flg in(2,3) then keep=1; output; end; run; Thanks Sam ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-10-2023 02:21 PM
Likes given to
Quick links