About deleted_user

deleted_user · ‎06-07-2006

Dan, I really appreciate the ODS Data Step Object approach to report writing. It promises a high degree of layout control while providing significant layout intelligence to handle minutae automagically. When can we expect it to go production? Dwight

deleted_user · ‎06-07-2006

Hi all, I am also using (trying) Stored Process within SAS WebAnalytics. I would like to use a basic stored process that display a text; ex=> stphello.sas (%stpbegin; /*simply write out a web page that says "Hello World!"*/ data _null_; file _webout; put ''; put ' Hello World! '; put ''; put ' Hello World! '; put ''; put ''; run; %stpend; ) This is not possible with the SAS WebAnalytics GUI (???), a dataset is required; If such stored process is defined and run into SAS WebAnalytics message with no table is displayed. Does anyome know if the use of such SAS stored process can be perform? Thanks GN

deleted_user · ‎06-07-2006

I have similar problem the same as this one. I get the same error message and I suspect that there are some configurations missing (that should be defined through SAS Management Console, BIP Tree??? - but not sure) Hope that someone can provide some hints to solve this problem. Mandy

deleted_user · ‎06-06-2006

"I think you could be confusing memory used by the application with memory required by the application. The .NET CLR environment is simply allowing EG to use system resources without releasing them until requested back by the system or the application is prompted to release it by user action (e.g.- minimize the app and watch almost all the memory be released.) This improves app performance by maximizing use of available resources. " Thanks for the link. Yes, I'm aware of what you have posted. Nevertheless, I have seen EG machines slow to a crawl (both a standalone desktop with 512Mb memory and a Citrix server) as available memory drops away. We have upgraded memory on both PCs and Citrix servers in order to run EG. Perhaps there is a memory management issue somewhere? I need to do some evaluations comparing ActiveX/GIFs and EG3/4 to further investigate what we saw. Thanks.

deleted_user · ‎06-06-2006

This solution works for any row-wise items (i.e. the breaks between rows), but I can't think of any ways to get a break between columns. Likewise, the color technique works, but I have to color according to the column variable value, as well as the row value. If I can at least get column breaks and the only thing I have to worry about is the color, that still makes my life a bit easier! (The row breaks are certainly helpful as well, though.)

deleted_user · ‎06-06-2006

Hi Everyone, I have a slew of reports being generated by SAS into Excel via ODS and the ExcelXP tagset. To cut down on post-processing, I've tried to have SAS generate the spreadsheets as close as possible to what the finished products need to look like by using various tagset options (column widths, headers, page centering, etc.). The two biggest time-wasters in terms of post-processing involve specifically coloring clusters of cells according to what row/column they're in, along with adding in "spacing" columns and rows to create the cluster effect. Example: Before: 3629 74.90% 3573 73.50% 1216 25.00% 1285 26.40% 4845 100.00% 4858 100.00% 3982 68.70% 3693 65.60% 1812 31.20% 1934 34.30% 5794 100.00% 5627 100.00% After: 3629 74.90% (blank)3573 73.50% 1216 25.00% (blank)1285 26.40% 4845 100.00% (blank)4858 100.00% (empty row) 3982 68.70% (blank) 3693 65.60% 1812 31.20% (blank) 1934 34.30% 5794 100.00% (blank) 5627 100.00% Each of the above 4 clusters would have different BG colors, according to the values of the column and row headers. I've tried to write Excel macros to do this portion, but they're not universal enough. Is there any way to achieve either of these tasks through SAS, or am I out of luck?

deleted_user · ‎06-06-2006

Thank you that works.

deleted_user · ‎06-06-2006

Thanks Chevelle, What I'm trying to do seems to be a hybrid of the topics discussed here. This document talks about 'how to create multiple graphs using BY processing' and talks about 'creating multiple graphs on one page using multiple procedures.' What I'm trying to do is get multiple graphs on one page using one procedure. Any pointers??

deleted_user · ‎06-06-2006

Hi folks, I was hoping for help on a problem with a stored process. The Stored Process is created from a EG4.1 project, where there is input data from two different physical SAS servers. In EG the project works fine, it can access all input data (the data are in libraries that are defined in the SAS Management Console). BUT when we create a stored process, it can't access data on both servers. In the code it assigns the libraries with META engine and depending on the execution server it can only access the data on the server where it's executed. It shouldn't be too difficult, what am I missing here...

deleted_user · ‎06-06-2006

