cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
djbateman
yesterday
  • 345 Posts
  • 11 Likes Given
  • 9 Solutions
  • 28 Likes Received

Re: character to date

by Lapis Lazuli | Level 10 in SAS Programming
‎05-28-2015 01:21 PM
‎05-28-2015 01:21 PM
Can you give an example (or two) of what DATEINCHAR looks like and what you want DATE_SAS to look like? ... View more

Change Missing Value Character?

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎05-28-2015 01:11 PM
‎05-28-2015 01:11 PM
Is it possible to change the character for a missing value?  I am outputting a table of data with PROC REPORT, and my columns are numeric.  When the report is generated and there is a missing value, it displays a ".", which I don't want.  Is it possible to get SAS to display an empty cell without converting everything to character variables? ... View more

Many to Many Merge - Exclude Based on Date Range

by Lapis Lazuli | Level 10 in SAS Programming
‎04-13-2015 10:13 AM
‎04-13-2015 10:13 AM
I have 2 tables with multiple dates per subject.  If the date in TABLE2 occurs within 28 days prior to the date in TABLE1, then the date in TABLE1 cannot be used.  My original plan was to transpose TABLE2 by SUBJID so that there is a column for each date and then loop through each SUBJID in TABLE1 with each column in the transposed TABLE2 to see if the TABLE1 date would fall within the exclusion range with any column of TABLE2.  I can't imagine that that is the most efficient method.  Does anyone have any better ideas? Here is a sample of what I have: TABLE1 SUBJID CA125DT 0001-3314 24-Sep-12 0001-3314 22-Oct-12 0001-3314 5-Nov-12 0001-3314 19-Nov-12 0001-3314 17-Dec-12 0001-3314 14-Jan-13 0001-3314 11-Feb-13 0001-3314 15-Feb-13 0008-4146 15-Oct-12 0014-4387 27-Dec-13 0014-4387 10-Feb-14 0014-4387 21-Mar-14 0014-4387 23-May-14 0020-0020 1-Jul-13 0020-0020 26-Aug-13 0020-0020 3-Sep-13 0020-0093 3-Mar-14 0020-0093 31-Mar-14 0020-0093 14-Apr-14 0020-0093 12-May-14 0020-0093 10-Jun-14 0020-4142 17-Sep-11 TABLE2 SUBJID STDT 0001-3314 19-Jul-12 0001-3314 31-Aug-12 0001-3314 24-Oct-12 0001-3314 19-Nov-12 0001-3314 21-Dec-12 0001-3314 18-Jan-13 0001-3314 22-Feb-13 0001-3314 9-Mar-13 0008-4146 21-Aug-12 0008-4146 31-Aug-12 0008-4146 12-Sep-12 0008-4146 21-Sep-12 0008-4146 27-Sep-12 0008-4146 9-Oct-12 0008-4146 19-Oct-12 0008-4146 26-Oct-12 0008-4146 8-Nov-12 0014-4387 8-Nov-13 0014-4387 26-Nov-13 0014-4387 4-Dec-13 0020-0020 2-Jul-13 0020-0020 29-Jul-13 0020-0020 5-Sep-13 0020-0093 28-May-14 0020-4142 13-Sep-11 If you were to go line by line, you should see that the following dates are usable from TABLE1: SUBJID CA125DT 0001-3314 22-Oct-12 0014-4387 21-Mar-14 0014-4387 23-May-14 0020-0020 1-Jul-13 0020-0020 3-Sep-13 0020-0093 3-Mar-14 0020-0093 31-Mar-14 0020-0093 14-Apr-14 0020-0093 12-May-14 ... View more

Re: GTL Legend Different from Plot

by Lapis Lazuli | Level 10 in Graphics Programming
‎03-26-2015 04:07 PM
‎03-26-2015 04:07 PM
Thank you, Sanjay!  I had tried something similar to this before, but when I overlaid the color on top of the black, it almost looked like the X's had been bolded.  I tried it again, and it wasn't too bad.  I think it was because I didn't specify an exact black color but rather used a default lighter black (dark gray or sorts). ... View more

