Dear all   I have the following data.  What do I need to do to flag rows 1 and 2 as they indeed happen at the same days and time (overlapping)?  I have been thinking but still cannot come up with SAS scripts to flag those two rows.  Any help is much appreciated.   Course section Meeting_days Beginning_time Ending_time CHEM 100 001 MWF 13:00 13:45 CHEM 100 007 MWF 13:15 13:45 CHEM 100 010 MWF 14:00 16:00 CHEM 100 021 MWF 9:00 10:00 ... View more

I was running logistic regression using SAS Miner.  My target variable had two values--"FAIL" and "PASS".  "PASS" was automatically chosen as the event.  However, I wanted to use "FAIL" as the event instead.  I was looking around, but could not find a way to select "FAIL" as the event.  Does anyone know how to?  Thank you in advance. ... View more

I wanted to export formulas from SAS to Excel, using ODS EXCEL.  However, the Excel file did not recognize the formulas.  It showed the formulas instead of the calculated numbers.  Does anyone know how to fix the problem?  Thank you. Below are the codes I used.  (You can run them if you have SAS 9.4.) ------------------------------------------- proc sql; create table cars as select distinct make, model, msrp, invoice from sashelp.cars where make = 'Audi' ; quit; data cars_b; set cars; row_num + 1; if first.make then row_num = 1; row_num_b = strip(put(sum(row_num,4),8.)); diff = '='||'C'||row_num_b||'-'||'D'||row_num_b; diff_b = compress(diff); run; options missing      = ' ' papersize    = letter topmargin    = 0.5 in leftmargin   = 0.5 in rightmargin  = 0.5 in bottommargin = 1.0 in ; ods excel file = 'I:\1 Academic Affairs\Faculty\1 Salary\FERIP\ODS EXCEL (test)\diff_in_prices.xlsx' style = normal options ( embedded_titles        = 'yes' embedded_footnotes     = 'yes' print_footer           = ' ' center_horizontal      = 'yes' absolute_column_width  = '8,30,12,12,12' fittopage              = 'no' pages_fitheight        = '100' orientation            = 'portrait' row_repeat             = '3-5' sheet_interval         = 'none'     sheet_name             = 'Diff' merge_titles_footnotes = 'yes' title_footnote_width   = ' ' ); title1 'XXX'; title2 'Difference in Price'; proc print data = cars_b label NOOBS; var make model msrp invoice diff_b; label diff_b = 'Difference'; run; footnote; ods excel close; ... View more

Right now, whenever I want to bring a data set from the server workspace to the local workspace,  I have to point and click on the data set to build a query and then choose the local server.  Are there any code lines that can achieve this task so that I can put them in my run and therefore do not have to do the point-and-click anymore? Thank you ... View more

I used proc gplot to produce the graph below.  As the out-of-state area (represented by gray dots) was smaller than the in-state area and was specified as the second layer, the line connecting the gray dots were somehow disappeared.  Do you know how to get the connecting line displayed in this particular case?  Thank you very much. -------------------------------------------------------------------------------------- Below are the codes I used: goptions /*reset=all*/ hsize=15cm vsize=12cm; pattern1 color=wheat; pattern2 color=brpk; symbol1 interpol=join value=dot h=1.5 color=bioy; symbol2 interpol=join value=dot h=1.5 color=gray; legend1 label=none value=(color=black height=1.5 'In-State' 'Out-of-State'); axis1 offset=(2,2)       label=(height=1.5 'Residency by %')       major=(height=2)       minor=(height=1); axis2 order=(0 to 100 by 20) offset=(0,0)       label=none       major=(height=2)       minor=(height=1); title1; proc gplot data=test4c; plot in_state*acad_year out_of_state*acad_year / line overlay haxis=axis1 hminor=4 vaxis=axis2 vminor=1 caxis=black areas=2 legend=legend1 ;run; quit; ... View more

I am currently on SAS EG 7.1 (SAS Base 9.4).  In my SAS EG configuration, I have two output windows: SAS Report and HTML.  I wanted to use the SPANROWS option in proc report, but the table did not display properly in SAS Report window.  It, however, did display well in the HTML window.  Below are the codes that I used.  You can copy and run it on your SAS EG.  (These codes were copied from http://blogs.sas.com/content/sastraining/2011/02/28/whats-so-great-about-spanrows/)  Can anyone tell me what was wrong with the SAS Report window?  Thank you. proc sort data=sashelp.shoes out=shoes;   where (product contains 'Casual') and (region = 'Canada' or region='Pacific');   by region product; run; proc report data=shoes nowd; title 'REPORT Default Behavior';   column region subsidiary product,(sales sales=savg);   define region / group style(column)=Header;   define subsidiary / group style(column)=Header;   define product / across 'Product Sales';   define sales / sum 'Sum' f=dollar10.;   define savg / mean 'Mean' f=dollar10.;   rbreak after / summarize style=Header; run; proc report data=shoes nowd SPANROWS; title 'REPORT Output with SPANROWS';   column region subsidiary product,(sales sales=savg);   define region / group style(column)=Header;   define subsidiary / group style(column)=Header;   define product / across 'Product Sales';   define sales / sum 'Sum' f=dollar10.;   define savg / mean 'Mean' f=dollar10.;   rbreak after / summarize style=Header; run; ... View more