Hi I am using PROC PRINT to generate a report How can I get Page numbers and Total no of Pages. Regards Grasshopper ... View more

I have Information maps using Oralce tables Library : LIB1 Schema : SCH1 Server :Server1 When I export this map through SAS Management Console and import it in Library :LIB2 Schema :SCH2 Server :Server2 It gets imported but DOES NOT change the SCHEMA name of the map. It does prompt but for the Target Server, Schema and Library. I specify the new values but it does not change the Schema name. Please help ... View more

Can we generate a txt file through Proc Report Currently I am using the below mentioned code to generate a txt output OPTIONS NODATE NUMBER LS=250 PS=100; TITLE;FOOTNOTE; ODS LISTING; FILENAME outfile "/apps/ReportsFolder/MyReport.txt; PROC PRINTTO FILE=outfile NEW; RUN; I am usng List data to show the output. I am not able to customise the group total labels ... View more

I am creating a stored process from an enterprise Guide Project. Whether I should select a Logical Workspace Server or Stored Process Server as the Execution Server. What is the difference. ... View more

Hi I have my reports as Stored Processes which uses a proc print in the end. Requirement 1: I want to call these Stored Processes through some other web application and NOt through SAS. Hence I need to give them a url (link) for each Stored Process. If yes then what is the url and how should we pass the session id and login credentials. Requirement 2: Also, when I open a report through SASStoredProcess, how can I supress the execute options shown in the Stored Process. When I click on the Stored Process the Sp should be executed directly. ... View more

Hello I have a dataset ID----TransactionDate------OrdType-----Quantity-------Value 1-----01/01/2007--------------A--------------100--------------1000 1-----02/01/2007--------------A--------------200--------------2000 1-----01/02/2007--------------A--------------300--------------3000 1-----01/02/2007--------------A--------------400--------------4000 1-----01/03/2007--------------A--------------500--------------5000 1-----01/03/2007--------------A--------------600--------------6000 1-----01/01/2007--------------B--------------100--------------1001 1-----02/01/2007--------------B--------------200--------------2001 1-----01/02/2007--------------B--------------300--------------3001 1-----01/02/2007--------------B--------------400--------------4001 1-----01/03/2007--------------B--------------500--------------5001 1-----01/03/2007--------------B--------------600--------------6001 I want to show an output from EG using transpose as shown below OrderType-------------------January--------------------February---------------Total ----------------------------Quantity------Value-------Quantity------Value----- Pls help. Ignore the lines it was used just to show output Query is same as posted in http://support.sas.com/forums/thread.jspa?messageID=7113ᯉ Can we do it using the Transpose task of EG. It is possible using one cloumn like quantity but not possible if there are multiple columns. ... View more

Hi I am using AIX and LSF Scheduler to schedule a batch of Stored Processes. There is also a requirement where another batch reports should be triggered by some program. I have to give them a script so that they can run this batch after other tasks are over. Hence it will not be scheduled. How can I do this? ... View more

Please help me on this option Use PROC SQL instead of PROC SORT for sorting in tasks. When should I select this. My data base is Oracle. I am using sort option in Filter and Query task but not explicitly using Sort task. Should I check this option. ... View more

Hi there I have created a data item in my Information Map which does not show when I use that Information Map in EG. The data item Total is an expression as SUM(CostPrice, Quantity) and becomes a measure. This is a very common requirement where we want to create data items which are expressions but unfortunately does not show in EG. Second question is about when to make the columns in Information Map as Category or Measure. The Great Hopper ... View more