Hello:    I wonder if there is an easy way to produce bar plots that track donation progress? Suppose there are 3 sites 1,2,3 which finish certain percentages of their fundraising target e.g 3k out of 5k, 5k out of 10k and 7k out of 10k. I hope to plot 3 bars and the height of each bar represents the target. Inside each bar, it shows the amount already raised (with a different color) as well as the percentage.  Data is easy but not sure how to plot it in SAS.    Thanks, Peter ... View more

Hi:   I wonder if there is an easy way to underline last row of each page in proc report? The code below print horizontal lines for the whole table ods rtf file='test.rtf'; title 'Air travel'; footnote 'my footnote'; proc report data=test nowd style(report)=[rules=none frame=hsides] style(header)=[background=white borderbottomcolor=black borderbottomwidth=2]; column date air; define date/order; run; ods rtf close; How can I (automatically) underline last row of each page as below? Thanks,   ... View more

Hello:    I hope to simulate multiple datasets based on a single seed for reproducibility. It seems that call streaminit only impacts randomization within the same data step. For example, if I run the code below data test1; call streaminit(1234); do i = 1 to 4; a= rand('Uniform'); output; end; run; proc print data=test1; run; data test2; do i = 1 to 4; b= rand('Uniform'); output; end; run; proc print data=test2; run; test1 will remain the same but test2 will change in multiple runs. Is there a way to set seed only once (at the beginning of the program) to determine all random numbers in the entire program, regardless of whether they are in the same data step?   Thanks, Peter ... View more

Hello all:    I am now reading the book "Implementing CDISC Using SAS" by Holland and Shostak to learn CDISC implementation. Chapter 2 showed an example of creating define.xml from excel spreadsheet in base SAS. The authors provided SAS code/output & stylesheet on the book site https://support.sas.com/en/books/authors/chris-holland.html   The sample directory for chapter 2 includes define.xml and define2-0-0.xsl. However, the main output define.xml cannot be properly rendered. Microsoft edge and Chrome displayed an empty page. Firefox displayed contents in define.xml without the proper format.  Interestingly, it was properly shown in internet explorer, which retires soon.  So I suppose something in the define.xml is not supported by modern browser? Does anyone know what the problem is and how to fix it?   This makes me worry about learning CDISC implementation in SAS with this book. Are there any other good (and more recent) references/resources?    Thanks, Peter ... View more

Hello:    I wonder if there is any way in proc sql to select distinct formatted values. For example, the code below formats both 1 and 2 as "Agree". However, the select distinct statement returns two identical lines of "Agree". My assumption is that the distinct keyword applies only to raw value. Is there any generic way to force proc sql operate based on formatted value? By 'generic', what I mean is that I don't want to hand code any format in proc sql. The desired behavior is for proc sql to use whatever format assigned in the dataset for a specific variable.    Thanks, Peter   proc format; value a 1,2='Agree'; run; data test; a=1; output; a=2; output; format a a.; run; proc sql; select distinct a from test; quit; ... View more

Hello:    I am trying to fit Cox PH models with time dependent covariate using both counting process and programming syntax. The results are always slightly different and I am not sure why.    Using an example on SAS website https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.3/statug/statug_code_phrex6.htm This example fits a Cox model using programming syntax proc phreg data= Heart; model Time*Status(0)= XStatus Acc_Age; if (WaitTime = . or Time < WaitTime) then XStatus = 0; else XStatus = 1; run;   I converted the dataset Heart to long format data heart_long; set heart; if WaitTime = . or Time < WaitTime then do; Xstatus = 0; start = 0; end=Time; status2 = status; output; end; else do; Xstatus = 0; start = 0; end=WaitTime-1; status2 = 0; output; Xstatus = 1; start = WaitTime-1; end=Time; status2 = status; output; end; run; The reason I used waitTime-1 in the calculation of start/end time is because according to SAS document, the interval is right closed i.e (start, end].  I then fitted the same model  proc phreg data= Heart_long; model (start,end)*Status2(0)= XStatus Acc_Age; run; The results are slight different. Is this discrepancy due to my mistake in the code or is it related to how SAS fit model when using different syntax?   Thanks, Peter     ... View more

Hello:   I wonder how do you span rows for nested group variables in proc report. The output of the following code   ods rtf file='class.rtf'; proc report data=sashelp.class; column sex age height weight; define sex / group; define age/ group; define height / analysis mean f=8.1; define weight / analysis mean f=8.1; run; ods rtf close;   will generate a table like Sex Age Height Weight F 11 51.3 50.5   12 58.1 80.8   13 60.9 91.0   14 63.6 96.3   15 64.5 112.3 M 11 57.5 85.0   12 60.4 103.5   13 62.5 84.0   14 66.3 107.5   15 66.8 122.5   16 72.0 150.0 where gender is only display for the first nested age group. However for other age groups, an empty cell (with borders) is still displayed under Sex and I wonder how to either merge gender values with empty cells below or make the top border invisible for empty cells under Sex?   Thanks, Peter ... View more

Hello:    I hope to calculate the risk difference using proc freq, where event is coded as 1 and 0 otherwise.  SAS automatically consider 0 as event and I cannot find the option to switch it. Is there any way to specify the level of class variable to be considered as event?   Thanks, Peter ... View more

Hello:   I wonder how to access SAS data files on a unix server from from windows SAS? proc connect looks like an option but it seems that you need SAS on both the client and server? If so, do I need two separate licenses? Can I use proc access with ODBC driver?   Thanks, Peter ... View more

Hello:    I want to do a sample size calculation for a two proportion equivalence test to show two drugs are not different. According to this link,  http://support.sas.com/kb/50/700.html SAS does not implement this in proc power.    Does anyone know a work around? Do I need to implement it myself?   Thanks, Peter   ... View more

Hello:    I need to run a serious of logistic regression and save the results in rtf/pdf.        %macro regression(var); ods exclude all; proc logistic data=cohort descending; model outcome= &var; strata match; ods output ParameterEstimates=ps; run; proc print data=ps; run; %mend; ods rtf file='output.rtf' bodytitle; title 'first regression'; %regression(var1); title 'second regression'; %regression(var2); ods rtf close; The challenge is that the following text is always displayed in the output file, although ods exclude all is used.  The LOGISTIC Procedure   Conditional Analysis     This seems to be associated with the bodytitle option. However, it is required to put the title in the body. Another option is to use   ods rtf exclude all; However, if rtf destination is not open, the above code will generate an error. I am wondering whether there is a generic solution to this problem?   Thanks, Peter   ... View more

I hope to produce a report using proc report and ods rtf. Is there anyway I can use SAS monospace font in the output? Is it a built-in font that works in rtf?   Thanks, Peter ... View more

Hello all: I wonder how to properly display tables that include columns with and without missing values. For example, suppose a portion of patients was selected for a particular blood test, which returns +/- as results.In the dataset, we then have a variable test=0/1 for every patient. For each patient with test=1, result=0/1 is defined as blood test results. In the report, I want to display sth. like : Blood Test Test Results Done Not Done Negative Positive Since result is not defined when test=0. I cannot find a good way to display the two columns in the same table. I can use missing option but the challenge is that I don't want to display a third (missing/not done) column under Test Results, as it is redundant. Any suggestions? Thanks, Peter ... View more