saslist's articles:

Items(19) /2 Next >> Last >|

SAS/ACCESS to Oracle bind variables 0 84 (6/21/2007 4:49:29 PM) comp.soft-sys.sas Does anyone know how (or if it is possible) to pass bind variables to Oracle through SAS/ACCESS to Oracle. I cannot find anything in the doco about passing bind variables. TIA. ... saslist

macro to import spreadsheets from a directory 1 29 (12/18/2006 9:24:37 PM) comp.soft-sys.sas I have the following macro which reads all the files from a directory. I would like to feed the file location and name to proc import to create a table from each file. My code is: options symbolgen mprint; %mac... saslist

SQL update multiple columns 1 152 (12/30/2005 4:35:24 PM) comp.soft-sys.sas Is it possible to use proc sql to update multiple columns at the same time. Oracle supports the following: update table1 t1 set (ti.id, t1.var1, t1.var2, t1var3) = (select ti.id, t1.var1, t1.var2, t1var3 f... saslist

Email problem -- no error but no email either 2 18 (9/1/2005 2:55:22 PM) comp.soft-sys.sas I am trying to send an email off of v8.2 running on Linux. The message appears to have been 'sent' but I am not receiving it. This is a remote machine, not on my network, so I am wondering what issues my be pre... saslist

comparison of quoted macro strings 2 18 (8/11/2005 11:22:14 PM) comp.soft-sys.sas I'm having some trouble attempting to compare macro string with masked characters. Below is a greatly simplified example. options symbolgen mprint; %macro matcher(var1,var2); data _null_; %LET X = %INDEX(&var1... saslist

Re: transport file from v9.1 #2 0 22 (7/27/2005 2:37:07 PM) comp.soft-sys.sas I am going from PC to Unix. I don't believe a regular dataset will work; or will it? ... saslist

transport file from v9.1 2 31 (7/27/2005 1:15:48 PM) comp.soft-sys.sas I seem to be having some difficulty creating a transport file from version 9. I usually just use the xport engine but I get: libname outdd xport 'c:\sectIIb.v5x'; data outdd.sectIIb; set work.sectIIb; ERROR: ... saslist

Re: Suppress proc report outpout #3 0 34 (6/29/2005 1:19:07 PM) comp.soft-sys.sas I'm not just trying to suppress output to the html output window but the regular SAS output window which displays the ASCii rendering of the report. This window fills up and constantly has to be cleared. ... saslist

Suppress proc report outpout 2 54 (6/29/2005 12:51:40 PM) comp.soft-sys.sas This would seem to be an easy one but I cannot pinpoint the answer. I am using proc report and ODS to make some web pages. I would like to suppress the output to the 'output' window since it continually fills u... saslist

Re: Array help: code works, need to know why #10 0 21 (6/10/2005 12:50:24 AM) comp.soft-sys.sas Agreed on the data structure issue, but it is a requirement from the analysts. On Thu, 9 Jun 2005 18:18:53 +0000, toby dunn wrote: >saslist, > >Okay I see what you want but why? It seems to me you are trans... saslist