About JohnH

JohnH · ‎12-03-2007

Cynthia - You are correct. We cannot have inline frames either. I will try your ideas when I get a chance. Thanks to all of you for your ideas.

JohnH · ‎11-30-2007

Our web site does not allow frames. The ODS HTML system can easily create a frames setup with a contents, page, and table file completely set up. I need to create the same look, but on the same page and, with a header logo. I assume that means I need a table into which each of the content, page, and stat tables are entered. Can proc template be used to create such a setup? Does anyone have such a template style?

JohnH · ‎09-24-2007

Is there a way to turn off Auto Arrange as my default for the Process Flow Window? I always find it annoying when I want to move the icons around.

JohnH · ‎05-29-2007

Do you have the SAS/Connect product licensed? If not, you cannot do what I suggest. I do not know how to do it without SAS/Connect.

JohnH · ‎05-25-2007

You may be interested in how I have encorporated the SAS Connect code with EGuide. I think you could modify it to achieve your purpose. Go get my papers in Coders Corner from SUGI31 and the followup this time at the SAS Global Forum -- John Hennessey

JohnH · ‎05-22-2007

A couple of ideas: 1. Go to EGuide Explorer and deassign and reassign the old library nickname to the new place where the data resides? 2. My last resort is to right click on the icon and choose "Open Last Submitted Code". Then, I can copy and paste that code and modify it to go to the proper new place. Or, I can use the code to remind me of the options that I want as I create a new point & click task.

JohnH · ‎05-03-2007

I still go to the SAS Online Doc site for help whether I am in EGuide or Display Manager. I find it more comprehensive and useful. If you drag the icon to yhe bottom of your windows screen on the taskbar, it will always be available in the middle of any session.

JohnH · ‎04-10-2007

I find that using the sas EXCEL engine with the libname statement creates a dynamic link where the XLS file is the :library" and the sheets are "datasets" within the library. We found it to be superior to the Import/Export Procs.

JohnH · ‎04-10-2007

I am not sure this will work for you, but if you use the ODS Tagsets.EXCELXP system and use proc tabulate, and do it "by ID", SAS will put each table for each ID on a separate sheet withing the same XLS file. That is not a separate XLS file for each ID, but it may help or work. If you have a large number of IDs, it is a one-liner to create the separate sheets.

JohnH · ‎02-13-2007

We are considering giving up single user licenses of SAS and getting a server license with EGuide running on the desktop. We have no idea how many users it will take to overload the system. Let me use one of our current servers as an example. We have a Dell Quad (4 CPUs) server with Hyper threading technology, 4 gigs of RAM and 700 gigs of Hard drive space. The server is about 3 years old. I do not know what speed it is and I know that is important. Can any of you post your experiences with the number of users that you have running SAS on quad servers? Thanks, John

JohnH · ‎02-13-2007

Could you put an icon at the start of the process flow that does a filter & query which copies the desired dataset into work.temp. Then, have the flow process things from work.temp. To change the dataset, just go into that first icon and move a different dataset into work.temp. Alternately, if you store the various datasets in different folders, you can do a temp assign of a library nickname to different folders each time you want to run the flow.

JohnH · ‎01-18-2007

How are you connecting to the remote database?

JohnH · ‎12-27-2006

When SAS installs EGuide 4, it now blocks x-command and DDE statements as a default. I checked with their tech support and they showed me how to edit the registry entry to take out the "noxcmd" startup option and it now works fine. I would recommend checking with them about the details.

JohnH · ‎12-22-2006

How about something like this: go to the folder on your PC containing the data and allow it to be shared; in your SAS code that runs on the server, issue a "NET USE" command, using the SAS X command,to give the folder a letter mapping from the server; then issue your libname statement. I am trying to reverse what is done when you run SAS locally and access data on the server.

JohnH · ‎11-17-2006

Use SAS. It can handle it! Use the SAS Enterprise Guide interface. I am at a federal government agency with very large data sets. SAS & Enterprise Guide work well for us.

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

Scheduling a Batch Job from EG4.3 to run from the BI Platform

Re: Filename Statement Issue

Filename Statement Issue

GPLOT titling issue

"User does not have appropriate authorization level for library 'libra...

Stored Process Error in EG4.3..OK in EG4.2

A Congressional District File like the US2 file for States

Re: Longitudinal Data in SAS Enterprise Guide

Re: Add a WORD doc to EG project as a Task

Add a WORD doc to EG project as a Task

Auto Arrange Off, as default

Re: Proc template with columns & header

Proc template with columns & header

Auto Arrange Off, as default

Re: Parallel processing via E.G.

Re: Parallel processing via E.G.

Re: Changing Input datasets to a query w/out losing the query

Re: SAS Code Documentation

Re: SAS Export to Excel

Re: Split table

How Many Users Can a Server Handle?

Re: How to copy a process flow to a new data set?

Re: Application hangs

Re: Help with Enterprise Guide 4, SAS/Server and SAS datasets on PC

Re: Help with Enterprise Guide 4, SAS/Server and SAS datasets on PC

Re: Problems about processing a huge amount of data