About djbateman

djbateman · ‎11-08-2012

I believe the options that you linked me to are for the LIBNAME statement, but will they also work in the Options box of the New Library window? And I was not aware of autoexec.sas files; I will look into those. Thanks!

djbateman · ‎11-08-2012

I like to set up my libraries to be enabled at startup, so I create them using the New Library window (see the attached image) by right-clicking in the Active Libraries window and choosing New... from the pop-up menu. I cannot find much documentation on it, so I don't know what the Options: box is for. Every time I start up SAS, I have to use options fmtsearch=(fv04.formats);. I was not sure if the options statement above is related to the Options: box in the New Library window. Is it possible to have SAS search for the library formats upon start up so I don't have to type in the options statement every time I start SAS? I don't know if that would be good practice if I start getting a lot of libraries saved in there, so any advice would also be accepted. In short, I have two questions: Where can I read about the Options: box in the New Library window? Is there a way to enable the options fmtsearch statement at start up of SAS?

djbateman · ‎10-31-2012

I didn't mark this as a question, so I couldn't give you points as a correct answer. Both of these options did the trick. Thank you for your sharp eye! Such simple fixes that I spent so much time searching for.

djbateman · ‎10-31-2012

I have removed the style=journal option (it is just by habit that that is in there). I got color output, but I have dashed lines for the red bars. Should I specify a certain style that will not give dashed needles?

djbateman · ‎10-31-2012

I have removed the style=journal option (it is just by habit that that is in there). I got color output, but I have dashed lines for the red bars. Should I specify a certain style that will not give dashed needles?

djbateman · ‎10-31-2012

