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: 
Andre
‎09-01-2015
  • 273 Posts
  • 1 Likes Given
  • 0 Solutions
  • 41 Likes Received

Re: ods tagsets.excelxp - one excel with few worksheets

by Obsidian | Level 7 in SAS Programming
‎12-06-2012 06:56 AM
‎12-06-2012 06:56 AM
I was submitting under sas 9.3.2  with tagsets excelxp v1.130, 05/01/2012" and after reading the comment of the maintainer inside the code, i did not see any comment about a correction of sheetname. So i suggest that you change your locale hebrew?  code in the sheetname into english one to see if there is some change in the behavior otherwise refer to the sas support help Andre ... View more

Re: ods tagsets.excelxp - one excel with few worksheets

by Obsidian | Level 7 in SAS Programming
‎12-06-2012 06:46 AM
‎12-06-2012 06:46 AM
With this test, i have only ONE file  (xml opened under excel2010) ods results off; * ods listing close; ods tagsets.excelxp file="d:\temp\tworeally.xls" style=sasweb ; ods tagsets.excelxp options(sheet_name='parameters'); proc print data=sashelp.class noobs;run;quit; ods tagsets.excelxp options(sheet_name='pen_r'); proc print data=sashelp.air noobs;  run;quit; ods tagsets.excelxp close; So     scratch the two files and try again ... View more

Re: ods tagsets.excelxp - one excel with few worksheets

by Obsidian | Level 7 in SAS Programming
‎12-06-2012 06:37 AM
‎12-06-2012 06:37 AM
quick hypothesis : are you sure you were submitting the first quit; ? ... View more

Re: ods pdf

by Obsidian | Level 7 in SAS Programming
‎12-05-2012 07:47 AM
‎12-05-2012 07:47 AM
mjack, the rules for title are old and with limits but with ods pdf text=   you have a lot of possibilities ods escapechar='^'; options  nodate; title font=Courier h=0.5cm italic j=l "where"  font=Times bold h=0.7cm j=r "heavy" ; ods pdf file="d:\temp\title.pdf"  style=journal; ods pdf text=  " oui ^{style [just=l font_weight=bold font_size=10pt] Country}          ^{style [just=r font_style=italic font_weight=light font_width=narrow font_size=15pt] State  City}"; proc print data=sashelp.class(obs=3); run; ods pdf close; Andre for title  the rules are at http://support.sas.com/kb/24/853.html ... View more

Re: ODS HTML to generate Excel

by Obsidian | Level 7 in ODS and Base Reporting
‎12-04-2012 06:51 AM
‎12-04-2012 06:51 AM
Maggi proc print data=...   style(table)={background=white} is i think the answer for proc print Andre ... View more

Re: Macro Variable-can't be raised to a power!!!

by Obsidian | Level 7 in SAS Programming
‎12-03-2012 11:38 AM
‎12-03-2012 11:38 AM
Raghu %let calc=%sysevalf(10**&b0.); PROC NLIN Data=Prob20;     Parms gamma0 = &calc.    gamma3=&B3;     MODEL Y=gamma0*X3**(gamma3); RUN; Try this the return is without error for me except the table which is not existing. the macro variable calc contain the exact TEXT that will be substituted in your parms instruction AS Macro variable contains always text and as it seems that  exponient is not allowed 74   Parms gamma0 =11**1 gamma3=&B3; ERROR 200-322: The symbol is not recognized and will be ignored ... View more

Re: statgraphics and latex destination

by Obsidian | Level 7 in Graphics Programming
‎11-14-2012 12:00 PM
‎11-14-2012 12:00 PM
After having checked other documents and Tex users, it seems that the Tex community has switched to the pdf include  for many things So even if i have produced epsi image files with sas in place of ps postscript image files i used Ghostscript to convert them into pdf files and was inserting my restults with Latex code like \includegraphics[width=\textwidth,keepaspectratio=false]{fragment01.pdf} for a  ods select  + ods pdf single page \begin{figure} \includegraphics[scale=1.2]{ddPlot6.pdf} \end{figure} for the converted Ghostcript \input{fragment02.tex} for tex pur code (with ods notop nobot options) and \begin{figure} \includegraphics{ps/RDPlot.png} \end{figure} for the insert of the initial and by default  png file   under 9.3.2 Any comments are usefull Andre ... View more

