SAS

Rename of Temporary Member Failed
Raj: A simple contention for write access to a dataset (WORK or otherwise) occurs whenever one user process is reading a dataset and another user process attempts to write to a dataset with the same name. Unless processes always use distinct dataset names, a WORK.X sort writing to name WORK.X will fail with a runt... 10 Nov 2007 08:47

Proc TABULATE, mixed up on missing
I am using the MISSING option so that a TABULATE will occur without getting a WARNING: A class, frequency, or weight variable is missing on every observation. and no output at all. Is there a way to use the MISSING option and then tell tabulate to not show the missings (class level values)? In this sampl... 22 Oct 2007 14:25

Libname vs. Connect to
David: We use LIBNAME access to Oracle (on a RAC cluster) pretty heavily, and the "session" issue that your DBAs are referring to pertains to the fact that each time you make a request to Oracle for a particular schema, SAS will open another Oracle session (as far as I know this is Oracle specific, we have not h... 17 Oct 2007 12:11

SQL: Libname vs. Connect to
Hi Dave Only a partial answer. Others will hopefully give you more detailed and accurate responses. ODBC and OLE DB is middleware developed by Microsoft to access databases. OLE DB is the newer standard. The "connect to oracle.." in your code refers to the SAS/Access to Oracle module. Using a SAS client under ... 17 Oct 2007 19:06

Functions in PUT statement
Hi, I was working through CALL SYMPUT and SYMGET in online learning and wanted to see whether the values assigned during a CALL SYMPUT can be seen in a new data step utilizing SYMGET statement. Options symbolgen; data null_; set sasuser.schedule; call symput('same_val', 'Hallis, Dr. George'); call symput(... 19 Oct 2007 11:02

problem getting var to randomize
Estimated G Matrix not positive definite getting "." for the std error of some vars in the random statement getting this error and not sure why Some reasons I've been told 1 scaling of vars ran proc means and all vars are close to the same scale 2 vars could be linear combination of each other ... 11 Oct 2007 11:04

About deleting a dataset
Hi, all; I have the following error message ERROR: You cannot open WORK.NEWFMT.DATA for output access with member-level control because WORK.NEWFMT.DATA is in use by you in resource environment DMS Process. and I want to delete this dataset NEWFMT via PROC DATASETS in the running time, however, it does not w... 11 Oct 2007 09:24

Excel2007 & SAS 9.1.3 (PROC Export or Import)
We are currently using Excel2003 with SAS and we would like to move to Excel2007 if there are no major issues with PROC Import or Export. Can anyone attest to having virtually no issues with either of these functions using Excel2007? I would appreciate any comments. Thanks. ... 10 Oct 2007 10:29

ODS question
Masoud: You may have created an rtf document, but, due to the wpd file type extension, a word processing program would open it as a Wordperfect (?) document. You should change the file type extension to rtf in the file= argument, though you may be able to open the file as an rtf document by renaming the file to Co... 12 Oct 2007 14:27

Date Formats in a CSV File
Hi All, I'm trying to import a CSV file, but the dates formats are different than expected, ie they are dd/mm/yyyy rather than mm/dd/yyyy and SAS ends up throwing up errors and truncating the data because of this. Is there a way to set the default date informat to dd/mm/yyyy easily? There are 102 variables, ... 10 Oct 2007 18:07