I must have some kind of option turned on that I am not seeing, but when I run the macro shown below, the output is produced in the HTML results viewer as well as in the stored .RTF file that I specify. Attached are the two outputs (I couldn't attach the RTF, so the same is in PDF). I want the HTML look in the RTF file. Is there a reason why the HTML shows colored bars while the RTF shows B&W line patterns? %macro waterfall(dsin=, whr=%str(), yvar=, byvar=, title=%str(), ylab=%str(), outpath=%str(), filename=%str(), barwidth=3); /* Display error message if WATERFALL dataset is attempting to be overwritten */ %if %sysfunc(upcase(&dsin.))=WATERFALL %then %do; %put ERROR: The dataset WATERFALL is used in the waterfall macro. Please rename your input dataset and rerun the macro; %return; %end; /* Get variable type and format of BYVAR */ proc sql noprint; select type, format into :vartyp, :varfmt from sashelp.vcolumn where upcase(memname)=upcase("&dsin.") & upcase(name)=upcase("&byvar."); quit; /* Subset DSIN into WATERFALL & sort */ data waterfall; set &dsin.; where &whr.; run; proc sort data=waterfall; by &byvar. descending &yvar.; run; data waterfall; set waterfall; n=_n_; run; /* Create waterfall plot */ options formchar="|____|+|___+=|_/\<>*" pageno=1 nonumber nodate orientation=landscape center; ods listing close; ods pdf file="&outpath.\&filename..pdf" style=journal; /* goptions reset=all ftext=swissl ftitle=swissl hsize=9 in vsize=6.5 in;*/ title1 "&title."; proc sgplot data=waterfall; where &yvar.^=.; needle x=n y=&yvar. / group=&byvar. lineattrs=(thickness=&barwidth.); refline 0; keylegend / across=1 position=topleft location=inside; xaxis display=none; yaxis grid values=(-100 to 150 by 50) label="&ylab."; run; quit; ods pdf close; ods listing; title; footnote; /* proc datasets lib=work;*/ /* delete waterfall;*/ /* run;*/ quit; %mend waterfall;

djbateman · ‎10-29-2012

I saw that NAME option, but I was not getting what it was doing. That makes complete sense now. Thank you!

djbateman · ‎10-29-2012

I just upgraded to SAS 9.3 last week. I am attempting to redo some of my graphs that I have been producing in SAS 9.1.3 for so long. I came across an issue where I cannot keep certain SCATTER statements from sending a label to the legend. For example, I run the following code: proc sgplot data=sdfdata1; step x=survtime y=survrate1 / lineattrs=(color=black pattern=1) legendlabel='Vynfinit+PLD'; step x=survtime y=survrate2 / lineattrs=(color=black pattern=2) legendlabel='PLD Alone'; scatter x=survtime y=censvalue / markerattrs=(color=black symbol=plus) legendlabel='Censored'; scatter x=timelist y=strata / markerchar=left2 markercharattrs=(color=black) y2axis; scatter x=timelist y=strata / markerchar=left1 markercharattrs=(color=black) y2axis; keylegend / across=1 location=inside position=topright noborder; refline 0; yaxis offsetmin=0.1 min=0 values=(0 to 1 by .1) label="Probability of PFS"; y2axis offsetmin=0.03 offsetmax=0.93 display=(nolabel noticks); xaxis values=(0 to 75 by 5) label="Weeks from Randomsation"; run; quit; I want to display the legend labels for the STEP statements and the first SCATTER statement; however, I want to suppress the labels for the last two SCATTER statements. If I leave out the LEGENDLABEL option, the it defalts to putting the name of the Y= variable. Is there a way to keep it from printing at all?

djbateman · ‎10-26-2012

The fudge factor seemed to be my best bet. Thanks!

djbateman · ‎10-26-2012

While producing a Kaplan-Meier survival plot, I added the number of patients at risk at given time points. To get the at-risk counts, I used the default values (the LEFT variable) produced in PROC LIFETEST from the ProductLimitEstimates ODS output table: ods output ProductLimitEstimates=ple; proc lifetest data=efficacy timelist=(0 to 75 by 5); time survtime*censorflag(0); strata trtgrp; run; If a patient experiences an event at a time point cut off (say, exactly 10 weeks), then SAS does not count that patient as being at risk. However, I have been told by both our program validator and biostatistician consultant that such patients should be counted as being at risk. Is there an option in SAS that would allow me to specify to count those patients, or do I have to manually run the data through a loop and count them up on my own? I was originally using SAS 9.1.3, but I was able to upgrade to SAS 9.3 this week. Wahoo!

djbateman · ‎10-24-2012

This almost gets me there. It double/triple counts everything. If there is only one LNDAT for a given LAB_ID, then it works great. But if there are two LNDAT's, then it double counts; if there are three LNDAT's, then it triple counts, etc. I tried to simplify by deleting all records where LNDAT<COLL_DT. That helped quite a bit, but for the example that I gave, LNDAT of 18-Feb-09 and 15-May-12 are both less than COLL_DT of 21-May-12 or 1-Jun-12. Therefore, it captured both sets of lab normal values and double counted.

djbateman · ‎10-24-2012

There is no number-of-days requirement. I am just using the last lab normal values assessment before the lab test results assessment. I will play around with SQL to see what I can come up with. Just a side note, I believe I sat by you at the MWSUG in Minneapolis during the Monday night dinner. We didn't get to speak though. I meant to see if you spoke Russian practice my русский on you.

djbateman · ‎10-24-2012

I have two data sets: one with lab test results and one with lab normal values (displayed below are very small subsets for one patient). Lab Test Results: PATNO LAB_ID TSTTYPCD ORDSEQNO TSTCD COLL_DT RESULT 3728 0007-001 Chemistry 1 Sodium 7-May-12 139 3728 0007-001 Chemistry 1 Sodium 21-May-12 139 3728 0007-001 Chemistry 1 Sodium 1-Jun-12 137 3728 0007-001 Chemistry 1 Potassium 7-May-12 3.5 3728 0007-001 Chemistry 1 Potassium 21-May-12 3.0 3728 0007-001 Chemistry 1 Potassium 1-Jun-12 3.3 Lab Normal Values: LAB_ID TSTTYPCD ORDSEQNO TSTCD LABNAME LNDAT LOW_LIM UP_LIM UNITS 0007-001 Chemistry 1 Sodium University Medical Center 18-Feb-09 135 145 mMol/L 0007-001 Chemistry 1 Sodium UAZCC-North 15-May-12 130 150 mMol/L 0007-001 Chemistry 2 Potassium University Medical Center 18-Feb-09 3.5 5.5 mMol/L 0007-001 Chemistry 2 Potassium UAZCC-North 15-May-12 3.8 5.9 mMol/L I am merging on LAB_ID, TSTTYPCD, ORDSEQNO, and TSTCD (in that order). However, the new data set needs to matches up the lab results with the lab normal values based on dates (COLL_DT for lab test results and LNDAT for lab normal values). The lab normal values line up with a lab test based on the last LNDAT before COLL_DT. I cannot simply add dates into the merging groups because they are not identical values. I hope this makes sense. The new table should look like this: PATNO LAB_ID TSTTYPCD ORDSEQNO TSTCD COLL_DT RESULT LABNAME LNDAT LOW_LIM UP_LIM UNITS 3728 0007-001 Chemistry 1 Sodium 7-May-12 139 University Medical Center 18-Feb-09 135 145 mMol/L 3728 0007-001 Chemistry 1 Sodium 21-May-12 139 UAZCC-North 15-May-12 130 150 mMol/L 3728 0007-001 Chemistry 1 Sodium 1-Jun-12 137 UAZCC-North 15-May-12 130 150 mMol/L 3728 0007-001 Chemistry 2 Potassium 7-May-12 3.5 University Medical Center 18-Feb-09 3.5 5.5 mMol/L 3728 0007-001 Chemistry 2 Potassium 21-May-12 3.0 UAZCC-North 15-May-12 3.8 5.9 mMol/L 3728 0007-001 Chemistry 2 Potassium 1-Jun-12 3.3 UAZCC-North 15-May-12 3.8 5.9 mMol/L Any suggestions on how to approach this?

djbateman · ‎10-03-2012

Is there a way to display axis tick marks using one measurement but display labels based on a different measurement? I have been asked to plot a Kaplan-Meier curve with the x-axis showing tick marks as weeks but labeling in months. This is not as simple as assuming that a month has exactly 4 weeks. I am using the formula: MONTHS=(WEEKS*7)/30.4375. Thus, 8 weeks will not appear as 2 months but rather 1.84 months. In other words, my labels will be slightly off of my tick marks as I attempt to display below: | | | | | | | | | | | | | | ... 0 1 2 13 ...

djbateman · ‎09-11-2012

I noticed that there was a scenario where the program was working properly, but when I made your suggested adjustment the labels got mixed up (the spaces were still there, but the "Patients at Risk" labels got shifted down). I guess I should leave both lines in the macro and manually comment/uncomment the needed lines on the rare occasions that it doesn't produce the desired output. Thank you for your help.

Online Status	Offline
Date Last Visited	7 hours ago

How to Compare a Merge ID Variable

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

Re: Retain Trailing Zeros in Numeric Variables

Retain Trailing Zeros in Numeric Variables

Re: ODS EXCEL Won't Automatically Adjust Row Height

Re: ODS EXCEL Won't Automatically Adjust Row Height

Re: ODS EXCEL Won't Automatically Adjust Row Height

Re: ODS EXCEL Won't Automatically Adjust Row Height

Re: How to Compare a Merge ID Variable

Re: How to Compare a Merge ID Variable

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

Re: Find Distinct Values in a Horizontal List

Re: Plotting Band Breaks in SGPLOT

Re: PROC IMPORT XLSX File and Specify Formats

Re: COMPRESS Function Modifier Warning

Force Arrow Head on HIGHLOW Plot HIGHCAP Option

Re: Converting XLSX to CSV in SAS

Convert .XPT to SAS Datasets

Re: New Library Window - Options

New Library Window - Options

Re: SGPLOT Produces HTML in Color but RTF in B&W

Re: SGPLOT Produces HTML in Color but RTF in B&W

Re: SGPLOT Produces HTML in Color but RTF in B&W

SGPLOT Produces HTML in Color but RTF in B&W

Re: Suppress LEGENDLABEL option

Suppress LEGENDLABEL option

Re: Default ProdcutLimitEstimates (PROC LIFETEST)

Default ProdcutLimitEstimates (PROC LIFETEST)

Re: Merging on Non-Identical Values

Re: Merging on Non-Identical Values

Merging on Non-Identical Values

Can Axis Labels Mismatch Axis Tick Marks?

Re: AXIS statement VALUE option