About Jay_OAG

Jay_OAG · ‎03-19-2012

Unless you drop=product on h2, I think you will overlay each successfull merge with REFUND for a product....also, I think AMOUNT will need to be on your by statement (as well as in the SORT by statement) to have a unique key.

Jay_OAG · ‎02-03-2012

Maybe you could use a text prompt with FILEDATE and TERMDATE as the selections and a separate date range prompt...then clean it up in your code

Jay_OAG · ‎02-03-2012

I am using EG 4.3 (on 9.2) I have read about Result Type: Transient Package (http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/result.html) and I found this previous forum discussion http://communities.sas.com/message/3631#3631 about trying to do this. Is it possible now? In 9.3? I would like to create a stored process that generates a data set which would then allow the user to use additional tasks to manipulate that data set. Thanks

Jay_OAG · ‎01-19-2012

Nice..thanks for showing off IFC

Jay_OAG · ‎01-13-2012

What errors are you getting? Are you able to generate any excel documents?

Jay_OAG · ‎01-11-2012

data l; input id anydtdte11.; format id ddmmyy10.; cards; 12/01/2011 10/12/2010 19/02/2011 23/08/2011 run; Proc Sql noprint; select unique(id) into :id1 - :id2 from work.l order by id descending; quit; %put ID2: &id2;

Jay_OAG · ‎01-10-2012

A way to get all the code from a process flow is from the Create Stored Process wizard. Then you could just search in one code node (Program). Work-Around: Right-click your process flow in the Project Tree Choose "Create Stored Procss" Click NEXT in the wizard (don't worry about any parameters, this will be cancelled) Copy all the code (Ctrl-A will select all) Cancel wizard Paste in a code node (Program)

Jay_OAG · ‎01-10-2012

I think the first thing to do is make sure the log is being generated. Then review the log to see if that points to your problem. Also, try removing the macro if logic and just generate an e-mail when the macro is run. If you get all the way to generating an e-mail...then the problem could be diagnosed from your code.

Jay_OAG · ‎03-23-2011

Angela, Thanks for the reply and the links. I have started looking them over and I think they will help me understand how to insert a prompt in my information map from a stored process. I see that in the stored process code the macro variables are defined as global, will this allow me to access them from a stored process within my web report? Thanks Jay

Jay_OAG · ‎03-22-2011

John, In the STPServer log (I found mine located in /sas92config/Lev1/Logs), the macro vars are displayed with values (similar to the debug output from IntrNet)... _program was listed in my log. There is also a macro variable ( _APSLIST ) which appears to contain a list of the macro vars. Hope this helps... Jay

Jay_OAG · ‎03-21-2011

I have a WRS report with prompts. I have also included a stored process in my report. Should the prompts (macro variables) be accessible within the stored process? I have registered the stored process and was able to select it with WRS. I know I am using the correct macro variable name, but can't get access to the prompt value. Any help would be appreciated. Using WRS 4.3, EG 4.3 and Information Map 4.2

Jay_OAG · ‎12-30-2010

With PC SAS, I'm used to looking in the properties of a data set to determine if it is sorted (and by which variables). I can't seem to find this info in EG (4.3). Whether or not the data set was associated with my project or not, the info did not show up in the properties display. Any info would be appreciated.

Jay_OAG · ‎12-15-2010

To answer my own question, No. Ctrl-S saves the entire project...if there is a program with unsaved changes there is a prompt to save those changes. Ctrl-Shift-S (while in the program editor) saves the current program....with no prompt.

Jay_OAG · ‎12-15-2010

Trying to make the switch from PC SAS to EG 4.3. The program editor is nice, but is there a way to avoid the "save the changes" (Program) confirmation prompt? Thanks Jay Update: It seems that selecting the Save tab at the top of the program editor, and using Save will not give the prompt, but Ctrl-S does give the prompt.... Message was edited by: Jay_Oag

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

data step logic

Prompts in Management Console

When running a stored process, is it possible to return a (temporary) ...

character date

ODS TAGSETS.EXCELXP output multi-sheet

To find the second Highest Date

How to search through an EG project looking for certain strings / code

Re: Error Handling with mail body

Re: Using prompt macro variables in a Stored Process

Re: Stored Procedure in WRS