Re: statgraphics and latex destination

by Obsidian | Level 7 in Graphics Programming
‎11-14-2012 06:33 AM
‎11-14-2012 06:33 AM
\includegraphics{fragment01.pdf} \sascontents[3]{Residual by Distance} \includegraphics[width=\textwidth]{ps/DDPlot.png} Those tex code lines are indirect ways to insert graphics and are accepted under Miktek2.9   with the Winedt editor but i have had to produce them under supplemental ods steps but for .ps files (native ods latex sas production who know the solution? Andre Andre ... View more

statgraphics and latex destination

by Obsidian | Level 7 in Graphics Programming
‎11-14-2012 06:10 AM
‎11-14-2012 06:10 AM
With this code (under 9.3.2) libname tex "d:\notes\latex\"; data stack;    input  x1 x2 x3 y exp $ @@;    datalines; 80  27   89  42   e1   80  27   88  37   e2 75  25   90  37   e3   62  24   87  28   e4 62  22   87  18   e5   62  23   87  18   e6 62  24   93  19   e7   62  24   93  20   e8 58  23   87  15   e9   58  18   80  14  e10 58  18   89  14  e11   58  17   88  13  e12 58  18   82  11  e13   58  19   93  12  e14 50  18   89   8  e15   50  18   86   7  e16 50  19   72   8  e17   50  19   79   8  e18 50  20   80   9  e19   56  20   82  15  e20 70  20   91  15  e21 ; run; options nodate nonumber; title ; ods latex path="d:\notes\latex\"           gpath="d:\notes\latex\ps" (url='ps/') style=journal2; ods trace on; proc robustreg data=stack plots=(rdplot ddplot histogram qqplot);    model y = x1 x2 x3; run; ods trace off; ods latex close; i obtain a a sasltx.ltx file and 4 graphics (.ps) into the designed ps subdirectory this based upon   www2.sas.com/proceedings/sugi29/204-29.pdf  example5 of Rodriguez Does anybody know how to insert the correct call for those postscript file into a Tex editor? as sas code  has produced .... %\let\sasgraph\includegraphics % Scale graphics so they always fit on the page \newcommand\sasgraph[2][]{%    \savebox{\sas@fig}{\includegraphics[#1]{#2}}%    \settowidth{\sas@figwidth}{\usebox{\sas@fig}}%    \ifthenelse{\lengthtest{\sas@figwidth > \textwidth}}{%       \resizebox{0.95\textwidth}{!}{\usebox{\sas@fig}}}{%       \usebox{\sas@fig}} } ... and further \sascontents[3]{Residual by Distance} \sasgraph{ps/RDPlot7.ps} \sascontents[3]{Distance by Distance} \sasgraph{ps/DDPlot7.ps} \sascontents[3]{Residual Histogram} \sasgraph{ps/Histogram9.ps} \sascontents[3]{Residual Q-Q Plot} \sasgraph{ps/QQPlot7.ps} but the compilation return a non recognition of the .ps type of files ! LaTeX Error: Unknown graphics extension: .ps. (I know that i can include those (whole pages) with a \includepdf     after having produced them through a pdf desdtination but how to do following the basic sas latex production? TIA Andre "a non expert in tex and latex  but i must help  somebody else" ... View more

Re: select on unique character codes from a column and generate a repo...

by Obsidian | Level 7 in SAS Programming
‎09-14-2012 05:11 AM
‎09-14-2012 05:11 AM
Ok Joe, i have corrected my mistake and was able to see the result. Andre ... View more

Re: ODS- Saving Excel file

by Obsidian | Level 7 in ODS and Base Reporting
‎09-11-2012 05:41 AM
3 Likes
‎09-11-2012 05:41 AM
3 Likes
This was already discussed in https : // communities . sas . com / message/40494#40494 Andre ... View more

Re: select on unique character codes from a column and generate a repo...

by Obsidian | Level 7 in SAS Programming
‎09-11-2012 04:32 AM
‎09-11-2012 04:32 AM
Joe, I was  surprised by your code, as it is completely new for me! but when i tried it , i encounter difficulties even after adding a data _null_; in the head (i use 9.3.0 under windows) What is the correction, just to see the final production. Andre see further: 112  options nonumber nodate nocenter; 113  ods listing close; 114  ods pdf file="d\notes\test\WTable.pdf" notoc; NOTE: Writing ODS PDF output to DISK destination       "d:\My SAS Files\9.3\d\notes\test\WTable.pdf", printer "PDF". 115  data _null_; 116  declare odsout summ(); 117         summ.title(text:"Wendy's Desired Table of Code Frequencies  " ||" 117! %sysfunc(today(),mmddyy10.)"); 118         summ.layout_gridded(columns:1); 119                summ.region(); 120                       summ.table_start(); 121                             summ.row_start(); 122                                    summ.format_cell(inhibit:"TLR", text: "CODE", 122! overrides:"cellwidth=4cm just=center"); 123                                    summ.format_cell(inhibit:"TLR", text: "COUNTS", 123! overrides:"cellwidth=4cm just=center"); 124                                    summ.format_cell(inhibit:"TLR", text: "NOBS", 124! overrides:"cellwidth=4cm just=center"); 125                                    summ.format_cell(inhibit:"TLR", text: "PERCENTS", 125! overrides:"cellwidth=4cm just=center"); 126                             summ.row_end(); 127                       summ.table_end(); 128                       summ.table_start(); 129                       summ.line(); 130                             do while(hicod.next() eq 0);                                          ----------                                          557 ERROR: DATA STEP Component Object failure.  Aborted during the COMPILATION phase. ERROR 557-185: Variable hicod is not an object. NOTE: The SAS System stopped processing this step because of errors. NOTE: L'étape DATA used (Total process time):       real time           0.08 secondes       cpu time            0.03 secondes 131                             summ.row_start(); 132                                    summ.format_cell(inhibit:"BTLR", text: code, 132! overrides:"cellwidth=4cm just=center"); 133                                    summ.format_cell(inhibit:"BTLR", text: codecount, 133! overrides:"cellwidth=4cm just=center"); 134                                    summ.format_cell(inhibit:"BTLR", text: datasize, 134! overrides:"cellwidth=4cm just=center"); 135                                    summ.format_cell(inhibit:"BTLR", text: percents, 135! overrides:"cellwidth=4cm just=center"); 136                             summ.row_end(); 137                             end; 138                       summ.table_end(); 139                       summ.line(); 140               summ.region(); 141          summ.layout_end(); 142  stop; 143  run; 144  ods pdf close; NOTE: ODS PDF printed no output.       (This sometimes results from failing to place a RUN statement before the ODS PDF CLOSE       statement.) ... View more

Re: Change style of summary line in PROC REPORT

by Obsidian | Level 7 in ODS and Base Reporting
‎08-16-2012 05:46 AM
‎08-16-2012 05:46 AM
here with a litle test Proc format; value rbrone low-high='PINK'; value rbrtwo low-high='BROWN'; run; proc report data=sashelp.class nowd; columns sex name age height weight ; define sex / order; define name / display; define  age / display; define height / analysis; define weight / analysis; break after sex / summarize suppress style={background=yellow}; rbreak after     / summarize skip style={background=gray}; compute after; if _break_='_RBREAK_' then do; call define ('_C4_','style','style={foreground=rbrtwo.}'); call define ('_C5_','style','style={foreground=rbrone.}'); end; endcomp; run; quit; ... View more

Re: Change style of summary line in PROC REPORT

by Obsidian | Level 7 in ODS and Base Reporting
‎08-16-2012 04:38 AM
‎08-16-2012 04:38 AM
Scott, i think that traffic  colors may apply through this kind of code compute actual; if _break_='SEX' then do; call define ('_C4_','style','style={foreground=fmtfor.    font_style=   font_weight= }'); call define ('_C5_','style','style={foreground=fmtfor.    font_style=   font_weight= }'); end; else if _break_='_RBREAK_' then do; other cal define for the columns end; endcomp; HTH but not tested Andre ... View more

Re: reset result for print

by Obsidian | Level 7 in Graphics Programming
‎08-10-2012 03:20 AM
‎08-10-2012 03:20 AM
Peter , you are right Key + macro  = keyboard macro  with plenty of space! Andre typo   %sysfunc  in place of $sysfunc  of  course  sorry ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Likes from
Quick links