Hi, I think you could be confusing memory used by the application with memory required by the application. The .NET CLR environment is simply allowing EG to use system resources without releasing them until requested back by the system or the application is prompted to release it by user action (e.g.- minimize the app and watch almost all the memory be released.) This improves app performance by maximizing use of available resources. For example, I just had open an EG session with several very large reports that showed EG as using 195 MB of memory. As soon as I minimized the app it dropped back down to 16 MB of memory. I then brought it back and it was at 28 MB pretty quickly. For some background on how .NET managed code apps work, see http://www.datadirect.com/developer/net/managed_code/index.ssp#automatic A synopsis of the article: Because managed code runs in the Common Language Runtime (CLR), it provides services such as automatic memory management, platform-neutrality and cross-language integration. These features streamline deployment, improve performance and provide substantial improvement to application stability. Regards, Stephen

deleted_user · ‎06-05-2006

You need to change PropertiesList element to PropertyList.

deleted_user · ‎06-05-2006

I believe the code is acting poorly. It considers all the titles as rows in a single table and all the footnotes as rows in a single table. The Rules and Frame apply to the whole table and not separate rows. The table attributes are being applied with the generic titles and footers style while the separate rows use the specific styles associated with them. You may want to contact SAS Technical Support at : support@sas.com or on the web at : http://support.sas.com/techsup/contact/submit_emits2.html If you only have one title, you could get some relief with the following code. proc template; define style test; parent=styles.rtf; Style SYSTitleAndFOOTERContainer from SYSTitleAndFOOTERContainer / rules=rows BorderWidth=5pt bordercolor=red borderstyle=double ; ; end; run; ods rtf file="test.rtf" style=test ; Title "Test Title" ; Footnote1 " " ; Footnote2 "Test Footnote" ; Footnote3 " " ; proc print data=sashelp.class (obs=1) ; run; ods _all_ close ;

deleted_user · ‎06-05-2006

We have our operational day to day system in Microsoft SQL Server. On a nightly basis (after all of our daily transactions complete), we'd like to have SAS run some statistical analysis and then populate some "reporting tables" in SQL Server with the results. We're thinking the best way to do that (since we don't want SAS to do its thing until the nightly updates are done) is to have SAS invoked by a SQL stored procedure. Basically I was wondering if that is even possible and if so how do I set up SAS to be called remotely like that. Does this make any sense to anyone out there?? Thanks!!!!!!

deleted_user · ‎06-05-2006

I downloaded the latest tagset and it seems to display all the numbers by default as numbers. I am trying to get one column of numbers to stay strings. I set the style as style={tagattr="Type:String"}. This creates the following XML -- 3.5 . That generates an error in Excel until I edit the XML file and change all occurrences of 'string' to 'String'. What is the trick to make the tagset generate 'String' instead of 'string'?

deleted_user · ‎06-05-2006

I am creating plots using PROC GPLOT. I am using a GOPTIONS RESET=ALL prior to my ODS RTF call (as suggested elsewhere in a few places [and have tried it both with and without]). I want to be able to specify the size of my graph in my RTF, but am having no success. I have tried using a style containing: style Graph from Graph / outputheight = 10cm outputwidth = 15cm; With verious permutations on sizes and units - however the graph in the RTF is not affected. Furthermore, the fonts used in the graph are ALWAYS courier - can someone please help me?

Online Status	Offline
Date Last Visited	‎09-01-2015 07:02 AM

Output only special characters

Re: Promoting SAS users and groups from SAS 9.2

Promoting SAS users and groups from SAS 9.2

Re: re-assign values for consecutive obs

Re: re-assign values for consecutive obs

re-assign values for consecutive obs

Re: subset in data step

Re: Delimiter for Tab in SAS.

Re: how to Load Row Number in SAS DI

Re: how to Load Row Number in SAS DI

Create a SAS Project Scaffold on the Command Line

Introductions are in order

Using Multiple Containers

Re: Removing permenent libraries?

how to get 0 in out put

Help with calculating the scores

help with array

non-inferiority analysis

Re: ODS Data Step Object

Re: Stored Process and SAS WebAnalytics

Re: Information Map Studio problem

Re: SAS Enterprise Guide in a Citrix environment

Re: Coloring Specific Cells in Excel Output

Coloring Specific Cells in Excel Output

Re: Displaying a number as a number with the ExcelXP tagset

Re: Multiple Graphs on a single page

Stored Process created with EG4.1 in a multiserver environment

Re: SAS Enterprise Guide in a Citrix environment

Re: Testing SAS BI Web Services Samples

Re: Borders around footer but not titles

Getting SAS to talk to MS SQL Server

Re: Displaying a number as a number with the ExcelXP tagset

Changing graph sizes and fonts