01-24-2022
Chuck_White
Obsidian | Level 7
Member since
09-22-2016
- 15 Posts
- 15 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by Chuck_White
Subject Views Posted 552 01-24-2022 02:46 PM 599 01-24-2022 11:11 AM 2726 07-07-2017 01:27 PM 2768 07-06-2017 03:20 PM 2814 07-05-2017 05:31 PM 3477 01-03-2017 11:49 AM 3603 12-12-2016 10:03 PM 3721 11-28-2016 06:53 PM 3757 11-26-2016 05:15 PM 3808 11-17-2016 02:48 PM -
Activity Feed for Chuck_White
- Posted Re: hypergeometric quantile function parameters on SAS Programming. 01-24-2022 02:46 PM
- Liked Re: hypergeometric quantile function parameters for FreelanceReinh. 01-24-2022 02:43 PM
- Posted hypergeometric quantile function parameters on SAS Programming. 01-24-2022 11:11 AM
- Liked Re: Proc import 'xlsx' doesn't work in 'guessingrows' ? for Patrick. 05-10-2021 01:02 PM
- Liked Re: Reading XLSX file and force SAS column types for Tom. 05-07-2021 04:20 PM
- Liked Re: Unusual path generated by SGPLOT and PROC DOCUMENT crashes for DavidK_SAS. 07-10-2017 02:04 PM
- Liked Re: Unusual path generated by SGPLOT and PROC DOCUMENT crashes for WarrenKuhfeld. 07-07-2017 01:32 PM
- Posted Re: Unusual path generated by SGPLOT and PROC DOCUMENT crashes on ODS and Base Reporting. 07-07-2017 01:27 PM
- Posted Re: Unusual path generated by SGPLOT and PROC DOCUMENT crashes on ODS and Base Reporting. 07-06-2017 03:20 PM
- Posted Unusual path generated by SGPLOT and PROC DOCUMENT crashes on ODS and Base Reporting. 07-05-2017 05:31 PM
- Liked Re: ODS PDF switch orientation between pages for Cynthia_sas. 01-19-2017 02:02 PM
- Posted Re: ods pdf contents and sgplot creates overprinting on ODS and Base Reporting. 01-03-2017 11:49 AM
- Posted Re: ods pdf contents and sgplot creates overprinting on ODS and Base Reporting. 12-12-2016 10:03 PM
- Liked Re: ods pdf contents and sgplot creates overprinting for TomKari. 12-12-2016 09:47 PM
- Liked Re: ods pdf contents and sgplot creates overprinting for TomKari. 11-28-2016 09:27 PM
- Liked Re: ods pdf contents and sgplot creates overprinting for TomKari. 11-28-2016 06:54 PM
- Posted Re: ods pdf contents and sgplot creates overprinting on ODS and Base Reporting. 11-28-2016 06:53 PM
- Liked Re: ods pdf contents and sgplot creates overprinting for bnawrocki. 11-28-2016 06:53 PM
- Liked Re: ods pdf contents and sgplot creates overprinting for TomKari. 11-26-2016 05:50 PM
- Posted Re: ods pdf contents and sgplot creates overprinting on ODS and Base Reporting. 11-26-2016 05:15 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 4 2 1 2
01-24-2022
02:46 PM
Better yet, there was a link within the quantile function that defined the parameters. I hate it when I miss stuff like that.
Thank you for your patience and support.
Chuck
... View more
01-24-2022
11:11 AM
SAS documentation I've seen for the quantile function includes an example for the hypergeometric function but I'm having a hard time figuring out the parameters of the function. Contrary to the usual level of SAS documentation, I don't see where the parameters are listed and my hunting and pecking for parameters isn't working. Any suggestions?
More specifically, the function is as follows:
quantile('hyper', p,x,y,z) so..., what are x, y, and z.
Thanks.
Thanks.
... View more
07-07-2017
01:27 PM
I haven't been able to reproduce the error with the sashelp.class dataset but what it's doing to my project code is a hard crash with the following error message in the log window: Invalid free() attempt to deleted pool Invalid free() attempt to deleted pool Invalid free() attempt to deleted pool WARNING: No Close statement was given for the TAGSETS.RTF WARNING: destination. This SAS session is ending. The output WARNING: file will be incomplete. Thanks for your help!
... View more
07-06-2017
03:20 PM
It wouldn't surprise me if my problem is specific to my installation but thank you very much for suggesting a demo dataset. If you look at the ByGroup numbers produced when I use by group processsing, you will see that they are nonstandard. As to my previous mistakes in the code, I had stripped out a lot of my original code and anonymized my variables. Sorry I didn't check further.... My code and proc document listing are provided below my signature. Thanks again! Chuck ods document name=work.temp(write); proc sort data=sashelp.class out=class; by sex; proc sgplot data=class; by sex; loess x=weight y=height; run; ods document close; ods listing; proc document name=work.temp; list / levels=all; quit; ods rtf file='!TEMP\SAS Temporary Files\temp.rtf'; proc document name=work.temp; replay ^(where=(_path_ ? "\SGPlot")); run; quit; run; ods _all_ close; The SAS System 1 15:05 Thursday, July 6, 2017 Listing of: \Work.Temp\ Order by: Insertion Number of levels: All Obs Path Type ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 1 \SGPlot#1 Dir 2 \SGPlot#1\ByGroup3#1 Dir 3 \SGPlot#1\ByGroup3#1\SGPlot#1 Graph 4 \SGPlot#1\ByGroup4#1 Dir 5 \SGPlot#1\ByGroup4#1\SGPlot#1 Graph
... View more
07-05-2017
05:31 PM
For one of my programs, SGPLOT is naming the first created path as SGPLOT#1\ByGroup21#1. Output looks fine in HTML but the files saved by ODS DOCUMENT crash when they are replayed. The first path created by SGPLOT should by SGPLOT#1\ByGroup1#1. Help would be appreciated. I'm using SAS 9.4 (TS1M4) The general form of my codes is as follows: ods document name=work.temp(write); proc sgplot data=display dattrmap=attr; by var1 var2 var3 var4 var5; loess x=x y=y / group=group attrid=attrid jitter clm NOLEGCLM TRANSPARENCY=.5 CLMTRANSPARENCY=.5 name="loess" legendlabel="Treatment Group"; run; ods document close; ods tagsets.rtf file=rtfout style=MyRTF options (contents="yes" toc_data="yes" toc_level="2"); proc document name=doclib.temp; replay ^(where=(_path_ ? "\sgplot")); run; quit; run; ods _all_ close;
... View more
01-03-2017
11:49 AM
Thanks Tom, 1. What I was missing was that MS Word will create it's own pdf documents and those pdf documents are reasonably compact. I've always had Acrobat installed and the Acrobat pdf options were easier to find. My version of Acrobat with my version of MS Word loses text off of graphics when converting proprietary vector graphics from Microsoft. Microsoft does fine when converting their own proprietary format. 2. Whether it's SAS, MS Word, or both, the font sizes and line spacings in the pdf documents produced through MS Word are not exactly as specified in SAS. 3. As long as MS Word is part of your organizations production process, using rtf to produce large tables of contents is a workable solution. All magic comes at a price. Chuck
... View more
12-12-2016
10:03 PM
Hello Tom, Thanks for following up. I'm sure that I'm preaching to the choir but, from my perspective, rtf is only good if you're creating a small set of tables, listings, and figures. Otherwise, you choose between low resolution graphics or unmanageably large files. It'd be different if you could use SVG graphics in rtf. In the mean time, I've been known to hard code page numbers for sections of my output (not all of the TLF panels...) into a variation on what is presented in the following paper: http://www.mwsug.org/proceedings/2012/S1/MWSUG-2012-S125.pdf Eventually, I'll put in some kind of official comment for the files of Tech Support. Chuck
... View more
11-28-2016
06:53 PM
I appreciate the usage note and it may still apply but I see that it was issued in 2005 for SAS 9.3. SAS has so much documentation that it's hard to find anything "off the beaten path" but I wasn't able to find any update to the usage note you referenced.
... View more
11-26-2016
05:15 PM
1. Sorry to complicate the issue with Proc Document. If you look at my document catelog, all of those "Before" entries work the same as starting a new page. 2. I've simplified the problem statement by using code from the first two SAS 9.4 examples for Proc SGPlot and adding the contents option. I get the same problem. I'm just testing on a couple of figures at a time but I need to implement an index on thousands of figures at a time. My new example is as follows: filename pdfout "!TEMP\SAS Temporary Files\test.pdf"; ods pdf file=pdfout contents startpage=yes; proc sgplot data=sashelp.class; scatter x=height y=weight / group=sex; run; proc sgplot data=sashelp.revhub2; scatter x=hub y=revenue / group=type groupdisplay=cluster clusterwidth=0.5; xaxis type=discrete; run; ods pdf close; run; 3. I apologize for taking so long to respond. I'm not trying to use this option on my current projects but I will be needing something like it in the near futures. Chuck
... View more
11-17-2016
02:48 PM
I hope to create a document store and create a "printed" index using the contents option in the ods pdf command. Unfortunately, I'm having trouble creating a "printed" index for just four graphs created using proc sgplot. Without the contents option, I get four graphs on four separate pages. When I use the contents option, I get the index and all four graphs printed on top of each other on the first page followed by four blank pages. Note that the contents option works as expected when I only use proc report. I'm using SAS version and maintenance release 9.04.01M2P072314. My replay commands are as follows: ods pdf file=pdfout contents; proc document name=work.test; replay; run; quit; run; ods _all_ close; The listing of the document store is as follows: SAS Output Listing of: \Work.test\ Order by: Insertion Number of levels: All Obs Path Type Size in Bytes Created Modified Symbolic Link Template Label Page Break 1 \SGPlot#1 2 \SGPlot#1\SGPlot#1 3 \SGPlot#2 4 \SGPlot#2\SGPlot#1 5 \SGPlot#3 6 \SGPlot#3\SGPlot#1 7 \SGPlot#4 8 \SGPlot#4\SGPlot#1 Dir 17NOV2016:14:44:32 17NOV2016:14:44:32 test Graph 3020 17NOV2016:14:44:32 17NOV2016:14:44:32 test Before Dir 17NOV2016:14:44:32 17NOV2016:14:44:32 test Graph 3004 17NOV2016:14:44:32 17NOV2016:14:44:32 test Before Dir 17NOV2016:14:44:32 17NOV2016:14:44:32 test Graph 3020 17NOV2016:14:44:32 17NOV2016:14:44:32 test Before Dir 17NOV2016:14:44:32 17NOV2016:14:44:32 test Graph 3016 17NOV2016:14:44:32 17NOV2016:14:44:32 test Before Suggestions would be appreciated.
... View more
09-22-2016
03:37 PM
Silly me, I was looking for something more dramatic. The sole contents of my autoexec.sas file are as follows: ods html path="!TEMP\SAS Temporary Files";
... View more
09-22-2016
01:23 PM
Thank you for the autoexec.sas suggestion though it’s not immediately obvious to me as to how I set the default output/html location that way. However, after scanning through sasv9.cfg, it looks like “!TEMP\SAS Temporary Files” is a good place to direct output I don’t want to save… as long as there aren’t any unintended consequences. It’s the default location of the SAS “work” directory under Windows.
... View more
09-22-2016
10:58 AM
Sorry, but I misspecified the problem. A corrected objective follows: Objective: Double clicking files in the Windows file manager to start SAS with the program files loaded to the enhanced editor sends default output files to the directory where I am storing my programming code. I would like for those output files to go elsewhere, preferably someplace where they are automatically deleted after use. I am using SAS 9.4 (64-bit). Potential Solution: Use the following code in my programs: ods html path="C:\Users\[WINDOWS USER NAME]\Downloads"; Rambling: Trying to explain a problem to someone else is a wonderful way to concentrate the mind.
... View more
09-22-2016
10:03 AM
More specifically, I know how to direct output but additional html files are being saved to my project directory and I don't seem to be able to control that.
... View more
09-22-2016
10:00 AM
Objective: Drag programming files from Windows file manager to the enhanced editor and execute without creating default output files in the directory from which I dragged my programming code. I am using SAS 9.4 (64-bit). Rambling: I assume this has something to do with creating some directory specific modification of the sas9.cfg file but the details elude me. Identifying the "correct" community to post this request also eludes me. Thank you for your patience.
... View more