harry.droogendyk1's articles:

Items(518) /52 Next >> Last >|

Re: tab delimited textfiles available in sas library? 2 29 (5/5/2007 4:03:51 AM) comp.soft-sys.sas Can you create data step view(s) that are sourced from the tab-delimited files? Untested. libname yourlib 'c:\data\views'; data yourlib.textfiles / view = yourlib.textfiles; infile 'c:\data\raw\*.csv... harry

Re: Macro arithmetic problem with %eval() & %sysevalf() #6 0 42 (5/4/2007 7:31:29 PM) comp.soft-sys.sas Very cool! -----Original Message----- From: data _null_; [mailto:datanull@gmail.com] Sent: 2007, May, 04 3:26 PM To: Droogendyk, Harry Cc: SAS-L@listserv.uga.edu Subject: Re: Macro arithmetic problem with %eva... harry

Re: Macro arithmetic problem with %eval() & %sysevalf() 0 46 (5/4/2007 7:12:39 PM) comp.soft-sys.sas Since the result of 10 * .25 is 2.5 ( and therefore contains a non-numeric character, ie. the decimal point ), %eval will complain bitterly. I don't know how SQL will handle outobs=2.5 either. ;-) You probab... harry

Re: style sheet #2 0 42 (5/3/2007 9:00:23 PM) comp.soft-sys.sas FWIW, I added a comment to the discussion on the sascommunity.org site. Now I wanna know how to get my userid to show up automatically in the comment I added?! I thought it would have been added automagically... harry

Re: ODS HTML PUT STATEMENTS #5 0 32 (5/3/2007 3:39:02 AM) comp.soft-sys.sas Have a look at this SUGI 31 paper that talks about bringing data step reports in to the 20th century ... There's a bit of a story behind how the paper ended up with the content it did, but I won't bore you wit... harry

Re: concatenating variables with similar first letter fo #5 0 19 (5/3/2007 2:25:44 AM) comp.soft-sys.sas If a variable list is to be used in a function ( and v: is a variable list, just as v1-v3 is one etc... ), the keyword "of" must be used to denote the variable list. With the "of" is supplied, catx works quite... harry

Re: URL Method and PROC IMPORT #3 0 46 (5/1/2007 8:24:15 PM) comp.soft-sys.sas Can MS Access access a web-based database ( ie. the .mdb file ) ? If so, can you create a local .mdb file that contains a query to the web-based database and proc import the query? -----Original Message----- ... harry

Re: Importing From Excel With DDE #4 0 46 (5/1/2007 5:15:59 PM) comp.soft-sys.sas The SAS 9 Excel libname engine honours the firstobs=, obs= and keep= dataset options. Presumably some combination of those will suffice to read the cells you want. libname test excel 'c:\temp\ivr_clients.xls'... harry

Re: How to unsubscribe from this newsgroup? 0 17 (4/30/2007 1:16:50 PM) comp.soft-sys.sas Rather than unsubscribing, send the following in the email body to listserv@listserv.uga.edu SET SAS-L NOMAIL When you want to participate again, send the following to the same address: SET SAS-L MAIL -----... harry

Re: Unix command for finding sas programs containing a specific 0 35 (4/10/2007 11:18:06 PM) comp.soft-sys.sas grep -ri -----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of Duck-Hye Yang Sent: 2007, April, 10 6:51 PM To: SAS-L@LISTSERV.VT.EDU Subject: OT: Unix... harry

harry.droogendyk1's replies:

Items(326) /33 Next >> Last >|

Appending to a master dataset 8 25 (4/5/2007 6:23:00 PM) comp.soft-sys.sas I have been using the following macro to append before: %macro appnd(a,b); data &a; set &a &b; run; %mend; The reason why I critic this method is that it reads in both datasets rather than just reading datase... akadas (8)

ETL/DI Studio: Error -> Lock Held by Another Process 1 29 (4/6/2007 2:02:03 PM) comp.soft-sys.sas Has anyone using ETL/DI Studio run into this problem? And do you have any suggestions for a fix or workaround? We're running ETL Studio 3.3, with SAS v9.1.3, SP3, on a server with two dual-core processors (pro... yzg9 (341)

Creating multiple Macro Varibles in SQL 2 44 (4/8/2007 2:10:59 AM) comp.soft-sys.sas In data set "one", there is a variable called "name". I'd like to assign each value(row) of the "name" into a Macro variable. There're tons of ways to do it, but I am just wondering how can achieve this task wi... zhanglitt (10)

how read *.xpt? 4 21 (4/10/2007 1:56:58 PM) comp.soft-sys.sas Hi Krewe: I have an .xpt file that I downloaded from this url: http://www.cdc.gov/nchs/about/major/nhanes/nhanes2003-2004/demo_c.xpt but cannot read it. I had mentioned to DLR that I could not get read this ... rjf2 (3354)

macro var in vmacro 5 28 (4/10/2007 4:52:29 PM) comp.soft-sys.sas Hello, Has anyone else seen this? I searched the archive but did not see anything similar. I have 41 date macro variables. When I look at them in vmacro tables there are extra characters inserted. For exam... michelle_zunnurain (52)

Reading Document Properties from Word, PowerPoint, and PDF Files 6 25 (4/10/2007 5:06:17 PM) comp.soft-sys.sas > I need to read the title, author, subject, and keywords fields from MS > Word, PowerPoint, and PDF files. Looking for help. I'm running SAS > 9.1.3 and have SAS/ACCESS for OLE DB and ODBC licensed. >=20 > E... EdHeaton (670)

Interleaving graphs and tables in report 3 27 (4/10/2007 5:37:29 PM) comp.soft-sys.sas Hi, =20 I'd like to create a report (html or pdf in ods) that has a graph and then a table for each level of a class variable. This seems ripe for using by-processing, but I just can't seem to find a way to do... matt.pettis1 (153)

Q-tip: organizing code snippets 7 22 (4/10/2007 6:29:43 PM) comp.soft-sys.sas Q-tip: question and tip, in one! Question first: How do people here organize code snippets? Having lurked this list for some time I have a (growing large) "keepers" folder in my mailbox, but occasionally the s... sko (123)

How to unsubscribe from this newsgroup? 5 33 (4/30/2007 1:11:12 PM) comp.soft-sys.sas Hi Folks, I want to unsubscribe from this newsgroup for the time being. How can I do that? Thanks, ... Sheikh.Rahman (5)

concatenating variables with similar first letter fo 6 40 (5/2/2007 12:28:03 PM) comp.soft-sys.sas Hi All, Does anybody have an idea about concatenating variables which start with same prefix. example suppose we have variable var1 var2 var3 i tried using call catx(separator,variablerequired,var:) var: de... ankur.arora (50)