Re: GTL Legend Different from Plot

by Lapis Lazuli | Level 10 in Graphics Programming
‎03-26-2015 03:55 PM
‎03-26-2015 03:55 PM
I'm using SAS 9.3. ... View more

Re: GTL Legend Different from Plot

by Lapis Lazuli | Level 10 in Graphics Programming
‎03-26-2015 03:22 PM
‎03-26-2015 03:22 PM
This is almost identical to the second PROC TEMPLATE I had.  It does put just a single black X in the legend, but the X's on the plot are also black.  I am trying to keep the legend the way you provided it but still have the X's to stay color coded like the bars by the POSNEG variable. ... View more

GTL Legend Different from Plot

by Lapis Lazuli | Level 10 in Graphics Programming
‎03-26-2015 01:25 PM
‎03-26-2015 01:25 PM
I am trying to add a legend to my plot that does not exactly match the data that I am plotting.  Sorry for the lengthy code, but I wanted you to have all my information.  I am probably giving more than is needed.  Simply put, I want to color code the plotting markers, but I only want 1 black marker to appear in the legend with a set label. proc format;             value posneg                         1='Positive'                         2='Negative'                         9='Non-Evaluable'; run; data waterfall;             input SUBJECT LESID POSNEG BESTPCT @@;             format posneg posneg. bestpct percent9.2;             cards; 1010     1          1          -0.269   1020     1          1          -0.235 1020     2          1          -0.043   1020     3          1          -0.167 1020     4          1          -0.03     1050     1          9          0.077 1060     1          9          .                       1060     2          1          -0.25 1060     3          2          -0.059   1060     4          1          -0.111 1060     5          1          -0.24     1070     1          2          0 1080     1          1          .                       1080     2          2          . 1080     3          1          .                       1080     4          1          . 1090     1          1          -0.125   1110     1          1          0.179 1110     2          1          -0.056   1120     1          2          0 1120     2          2          -0.211   4010     1          2          -0.022 4010     2          2          1.344    2010     1          9          0.462 2020     1          1          0.217    2030     1          1          0.4 2030     2          1          0.174    2040     1          1          0.091 2040     2          1          0.1                    2050     1          9          0.2 2050     2          1          0.917    2060     1          1          . 2060     2          1          .                       2060     3          1          . 2060     4          1          .                       2060     5          1          . ; run; proc sort data=waterfall;             by posneg descending bestpct; run; data waterfall;             set waterfall;             n=_n_;             if bestpct=. then scattermissing=0;             label scattermissing='No Post-Baseline Assessment'; run; /* Determine the range and tick values of the y-axis for plotting */ data tickvalues;             do VALUE=-1 to &yaxismax. by 0.2;                         output;             end;             format value 5.1; run; proc sql noprint;             select value into :tickvaluelist separated by ' ' from tickvalues;             select (ceil(max(&yvar.)/0.2))*0.2 into :yaxismax from waterfall; quit; I want the plot to look like this one (X's color coded based on POSNEG): proc template;             define statgraph barscatter;                         begingraph;                                     entrytitle 'Best Percent Change in Lesion Size';                                     layout overlay / xaxisopts=(display=none) yaxisopts=(label="&ylab." linearopts=(viewmin=-1.05 viewmax=%sysevalf(&yaxismax.+.05) tickvaluelist=(&tickvaluelist.)));                                                 barchart x=n y=bestpct / group=posneg name='b';                                                 scatterplot x=n y=scattermissing / group=posneg markerattrs=(symbol=X) name='s';                                                 referenceline y=eval(coln(0.2, -0.3)) / lineattrs=(color=black pattern=dot);                                                 discretelegend 'b' 's' / across=1 autoalign=(bottomleft) location=inside;                                     endlayout;                         endgraph;             end; run; proc sgrender data=waterfall template=barscatter; run; But I want the legend to look like this one (only 1 black marker for SCATTERMISSING with the "No Post-Baseline Assessment" label): proc template;             define statgraph barscatter;                         begingraph;                                     entrytitle 'Best Percent Change in Lesion Size';                                     layout overlay / xaxisopts=(display=none) yaxisopts=(label="&ylab." linearopts=(viewmin=-1.05 viewmax=%sysevalf(&yaxismax.+.05) tickvaluelist=(&tickvaluelist.)));                                                 barchart x=n y=bestpct / group=posneg name='b';                                                 scatterplot x=n y=scattermissing / markerattrs=(symbol=X) name='s';                                                 referenceline y=eval(coln(0.2, -0.3)) / lineattrs=(color=black pattern=dot);                                                 discretelegend 'b' 's' / across=1 autoalign=(bottomleft) location=inside;                                     endlayout;                         endgraph;             end; run; proc sgrender data=waterfall template=barscatter; run; ... View more

Connect 2 Plots into a Single 3D Plot

by Lapis Lazuli | Level 10 in Graphics Programming
‎03-05-2015 08:58 AM
‎03-05-2015 08:58 AM
One of my company's VPs just sent me the horrible-quality plot that I have attached below and asked me to replicate it with some of our own study data.  I am not sure where to start.  I am fairly new to SAS graph.  Basically, the blue bars represent a waterfall plot where the x-axis is an individual patient and the y-axis is the best percent change in tumor volume.  The green bars represent a swimmer plot where the x-axis is again the individual patients and the z-axis is the time on study.  Normally, I make both plots in PROC SGPLOT using the needle statement for the waterfall plot and the highlow statement for the swimmer plot.  I don't expect anyone to do the coding for me, but can someone point me in the right direction on how to attache the 2 plots into a single 3D image? ... View more

Re: rename a bunch of variables

by Lapis Lazuli | Level 10 in SAS Procedures
‎03-04-2015 04:35 PM
‎03-04-2015 04:35 PM
I figured it out.  I needed to use the %str() functionality for the parameters of the tranwrd() function: data product;       product_a='blah';       product_b='blah';       product_c='blah';       product_d='blah';       product_e='blah';       product_f='blah'; run; proc sql;      select compress(put(count(name),best.)) into :nvars from sashelp.vcolumn where libname="WORK" & memname="PRODUCT";      select name into :var1-:var&nvars. from sashelp.vcolumn where libname="WORK" & memname="PRODUCT"; quit; option mprint; %macro ChangeVarName; data product;      set product;      %do i=1 %to &nvars.; rename &&var&i. = %sysfunc(tranwrd(&&var&i.,%str(product),%str(xml)));      %end; run; %mend ChangeVarName; %ChangeVarName; option nomprint; ... View more

Re: rename a bunch of variables

by Lapis Lazuli | Level 10 in SAS Procedures
‎03-04-2015 04:12 PM
‎03-04-2015 04:12 PM
Assuming that the variables are in a table called PRODUCT in the WORK library, I would use dictionary tables to get the variable names and then run through a macro loop using the TRANWRD() function to change all the names like this: data product;       product_a='blah';       product_b='blah';       product_c='blah';       product_d='blah';       product_e='blah';       product_f='blah'; run; proc sql;      select compress(put(count(name),best.)) into :nvars from sashelp.vcolumn where libname="WORK" & memname="PRODUCT";      select name into :var1-:var&nvars. from sashelp.vcolumn where libname="WORK" & memname="PRODUCT"; quit; option mprint; %macro ChangeVarName; data product;      set product;      %do i=1 %to &nvars.; rename &&var&i. = %sysfunc(tranwrd(&&var&i.,'product','xml'));      %end; run; %mend ChangeVarName; %ChangeVarName; option nomprint; There is a bug in this with the tranwrd function.  Maybe someone else on this forum can help me correct it if you can't see my mistake on your own. ... View more

Re: Send e-mail with Hyperlink

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-04-2015 03:50 PM
‎03-04-2015 03:50 PM
Quentin, My e-mail is set to compose in HTML.  I can create the report as you stated, but after you create it, do you attach it to the e-mail, or does it show up in the body of the e-mail?  I am currently attempting this, which provides an attachment: data me;   input link $200.;   cards; www.sas.com \\share\directory\blah.txt ; run; ods html file="d:\junk\me.html"; proc report data=me nowd;   column link;   compute link;         call define(_col_,'URL',link);   endcomp; run; ods html close; filename mail email   to=("someone@somewhere.com")   subject="Test e-mail with Hyperlink"   attach=("d:\junk\me.html"); data _null_;      file mail;      put "Here is a test to see if hyperlinks work in an e-mail sent from SAS:"; run; ... View more

Re: Send e-mail with Hyperlink

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-04-2015 02:18 PM
‎03-04-2015 02:18 PM
I attempted to add the "http://" in front of my URL, but it still didn't work.  I'll have to contact tech support, I guess. And hyperlinks aren't just for HTTP addresses.  You can hyperlink webpages, e-mail addresses, file directories, or even specific places in a document.  I often hyperlink my directories manually for coworkers.  When I have a folder for them to view, I can copy and paste the directory into an e-mail, highlight that directory, right-click and select Edit Hyperlink.  In the address, I just paste the directory again.  When they receive the e-mail, they see the name of the directory with a hyperlink that when clicked opens an explorer window taken directly to the folder that I want them to view.  It would be nice to have that functionality directly in SAS. ... View more

Send e-mail with Hyperlink

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎03-04-2015 09:35 AM
‎03-04-2015 09:35 AM
I want to send an e-mail from within SAS that includes a hyperlink.  I have found several discussions on this, but they are from 2011 and earlier.  Their suggestions don't even work--at least not on my system.  Have things changed over the last 4-5 years where I can easily add hyperlinked text to the body of an e-mail?  They hyperlink may not necessarily be a URL but rather a file directory.  I know the snipet below won't add hyperlinks, but I want to show what I am trying to do. filename mail email      to=("someone@somewhere.com")      subject="Test e-mail with Hyperlink"; data _null_;      file mail;      put "Here is a test to see if hyperlinks work in an e-mail sent from SAS:"      put " ";      put "URL:  www.sas.com";          /* hyperlink web address */      put "Directory: C:\Users\Public";     /* hyperlink path */ run; ... View more

Re: PROC COMPARE - Keep New or Changed Observations

by Lapis Lazuli | Level 10 in SAS Procedures
‎03-02-2015 01:05 PM
‎03-02-2015 01:05 PM
Yes, I have already written a program to compare them myself.  I was just hoping for a more efficient way.  But thank you anyway! ... View more

PROC COMPARE - Keep New or Changed Observations

by Lapis Lazuli | Level 10 in SAS Procedures
‎03-02-2015 11:49 AM
‎03-02-2015 11:49 AM
I have a dataset that I created last week, and I have a new dataset that I created this week.  I want to compare the two tables and only keep the observations in the new table that are either new or had a change.  Is there a way to retain the ID values that correspond to any new or changed observations?  For example, in the datasets below, I would like to create a new table that only keeps IDs 003 (added SEX and changed LASTVISIT), 005 (changed LASTVISIT), 006 (new observation), and 007 (new observation).  I have looked through the documentation to see what my options are with output tables, but the output tables are not very usable for my needs. data old;             input ID $ AGE SEX $ 9-10 LASTVISIT;             informat lastvisit date9.;             format lastvisit date9.;             cards; 001       37         M         15JAN2015 002       29         M         29JAN2015 003       64                      12FEB2015 004       52         M         24FEB2015 005       49         F          20FEB2015 ; run; data new;             input ID $ AGE SEX $ LASTVISIT;             informat lastvisit date9.;             format lastvisit date9.;             cards; 001       37         M         15JAN2015 002       29         M         29JAN2015 003       64         F          12FEB2015 004       52         M         24FEB2015 005       49         F           27FEB2015 006       50         F          26FEB2015 007       56         F          27FEB2015 ; run; Desired Results: ID AGE SEX LASTVISIT 003 64 F 12FEB2015 005 49 F 27FEB2015 006 50 F 26FEB2015 007 56 F 27FEB2015 ... View more
Contact Me
Online Status
Offline
Date Last Visited
yesterday
Likes given to
View All
Likes from
Quick links