SAS

Windows command line and -termstmt
Suppose a command line is needed such that a batch jobs log file is automatically opened into notepad (or system default registered opener for ..log files) job.sas --- proc print data=sashelp.class;run; --- This works: sas.exe -noterminal -sysin job.sas -termstmt "options noxwait noxsync;x start job.lo... 3 Oct 2007 09:29

SAS Administration questions - %omabakup, and security
Hello Friends, From a birdie. - Michael At 02:58 PM 10/1/2007 -0400, a birdie wrote: You do not need to disable repository auditing when performing a backup. You only need to disable auditing before attempting to perform a restore. See the last bullet item on this page: http://support.sas.com/on... 1 Oct 2007 19:25

DATA step in SAS EM Code Node
Hi, I just started a course in EM, with only a little SAS programming code experience. I need to add a SAS Code Node to my model, in which I create a new variable. I cannot get the Code to run without error, and I believe my problem is with the DATA step. Within the EM Code Node, am I supposed to refer to the or... 17 Sep 2007 23:35

CLI cursor fetch error
On Fri, 14 Sep 2007 09:29:50 -0700, Wade Pan <wade_pan(a)YAHOO.COM> wrote: Morning, guys, When I remote submit a SAS program (in which I connect to DB2 tables), an error comes out for one dataset I try to create. It doesn't happen everytime, but it got me so frustrated. Please advise. Thanks, Wade ... 15 Sep 2007 20:55

CLI cursor fetch error
Morning, guys, When I remote submit a SAS program (in which I connect to DB2 tables), an error comes out for one dataset I try to create. It doesn't happen everytime, but it got me so frustrated. Please advise. Thanks, Wade ERROR: CLI cursor fetch error: [IBM][CLI Driver] A communication error has been... 14 Sep 2007 13:24

Disk full: out of resources
Hello, I am also facing same problem. My datasets are also big ( close to 35 millions records ) and I am not sure how to tackle this issue. Have you found solution to your problem? Thanks S J ... 14 Sep 2007 08:58

Oracle BI
When I trying to save iBot its getting error like: Oracle BI Scheduler Error: [nQSError: 68019] Authentication Failed. Error Details Error Codes: GYFPI8RN Can anybody give any idea. Regards, Sanjoy ... 6 Sep 2007 09:11

Creating new variables
My dataset contains the Variable: Variable Class1 Class2 Class3 Class4 Class5 Class6 Class7 Class8 Class9 Class10 I want to create a new numeric variable "count" such that If Variable = "Class1" then count = 1; ELSE if Variable = "Class2" then count =2; .... This certainly does not look good, is... 5 Sep 2007 17:00

Reg: Sort in Proc Report
Hi All, I want to get the result with group of date fields with descending sort order. When i ran the below code, it is sorting as descending, but when i print the report through proc report procedure,sort variables are not displaying as descending in the report. Please have a look into the below code and gi... 4 Sep 2007 10:57

WARNING: End of file
Hi, What does the "WARNING: End of file" mean? I have encoutered this for some of my other codes as well 13 Proc SQL; 14 Create table MyProj.FinalFile as 15 Select * 16 from ProjRaw.InputFile 17 where ID in (select ID 18 from ProjTmp.SingleIDButDiffHHLD... 25 Aug 2007 14:13