About Jack2012

Jack2012 · ‎04-25-2019

Dear All, Could anybody help me find out the paper as indicated in below link which is out of work now. Thank you. Jack https://support.sas.com/en/knowledge-base.htmlpapers/proceedings/proceedings/forum2007/041-2007.pdf Graphical Representation of the Mean Measurement over time

Jack2012 · ‎08-14-2018

I am facing the same question as well, have anybody has solution?

Jack2012 · ‎09-28-2017

I have noticed this post and read it. However, Not the answer that I am seek for. Thanks.

Jack2012 · ‎08-28-2017

Dear SAS Experts, I am wondering if our SAS company developing the PROC MCPMOD procedure? I googled and find there is such procedure developed by CYTEL company <http://www.phusewiki.org/docs/2016_Hyderabad_SDE/6_Chitra%20Tirodkar.pdf>. Regard to the development of the clinical trials and the importance of the dose finding, will SAS company develop such procedure (like an R package) for SAS Fans? Best, Jack

Jack2012 · ‎05-10-2017

Highly appreciated for your proposal. I think the ODS EXCEL works for me at present.

Jack2012 · ‎05-10-2017

Thanks Art, the problem, after I read the code in the link, is the format of my data is not stored in the DICTIONARY library, actually there is no such library. I am lost which one to use as instead of DICTIONARY since I have no idea about the such library.

Jack2012 · ‎05-09-2017

Dear All, I am facing an frustrating problem: when I use PROC EXPORT to export data (with many variables have format ) to EXCEL, I found the format is lost, e.g. SEX only appear 1 or 2 in EXCEL. I have searched in our community, but no easy way. Like ODS EXCEL+PROC REPORT, since many variable have their formats, then it is not a fun thing to define each variable. May I know if there is an easy way? Best, Jack

Jack2012 · ‎09-08-2016

Thank you Reeza, I have attached here. Due to confidential issue, I have to remove some in formaton hope this will not impact your judgement on the issue. THanks for yoru quick action.

Jack2012 · ‎09-08-2016

Dear ALL, Just want to figure out why I use below code and there always come out an error: ERROR: File WORK.WINLIB.DATA does not exist. WIth below code: PROC DATASETS lib=data_a; contents; run; I am using the UNIX SAS 9.4. Thanks.

Jack2012 · ‎09-08-2016

I am afraid I can't agree with you that there was a typos. I read and wrote from the manual. BUt I think the key point is that SAS set such conditioin that when once column sum is 0 then no statistics will be calculated, even they can compute. Like the Relative risk. Thanks.

Jack2012 · ‎08-28-2016

The data in my question is as below: How could the relative risk is not computable by SAS PROC FREQ? Not unerstand.

Jack2012 · ‎08-28-2016

I am afraid I did not get your point. P1 is n11/n1.=1; P2=n21/n2.=1; We don't use n.2=0 at all. How do you mean that the denominator =0?

Jack2012 · ‎08-26-2016

I have got your point. That is the one I am seeking. I think I can try merge the two headers into one. Best

Jack2012 · ‎08-26-2016

Thanks for your code. But I can only get below with each cell contains two formulation results. I know this is due to we use the Lattice alyout. What I am seeking is is there possibility to add two levels in the header and with each row for one age group? Just like my sample figure in the first post. Thanks.

Jack2012 · ‎08-26-2016

Dear All, I am trying to use PROC FREQ to calculate the Realtive risk between two groups. But when I run, I found there is one column with 0 counts for both rows. That is I have the data with n12=n22=0 counts (denoted in the manual).Therefore the PROC FREQ did not calculate any statistics for this frequency table. However, per the below manual, SAS should be able to calculate the Relative risk at least. Does anybody know how to do to make it calculate this relative risk at least? Any option to make SAS work? Or you have any good idea? many thanks.

Online Status	Offline
Date Last Visited	‎05-05-2023 03:02 AM

Re: Can't read some uncommon/special Chinese word from excel

Can't read some uncommon/special Chinese word from excel

Re: How to get the type I error as shown in the shot ?

How to get the type I error as shown in the shot ?

Re: derive start date and end date

derive start date and end date

Re: A macro can't be used-A SAS® Macro to Generate Information Rich Ka...

A macro can't be used-A SAS® Macro to Generate Information Rich Kaplan...

Re: Question regard to the book Modern Appoaches in clinical trials Us...

Re: Question regard to the book Modern Appoaches in clinical trials Us...

Re: how to extract the valuew which are in parentheses

Re: LOCF

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: Area under the curve calculation

Re: Sample size estimation with PROC POWER

Re: Why no solution computed in PROC POWER

How could I get 2 y axis with 1 x axis for each plot in a panel?

Re: A new SAS/GRAPH Book is available

Re: PROC MIXED FOR POOLED REGRESSION?

Hunt for the paper 041-2007: Graphical Representation of the Mean Meas...

Re: Non-inferiority. Farrington–Manning test extended to the Mantel–Ha...

Re: Is SAS developing MCP MOD Procedure?

Is SAS developing MCP MOD Procedure?

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

How to retain the Variable Format when PROC EXPORT TO EXCEL

Re: Why there is error: WORK.WINLIB .data does not exist?

Why there is error: WORK.WINLIB .data does not exist?

Re: How to make PROC FREQ can calculate the Relative Risk for the colu...

Re: How to make PROC FREQ can calculate the Relative Risk for the colu...

Re: How to make PROC FREQ can calculate the Relative Risk for the colu...

Re: How to create below figure via GTL?

Re: How to create below figure via GTL?

How to make PROC FREQ can calculate the Relative Risk for the column w...