Hi You can use the the bottom box, "Filter the summarized data", on the filter tab to create your having clauses ... View more

Hi Dave using your sample data to create Transactions and the trans_code format, I then used the filter query task and added the two columns and grouped by Cust_no. I just changed the format of Cust_no to trans_code and came up with the same answer without using put statements. PROC SQL; CREATE TABLE WORK.Query_for_SUMMARYA AS SELECT SUMMARYA.Trans_Code FORMAT=TRANS_CODE., (SUM(SUMMARYA.NumberOfRows)) AS SUM_OF_NumberOfRows FROM WORK.SUMMARYA AS SUMMARYA GROUP BY SUMMARYA.Trans_Code; QUIT; Derek Message was edited by: Derek Adams ... View more

Found the answer to my question, have to assign to the workspace server not the stored process server ... View more

Were you trying to save the reports to the "My Folders" or "Shared Folders" location? ... View more

I havent had any issues so far so I can't really comment on that at the moment ... View more

Try using monotonic() in proc sql, i.e monotonic() as xxx or if using a datastep xxx = _n_; ... View more

If you are using the summary statistics task assign the task roles as required then under the basic statistics option change the value of "Maximum decimal places". ... View more

It will do. You have to pass a value to the parameter for it to work. If you use the parameter manager you can specify a default value or ask it to prompt you. Have a look at the help, it covers how to do this ... View more

The parameter has to be given a value before you can use it. You can use the parameter manager, (under the tools menu), and to create it. There are options as to how it gets a value, by prompting, etc. Then right click on the filter query task select properties / parameters and add the parameter to the query. It should then get resolved. Search the EG help for creating parameters or even this forum ... View more

Have you tried the Recode option in the Computed Columns or create a format ... View more

Hi I'm not a statistical person and have no idea what standard deviation is or could possibly achieve but if you create a comptuted column and look at the functions tab there are STD functions listed. as an example columns A b c d e f g h 2 4 4 4 5 5 7 9 using the STD unction STD(a,b,c,d,e,f,g,h) = 2.1380899353 Hopefully this is right and if not I'm sure I'll hear about it derek ... View more

Using Peter.C's revised code, %macro timetst() ; %do i = 1 %to 1000 ; CREATE TABLE tabletest (test int) ; DROP TABLE tabletest ; %end ; %mend timetst ; proc sql noprint; %timetst() ; quit; my result using EG4.1 over citrix,sas 9.1.3 windows 2003 at work is NOTE: PROCEDURE SQL used (Total process time): real time 1.37 seconds cpu time 1.39 seconds with eg4.1 , sas 9.1.3 running thru vmware server, (server 2003) on a laptop dual core 2ghz with 1gb ram available, the same code results are real time 3.31 seconds cpu time 2.73 seconds On the same machine using sas 9.1.3 sp4 DM real time 2.64seconds cpu time 2.54 seconds ... View more

0.01 seconds using EG4.1 on citrix ... View more