Dear Cyntia, Thanks a lot for the reply. I will look into the code over the weekend. Unfortunately, it seems SVG needs to be converted to PDf to be included in a .tex file. What I have adopted for now is this workflow EG and PROC Gplot -> Export to EMF -> Convert to PDF using Acrobat. I think the same can be used with SVG however I haven't tested it extensively. EMF and SVG are both vector graphics formats. An interesting sidenote, I tried PROC SGPLOT on my data and it seems to produce those nice PDF graphs quite easily, however I can't use it in EG and I'm not very familiar with syntax to produce high quality academic graphs. Thank you, Arsenio ... View more

Cyntia, Thanks for the quick reply! I was working in EG, so when it didn't output the vector graphics in PDF ( the graphs were rasterized and pixelized), for example when using Active Image for SAS V9, i had to start tinkering with the code produced by EG and searching for clues online. How would you output that vector graphics pdf with page fit to graph using your 2nd method, the classic SAS/GRAPH proc gplot? In STATA, I think it's a bit more straightforward, and graphs can be exported to vector pdf with page fit to graph automatically. Thank you, Arsenio ... View more

OP and Cyntia, That's exactly the question I have after battling with SAS for 2 days. A scalable vector graphics output to PDF with neat cropped margins where the graph or plot fits the PDF that can be included in latex document. SAS can do that in: ods graphics / outputfmt=pdf imagename="BarChart"; proc sgplot data=sashelp.class; vbar age / response=height stat=mean; run; But after 12 hours I can't reproduce that for proc gplot for something like 2 time series plot below (sorry no reproducible data but it gives something like : OPTIONS NODATE NONUMBER REPLACE; OPTIONS DEV=SASEMF; goptions cback=white ymax=4in xmax=6in hsize=6in; ods listing sge=on; ods listing gpath="T:\My Docs\My SAS 9.2 Enterprise Guide Files\SCRAP" ; ods graphics / imagefmt=PDF outputfmt=pdf imagename="BarChart"; ods printer dpi=300 nopdfnote  pdf file="T:\My Docs\My SAS 9.2 Enterprise Guide Files\SCRAP\BarChart" ; PROC GPLOT DATA = WORK.SORTTempTableSorted ; PLOT equiv_dvol_total_ST * DATE_f equiv_dvol_total_ST_max * DATE_f  / OVERLAY     VAXIS=AXIS1     HAXIS=AXIS2 FRAME    SKIPMISS     LHREF=1     CHREF=CX969696     HREF="01jan04"D TO "01jan11"D BY year     LEGEND=LEGEND1 ;     LABEL DATE_f="Time (days)"         equiv_dvol_total_ST="Equivalent Volume (average)"         equiv_dvol_total_ST_max="Equivalent Volume (max)"; /* -------------------------------------------------------------------   End of task code.   ------------------------------------------------------------------- */ RUN; QUIT; I attached the resulting plot as .pdf, it's a graph plastered on the page and inserting that in latex inserts the whole page with the white space below. Any idea how this can be solved? It's very close to that thread as well, , pretty much what happens when SAS meets academic work with vector graphics plots in latex. Thank you!! Arsenio ... View more

Still haven't been able to figure it out. It's a rather strange coercion given that both SAS and Stata support mixed case var naming. Any advice? ... View more

Tried this, now it worked and used CEDA and mentions that the dataset is native to a different host. 16         data etf.EQUIV_VOL_Daily_EXCL1 (outrep=Linux); 17                 set work.equiv_volume_dailyandintra_excl ; 18             19         20         run; NOTE: Data file ETF.EQUIV_VOL_DAILY_EXCL1.DATA is in a format that is native to another host,       or the file encoding does not match the session encoding. Cross Environment Data Access       will be used, which might require additional CPU resources and might reduce performance. NOTE: There were 218927 observations read from the data set       WORK.EQUIV_VOLUME_DAILYANDINTRA_EXCL. NOTE: The data set ETF.EQUIV_VOL_DAILY_EXCL1 has 218927 observations and 68 variables. NOTE: DATA statement used (Total process time):       real time           7.01 seconds       cpu time            0.74 seconds However still when importing into R the host is read as W32_7PRO. Still thanks a lot for the outrep option! ... View more

The previous reply window froze on me and didnt let me type anything, so here is the error text from R (not from SAS), Error in read.sas7bdat("e:/............................/EQUIV_VOL_Daily_EXCL1.sas7bdat") :   unknown host W32_7PRO please report bugs to ............................. So apparently I assume that SAS 9.3 added a new category table or some sort of platform id. I wish i could dig into SAS7BDAT meta structure. Thanks, A ... View more

Hey Ksharp, Thanks for the reply! I tried to run this in the data step data etf.EQUIV_VOL_Daily_EXCL1;         set work.equiv_volume_dailyandintra_excl (outrep=Linux); run; But it doesn't seem to work.. In log it writes 14         15         GOPTIONS ACCESSIBLE; 16         data etf.EQUIV_VOL_Daily_EXCL1; 17                 set work.equiv_volume_dailyandintra_excl (outrep=Linux);                                                        ______                                                        70 WARNING 70-63: The option OUTREP is not valid in this context.  Option ignored. 18              /* by ticker date; 19              if first.date NE 1 then delete; */ 20         21         run; This is for sas7bdat package for R, which apparently doesn't do well with some changes in SAS 9.3, idk what happened but now it gives me that error ... View more

BruceBrad, I got the same error, when trying      ods html image_dpi=600; Any idea how you corrected this sashtml.htm error? Thanks! ... View more

Hey Ksharp, Been a long time since my rolling correlation question! Anyway, thanks for the reply! i have been testing that code. So the work.temp comes out as: count _ticker Date PX_LAST PX_LOW PX_HIGH VOLUME flag 1 AA UN 0 3 Equity 0 5 #NAME? 40.4688 40.1875 41.7813 2705600 0 7 1/4/2000 40.6563 40.1875 40.9063 4112400 0 9 1/5/2000 43 40.5 43.25 5844600 0 11 1/6/2000 42.4375 42.4063 43.1875 8595200 0 13 1/7/2000 42.625 42.2813 43.4375 7026800 0 2 AIG UN 1 4 Equity 1 6 #NAME? 1160.9274 1150.456 1200.0206 151718 1 This is an  already shifted and stacked version of the original table, right? Nice reminder on retain! From there your code works great. Fills the ticker with the ticker name for the corresponding observations. Any way to convert it to that already stacked form you started with? Thanks! Arsenio ... View more