About Reeza

Reeza · ‎11-15-2011

You can do it with nested functions. sysfunc has a put by default so you don't need a putn either. However your variable is actually a datetime variable not a date variable so you need to take the datepart of the datetime variable first, then do the format. %let cdate=%sysfunc(datepart(%sysfunc(attrn(&rc, crdte))),date9.);

Reeza · ‎11-10-2011

Ok...same idea then. Take each independent variable that was generated and flag if its an outlier or not. AFAIK there really isn't an absolute statistical definition of what is an outlier, so you'll need to come up with that. There's some suggested methods on Wikipedia http://en.wikipedia.org/wiki/Outlier

Reeza · ‎11-10-2011

You need to define an outlier (0/1) then add that up. Defining the outlier is the problem, is it something outside the 99.9% CI? It really depends on what you're looking at and your modelling criteria. How many paramters are you looking at, do you have a single outcome or multiple outcomes. What's an outlier also depends on business context, for machinery it might be 99% but for medical data could be 95%... We need more details on what your simulating and how to help out.

Reeza · ‎11-10-2011

Ah yes, the fun with EG. You can't with EG 4.3 as far as I can see with the GUI interface. You can with code. ods table ttest=mytable; proc ttest data=sashelp.class; class sex; var height; run; That should create a table called mytable that has the info you want. In general you can do that for most procs and you can find the table names from the doc or running a proc between ods trace on; SAS CODE; ods trace off;

Reeza · ‎11-09-2011

Yeah, same thing in my log. Opening a ticket with Tech Support. Thanks!

Reeza · ‎11-09-2011

Thanks Peter, but that doesn't work either

Reeza · ‎11-09-2011

Unfortunately I wouldn't know what to look for in the XML file I'll tried creating a sample in Excel and looking for similarities in the file but nothing jumps out at me.

Reeza · ‎11-09-2011

I'm trying to use the tagattr mergeAcross style on a field that isn't the last field. It works if its the last field, but I want it to be the middle field...is there a way to get this to work? I keep getting an XML error in the file, but I could be missing something. If I print just model and comment ou the make and type columns it works fine. Ideally, I'd like to print the first table with a filed that merged across and the second table below without the field merged across, to fit things on the table and have it look nice as well. Thanks! ods listing close; ods tagsets.excelxp file="C:\temp\example6.xls" style=journal options(sheet_interval='none' embedded_titles='yes'); title ; proc report data=sashelp.cars (obs=100) nowd; columns model make type; define model / 'Name' style={tagattr="mergeAcross:yes"}; define make/display; define type/display; run; /*proc freq data=sashelp.class;*/ /* tables age;*/ /*run;*/ ods tagsets.excelxp close; ods listing;

Reeza · ‎11-08-2011

Run the proc with with the code between ods trace on and off ie ods trace on; proc logistic....rest of code ods trace off; Look at the log and get the names of the tables you're interested in or the doc that Art provided a link to. then add in the line for either ods select or ods exclude. ods select tablenameshere; proc logistic then the only output you'll get are the ones youre interested in. If you only want to exclude one table then its easier to ods exclude tablename rather than type ods include allothers so decide what works for you.

Reeza · ‎11-04-2011

As per the docs for ods graphics option you're looking for the nocensor option. The options vary by the output type, ie ods graphics and traditional graphics. the nocensplot is for lineprinter not ODS. read the very fine buried print Try the following, works on my comp. SAS 9.2.3 ods graphics on; proc lifetest data=BMT plots=survival(atrisk=0 to 2500 by 500 NOCensor) ; time T * Status(0); strata Group; run; ods graphics off;

Reeza · ‎11-04-2011

I know, but that involves scanning the log, it isn't stored somewhere. Also the log doesn't specify the by group the formula is for when you have multiple groups, or at least mine didnt (SAS 9.2.3). So since you're going to have to grab it somehow, you can either scan the log as Tom has mentioned above or calculate it elsewhere, ie using the manual calculations in Proc Corr (not means like I said earlier). I'd personally prefer to calculate it elsewhere b/c the log doesn't specify which formula goes with which group/stock/by variable rather than read the log, but that's my preference. The formula's are below and all the outputs required (ie mean/std/correlation) will be outputted from Proc Corr which is available in base. http://en.wikipedia.org/wiki/Simple_linear_regression

Reeza · ‎11-04-2011

I'm assuming you need the formula, not the data points but you can also manually calculate the slop and intercept using proc means and a bunch of their precalculated statistics without too much work. SInce you're applying this to a predicted dataset at some point you'll need a datastep anyways.

Reeza · ‎11-03-2011

You'd need to provide more information. A time dependent variable was already suggested and depending on your trial that could be the appropriate way. Depending on the clinical context it may also make sense to separate it into 3 drugs, ie drug a, drug b, drug A/B.

Reeza · ‎11-03-2011

Typically when you run multiple pairwise comparisons you don't need to adjust your calculations but you do need to adjust your cutoff point. Bonferonni corrections are common, but there are more out there that might make sense depending on exactly what you're testing. http://en.wikipedia.org/wiki/Multiple_comparisons

Reeza · ‎11-03-2011

Try the following code, a few slight modifications that could be the issue, ie you can say open instead of file-open and the close statement doesn't need a path if its the only file you're working with. options noxwait noxsync; x ' "C:\Program Files\Microsoft Office\OFFICE11\EXCEL.exe" '; data _null_; x=sleep(5); run; filename ddecmd dde 'excel|system'; data _null_; file ddecmd; put '[OPEN("C:\My Projects\Temp\Data Capture\CreateCSVFiles.xls")]'; run; data _null_; file ddecmd; put '[CLOSE()]'; put '[QUIT()]'; run;