About hollandnumerics

hollandnumerics · ‎09-03-2019

sks521, Unfortunately CSV files have to be imported as whole records, but you can then just keep your required set of the variables. Use a KEEP statement in your DATA step, or use (KEEP= ) on the DATA statement.

hollandnumerics · ‎09-03-2019

PY, I think you have missed out the response= part of the template. If you try using my PIE2 template instead, then, using your supplied data set code, your pie chart will look like the one below: PROC TEMPLATE; DEFINE STATGRAPH pie2; BEGINGRAPH; LAYOUT REGION; PIECHART CATEGORY = structure response = anz / group=month stat = sum DATALABELLOCATION = OUTSIDE DATALABELCONTENT = ALL CATEGORYDIRECTION = CLOCKWISE START = 180 NAME = 'pie'; DISCRETELEGEND 'pie' / TITLE = 'Anzahl der Anträge'; ENDLAYOUT; ENDGRAPH; END; RUN; proc sgrender data=Beispiel template = pie2; run; Enjoy!..............Phil

hollandnumerics · ‎09-02-2019

MVras, Please could you post the code you used to create the included plot?

hollandnumerics · ‎09-02-2019

PierreYvesILY, Please could you post a copy of the Beispiel, or a similar, data set so we can test your code?

hollandnumerics · ‎09-02-2019

srikanthyadav44, SAS University Edition is sensitive to the version of Virtual Box. I would recommend reading the instructions on the SAS University Edition web page and installing the correct version.

hollandnumerics · ‎09-02-2019

shubhamtiwari, What do you want to get using a SAS voucher or Promo Code? SAS University Edition can be downloaded for free!

hollandnumerics · ‎09-02-2019

sks521, Do you know where in the input records these variables are located? INPUT @aa var1 @bb var2 @cc var3; will input variables at columns aa, bb and cc.

hollandnumerics · ‎07-05-2019

Cynthia, I can confirm that LibreOffice can read and create XLSX files directly, and I do use that facility on a regular basis, but there are public organisations, and even governments, internationally that have standardised on the OpenDocument file formats. I've done a fair amount of investigation into the structure and contents of XLSX and *.ods files, and concluded that the Open Source *.ods files, which can also be read by newer versions of Excel, should be smaller and hold more precise numeric values (including dates and times) than the equivalent XLSX files. Surely it would be better to support an Open Source file format, than a proprietary one, especially when it has size and precision advantages, and no readability issues? ........Phil

hollandnumerics · ‎07-03-2019

Another option occurred to me this evening: could you use PROC JLAUNCHER to create a LibreOffice Calc file from a SAS data set, as there are Java frameworks available to create such files?

hollandnumerics · ‎07-03-2019

At NESUG 2007 Eric Gebhart suggested that ODS Markup (https://lexjansen.com/nesug/nesug07/np/np08.pdf) could be used to create ODS destinations for Microsoft Office Open and Oasis Open Document Format (created by LibreOffice and OpenOffice). It is now 2019 and we have ODS EXCEL, POWERPOINT and WORD, but nothing for LibreOffice Calc. However, I think I know why it hasn't happened, as my attempts to combine tagsets with ODS PACKAGE to create zipped XML files have surfaced a "feature" which limits the XML files concurrently created to just 2, whereas LibreOffice Calc files require at least 3 (content.xml, styles.xml and meta.xml) to be in the zipped package. Has anyone successfully created an ODS destination for *.ods (LibreOffice Calc) files?...........Phil

hollandnumerics · ‎04-22-2018

tc and RobertAllison_SAS, I like what you are trying to present, but, having a doctorate in Chemistry, I can't accept how you've re-purposed the Periodic Table. To me this representation should always group related items together in columns (and, lower down, in rows), but NEVER split them (see your links for S, Li, Bx, Tx and Sc). While I've not recreated your clickable image in its entirety, I have been moved to re-organized your links. Hopefully you'll be able to see what my "Chemistry" self is trying to demonstrate..............Phil

hollandnumerics · ‎04-06-2018

I had to split my journey up, because we're driving to Gatwick tonight, then flying from Gatwick to Denver tomorrow, but I've left the distance in miles for easier comparison, but I'm sure I'll be beaten by the Aussies: My Travel Distance From Royston to Gatwick My Travel Distance From Gatwick to Denver My Travel Distance From Royston to Denver 62 4,725 4,787

hollandnumerics · ‎03-15-2018

Peter, No graphics this time, but advice to prepare you, in advance, for unseen data! ...........Phil PS. However, if I'm allowed to do a prize draw, then my latest book could fulfil your desire for graphics. 😉

hollandnumerics · ‎01-23-2018

Hari2, Simply put, if you want someone to do your job for you, then you can't expect a free forum to provide you with help. However, there are SAS conference papers galore that will give you code to do what you want at http://www.lexjansen.com, or you could search SAS Blogs like Graphical Speaking, or indeed my own blog at http://blog.hollandnumerics.org.uk includes a paid-for forum for answers to SAS-related questions. To be a SAS programmer you have to be self-sufficient, and part of that is to be able to solve your own problems yourself by searching the available documentations and papers! ........Phil

hollandnumerics · ‎12-19-2017

Chris, I've changed SAS/GRAPH plots to ODS Graphics at past SASGF, so maybe Hogwarts is where I should be! 😉

Online Status	Offline
Date Last Visited	‎11-20-2025 06:07 AM