About JMarkW

JMarkW · ‎05-01-2009

This is not code that SAS is complaining about, it is the data in a variable. Unfortunately if SAS can not handle System of Record variables with quotes in them, the likely outcome will be to eliminate SAS as the language used. Message was edited by: JMarkW

JMarkW · ‎05-01-2009

I need to a way to suppress the SAS message: NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. I'm working with a batch interface that processes hundreds of millions of records. One of the macro variables contains a string of client data that may contain single and/or double quotes. SAS generates millions of useless warning messages that wastes disk and valuable time in the processing window. Does anyone know a SAS solution like a system option to suppress this message? Related note: http://support.sas.com/kb/3/353.html

JMarkW · ‎04-02-2009

Is sqlobs just a byproduct of creating a resulting SAS dataset or is sqlobs a SAS name for an existing Oracle variable?

JMarkW · ‎01-15-2009

I'm using libname and proc append to load data from a SAS data sets into Oracle tables. The row length is extremely large and the number of records is fairly large. I'm trying to figure out the optimal settings for INSERTBUFF and DBCOMMIT. I understand DBCOMMIT has to be equal to or less that INSERTBUFF. Does anybody know of documentation or have any rules of thumb on how to optimize for loading Oracle in this fashion? Message was edited by: JMarkW

JMarkW · ‎01-15-2009

Did you see any improvement in performance by changing the DBCOMMIT settings along with INSERTBUFF? I'm curious whether I should set them to the same value or not.....

JMarkW · ‎01-06-2009

after digging through the doc for a while I finally found the automatic macro variable &syscc. That will at least gave an indicator to switch to error handling logic like reading the stderr output like you mentioned.

JMarkW · ‎01-06-2009

I'm executing UNIX commands using PIPE functionality in SAS. The problem is handling exceptions. If the UNIX server issues an error (stderr) output from the unix command in the pipe, how do I know. The code I inherited just returns nothing when a unix error occurs. Does SAS have a return code for that similar to SAS/ACCESS for a RDBMS?

JMarkW · ‎12-18-2008

In dealing with very large volumes of Oracle data in UNIX which would be faster? 1. Use dbload and deal with the 8 byte field names? 2. Use a LIBNAME connect to Oracle? Do they both really invoke Oracle's SQLLDR behind the scenes?

JMarkW · ‎12-16-2008

I figured out how to do it with filename instead of libname. It is pretty much the same as MVS using the NEW then MOD options with the unix filename. No PIPE.

JMarkW · ‎12-16-2008

I'm looking for a UNIX equivalent to a MVS technique. In MVS a datasat can be opened as MOD so that additional records will automatically be appended to the end. I need to do the same thing in UNIX but have not found the syntax. Note that this is not a PROC APPEND or PROC DATASETS type of action. The volume of data is too high to make hundreds of thousands of datasets and append them together. This process needs to write to a single output file as the data is derived. Does anybody know the UNIX method for opening a file for appending records or the location of this method in SAS docs?

JMarkW · ‎11-24-2008

SAS technical support confirmed today that the error exists in version 9.1.3. They said the problem existed on multiple platforms besides Solaris. Tech support said that the error is fixed in 9.2

JMarkW · ‎11-21-2008

I'm working in a very tightly controlled UNIX environment. SAS/Connect is licensed but not hooked up. Is it correct to assume that the only way SAS/Connect can access a UNIX system from Windows is to add a service entry to /etc/services on the UNIX server to accept the incoming TCP connection from Windows? Message was edited by: JMarkW

JMarkW · ‎11-19-2008

I found a way to recreate this issue on a test server even though options noquotelenmax is used in the program. This options noquotelenmax is toggled off after processing that includes the following type of input. LIBNAME XMLFILE XML "&abc/&file" XMLMAP="&xmlmap"; The XML file does not generate the 262 message but any regular non-XML files that "may" follow that have a macro variable with a size over 262 will generate the error messages. I'm coding around this by issuing the options noquotelenmax command before each file is processed rather than at program initialization. Apparently SAS has an "undocumented feature" when using the LIBNAME XML functionality Message was edited by: JMarkW

JMarkW · ‎11-14-2008

Unfortunately the result of the options command was: "Your Site Administrator has not restricted any SAS options." It looks like that was another dead end.

JMarkW · ‎11-12-2008

I ran a setinit in our installation and didn't spot an Enterprise Guide. Most of my co-workers are C and Java folks, I guess they will have to get used to opening .sas programs from PC SAS instead of Windows.

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

Re: MEMSIZE MAX System Options: Pros & Cons on UNIX SAS 9.13

Re: Oracle PL/SQL "forall" inserts and SAS multi-inserts

MEMSIZE MAX System Options: Pros & Cons on UNIX SAS 9.13

Re: Why Upgrade to SAS 9.2 for UNIX ETL processing?

Re: Why Upgrade to SAS 9.2 for UNIX ETL processing?

Why Upgrade to SAS 9.2 for UNIX ETL processing?

Re: What error codes are available when using the libname XML data ste...

Re: What error codes are available when using the libname XML data ste...

Re: What error codes are available when using the libname XML data ste...

Re: What error codes are available when using the libname XML data ste...

How to suppress: NOTE 49-169: The meaning of an identifier after a quo...

Re: How to suppress: NOTE 49-169: The meaning of an identifier after a...

How to suppress: NOTE 49-169: The meaning of an identifier after a quo...

How is SQLOBS populated when selecting Oracle data

Oracle INSERTBUFF and DBCOMMIT settings

Re: How to enable Oracle bulk loader

Re: How to see UNIX stderr / return code when using PIPE commands

How to see UNIX stderr / return code when using PIPE commands

Which is Faster with Oracle, SAS/ACCESS libname or dbload?

Re: Looking for batch UNIX Method for Allocating SAS Datasets for Appe...

Looking for batch UNIX Method for Allocating SAS Datasets for Append o...

Re: UNIX SAS System Option -noquotelenmax Ignored in Code "Sometimes"

Setting up SAS/Connect between Windows and UNIX

Re: UNIX SAS System Option -noquotelenmax Ignored in Code "Sometimes"

Re: UNIX SAS System Option -noquotelenmax Ignored in Code "Sometimes"

Re: how to suppress PC SAS from appending a .sas to another SAS file