OK. How About: data x; input ORD    AECAT    & $40.                TRT OUTCOME   FREQ ; cards; 1     Any TEAE                     1      1        17 1     Any TEAE                     1      2        23 1     Any TEAE                      2     1           13 1     Any TEAE                      2      2        52 2     Drug-Related TEAE         1      1         4 2     Drug-Related TEAE         1        2      36 2     Drug-Related TEAE                       2        1         6 2     Drug-Related TEAE                       2        2 59 3     Grade 3 or Higher TEAE                  1        1         3 3     Grade 3 or Higher TEAE                  1        2 37 3     Grade 3 or Higher TEAE                  2        1         1 3     Grade 3 or Higher TEAE                  2        2 64 4     Grade 3 or Higher Drug-Related TEAE     1 1         2 4     Grade 3 or Higher Drug-Related TEAE     1 2        38 4     Grade 3 or Higher Drug-Related TEAE     2 1         1 4     Grade 3 or Higher Drug-Related TEAE     2 2        64 5     Serious Adverse Event                   1 1         3 5     Serious Adverse Event                   1        2 37 5     Serious Adverse Event                   2        1         2 5     Serious Adverse Event                   2        2 63 6     On-study Death                          1        1         1 6     On-study Death                          1        2 39 6     On-study Death                          2        1         0 6     On-study Death                          2        2 65 ; run; proc sql; create table temp as select  AECAT,catt(freq,' (',put(freq/sum(freq)*100,f4.1),')') as per length=20 from x    group by  AECAT,TRT     having OUTCOME=1;quit; proc transpose data=temp out=want(drop=_name_); by  AECAT; var per; run; proc freq data=x; tables AECAT*trt*outcome / fisher; output out=ChiSqData(keep=AECAT XP2_FISH) n fisher; weight freq; run; data want; merge want ChiSqData; by  AECAT; label AECAT='Category' col1='Control (N=40)' col2='Active (N=65)'; run; proc print label noobs;run; Ksharp ... View more

Hi:   In addition to Tom's suggestion, depending on what you mean by the "order coming out somewhat wrongly", there are other options you can use in your DEFINE statement. For example, if you want the SALES in DESCENDING order, that is an option you can list on the DEFINE statement. ORDER= can take 4 values: FREQ, FORMATTED, INTERNAL and DATA.  I rarely use FREQ or FORMATTED. I find that either INTERNAL or DATA suits most of what I need to do.   Here are some other examples to compare. cynthia Data one; INPUT ZIP CTY $ VAR :$15. SALES; CARDS; 52423 Scott Merlot 186.     52423 Scott Chardonnay 156.61 52423 Scott Zinfandel 35.5  52423 Scott Merlot 55.3     52388 Scott Merlot 122.89   52388 Scott Chardonnay 78.22 52388 Scott Zinfandel 15.4  52200 Adams Merlot 385.51   52200 Adams Chardonnay 246  52200 Adams Zinfandel 151.1 52200 Adams Chardonnay 76.24 52199 Adams Merlot 233.03   52199 Adams Chardonnay 185.22 52199 Adams Zinfandel 95.84 ; run;    ods listing close; ods html file='c:\temp\show_order.html' style=sasweb; proc report data=one nofs; title '1) ORDER (simple) is ASCENDING'; column cty zip var sales; define var / display; define sales / order f=6.2; run;      proc report data=one nofs; title '2) ORDER (simple) is DESCENDING'; column cty zip var sales; define var / display; define sales / order descending f=6.2; run;             proc report data=one nofs; title '3) ORDER is DATA gives input data order'; column cty zip var sales; define var / display; define sales / order f=6.2 order=data; run;    proc report data=one nofs; title '4) ORDER is internal'; column cty zip var sales; define var / display; define sales / order f=6.2 order=internal; run;    proc report data=one nofs; title '5) ORDER for multiple vars note that ZIP is still unordered'; column cty zip var sales; define cty / order; define var / display; define sales / order f=6.2; run;    proc report data=one nofs; title '6) ORDER for multiple vars DESCENDING for CTY'; column cty zip var sales; define cty / order DESCENDING; define var / display; define sales / order f=6.2; run;   ods html close; ... View more

What you are getting is the whole content of the Change_status_Rev1 datasheet. You can also specify a range of cells, as follows : Proc print data  = klm.'Change_status_Rev1$A1:E99'n; run; PG ... View more

Or if missing(age) then age=9999; ... View more

Sorry this is not working and summing of population also not happening ... View more

You are using an informat, not a format.  The SAS documentation on the w.d informat provides the explanation, here is the link. http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000199348.htm ... View more

Thank you for the prompt answer. ... View more

Hi, 01Jan2012 is sunday.next day of weekday is monday which 02Jan2012,Your code is working correct right. 06Jan2012 is friday and its giving 09Jan2012 as weekday starts. data _null_;    x=intck('weekday17w', '01jan12'd, '31dec12'd);    y=intnx('weekday17w', '01jan12'd, 1);    z=intnx('weekday17w', '06jan12'd, 1);    format y z date9.;    put (_all_) (=); run; x=261 y=02JAN2012 z=09JAN2012 Thanks, Shiva ... View more

Seems you are looking a way to remove duplicates on some key variables (method other than proc sort nodupkey): See if it helps: data best;     input patient 1-2 arm $ 4-5 bestres $ 6-7 delay 9-10; datalines; 01 A CR 0 02 A PD 1 03 B PR 1 04 B CR 2 05 C SD 1 06 C SD 3 07 C PD 2 01 A CR 0 03 B PD 1 ; proc sort data=best ; by arm patient; run; data uniq; set best; by arm patient; if first.patient; run; ... View more

If I understand it right you want Id preceeded by 6 to form NewId for all observations where Variety not equal to 'Ginger'. What do you want NewId to be when Variety is 'Ginger'? Below code assigns Id to NewId when Variety is 'Ginger'. If you want NewId to be null string when Variety is 'Ginger' replace Id with '' in the assignment (else NewId = '';). data one; length NewId $15; set two; if NOT(Variety = "Ginger") then NewId=CATS('6',id); else NewId = Id; run; ... View more

Hi, From SAS documentation, The TRANWRD function replaces all occurrences of a given substring within a character string. The TRANWRD function does not remove trailing blanks in the target string and the replacement string. TRANWRD uses a single blank instead when the replacement string has a length of zero. Try using compress to remove all the blank spaces,if you want. data _null_;    string1='*' || compress(tranwrd('abcxabc', 'abc', trimn(''))) || '*';    put string1=;    string2='*' || compress('abcxabc', 'abc', '') || '*';    put string2=; run; Thanks, Shiva ... View more

I am honored to be in the same boat with you. Happy July 4th! - Linlin ... View more

Order of operations followed here. Multiplication and division have the same precedence in which case operations performed from left to right. ... View more