Chris.Brooks's articles:

Items(64) /7 Next >> Last >|

Re: storing file metadata in a dataset 1 34 (1/13/2010 4:11:28 PM) comp.soft-sys.sas On Tue, 12 Jan 2010 22:42:03 -0800, cat.. wrote: >Hi folks ! > >I'm wondering whether it is possible to store file metadata (any type >of file) in a SAS data set. I already wrote a step for storing the >file ... Chris

Re: SAS on Linux (found somewhere else ) #3 0 40 (12/7/2009 4:11:16 PM) comp.soft-sys.sas On Sun, 6 Dec 2009 11:32:47 -0800, SAS_learner wrote: >Hello all , >Some body wrote me > >"I am trying to install sas 9.0 on linux type Ubentu 9.1 through wine >software but i am getting error "configuration... Chris

Re: Can I use proc in data step? #5 0 19 (8/12/2009 3:17:53 PM) comp.soft-sys.sas Yes, I agree the proc does execute after the step ends but you could, for example, conditionally execute the proc depending on the result of a value within the data eg this proc print won't execute as none of t... Chris

Re: Protect user id and password #2 0 38 (6/8/2009 2:06:08 PM) comp.soft-sys.sas Alex Try using proc pwencode. Here's the example from the SAS Help file filename pwfile 'd:\sas\encpass.txt'; proc pwencode in='mypass1' out=pwfile; run; data _null_; infile pwfile obs=1 length=l; in... Chris

Re: how get common ? 0 34 (6/4/2009 9:35:32 AM) comp.soft-sys.sas You are already 99% of the way there :-) all you need to do is include the format in brackets as well as the variable list eg data infile; input (a b c d e f) ($1.); datalines; 1 2 3 4 5 6 4 5 6 7 8 9 ; run;... Chris

Re: extending observations 0 33 (6/3/2009 2:18:58 PM) comp.soft-sys.sas If you have SAS/ETS licensed you can use Proc Timeseries to achieve this quite easily data infile; format date date9.; informat date yymmdd8.; input pt $ cp date; datalines; 1 2 20060822 1 3 ... Chris

Re: How to check for a binary number? #2 0 35 (6/3/2009 1:13:47 PM) comp.soft-sys.sas You could also use a regular expression........... %macro isbinary(inval); %let rx=%sysfunc(prxparse(/^([0-1])*$/)); %let start=1; %let stop=-1; %let position=0; %let length=0; %syscall prxnext(rx,star... Chris

Re: INTNX documentation - wrong? 0 35 (3/5/2009 2:45:57 PM) comp.soft-sys.sas On Thu, 5 Mar 2009 09:16:42 -0500, Gerhard Hellriegel wrote: >Hi there, >I'm asking me since I was born... The documentation for the INTNX function >says: > >*************************** >Increments a date, ti... Chris

Re: Creating pivot table using SAS enterprise guide version #8 1 35 (1/19/2009 11:24:40 AM) comp.soft-sys.sas I think in order to get full Pivot Table funtionality you need to look at SAS OLAP Server. You can create the cubes in either SAS OLAP Cube Studio, Data Integration Studio or use Proc Olap. You can then view an... Chris

Re: Is there anyway to run Enterprise Project in Batch? #3 0 38 (1/19/2009 10:19:38 AM) comp.soft-sys.sas In the same vein Tools->Schedule Project on the EG menu will create a simple VBScript file and schedule it to run using the Windows scheduler. If you want something fancier you can then use this script as a tem... Chris

Chris.Brooks's replies:

Items(22) /3 Next >> Last >|

Max Columns in SAS 4 39 (7/3/2006 8:39:23 AM) comp.soft-sys.sas Hello Everyone, Does anyone know the maximum # of columns that SAS allows in one table? Thankee! ... stats112 (342)

Blob/Clobs into oracle? 2 31 (8/21/2006 5:37:18 PM) comp.soft-sys.sas How can I insert blobs/clobs into oracle database? I have a stored procedure which takes as one of its input parameters a blob, which will be inserted into an oracle table. Is there a way to bind a parameter ... mineto (1)

Need SAS RegEx Help ! 6 25 (11/17/2006 10:04:26 PM) comp.soft-sys.sas SAS RegEx Gurus: Below is test code that I was using to help one of our programmers. We've gotten through 4 programs so far, with simple regex code (always finding a string and changing it), using Ron Cody's... gpauline (50)

How can we find the datatype of a variable in runtime 5 32 (4/5/2007 3:12:44 PM) comp.soft-sys.sas Hi, =20 I would like to use an IF condition as follows. =20 IF datatype(variable) =3Dcharacter then ; =20 Else ; =20 Thanks in Advance, Vijaya... vijayakumard (9)

A SORT ( SEQUENCE) PROBLEM 3 28 (4/26/2007 3:36:28 PM) comp.soft-sys.sas I have a following dataset: subject visit status ------- ----- ------ 001 day 1 pr 001 day 1 po 001 day 2 pr 001 day 2 po 001 Scr... mehedisas (145)

SAS Maps and Alaska Counties 1 24 (7/25/2007 2:17:39 PM) comp.soft-sys.sas Dear SAS-L I need to produce a map of the US by counties. Ideally it would be a map where Alaska and Hawaii are shown just below the other 48 states. Using maps.uscounty I get nearly everything I need excep... spj1 (69)

assigning column variable to macro variable 7 20 (12/20/2007 1:35:58 PM) comp.soft-sys.sas Hi, I want to know if there is a way to make a column variable a global variable. The following doesn't work data _null_; set test; %global var1; %let var1=variableOne; run; This makes var1 r... dorjetarap (478)

Assignment of SASWORK on UNIX 3 20 (5/9/2008 3:40:54 PM) comp.soft-sys.sas Friends, I could use some advice. I have a number of long-running batch jobs submitted by CRON or from the command prompt. Most of the time, these jobs are allocated work space on /SAS/work. Other times, jo... paul.bartells1 (36)

Asynchronous Remote Submit 1 14 (1/12/2009 9:57:28 AM) comp.soft-sys.sas Hello, I would like to know if the following sequence is possible and how: - Open a local SAS 9 session - Remote submit a SAS job on a SAS 9 server (SAS/CONNECT) - Close the local SAS 9 session and leave the j... torche (21)

Can I use proc in data step? 10 75 (8/12/2009 2:22:16 PM) comp.soft-sys.sas Is it possible to use proc procedures in the middle of data step? The procedures can be proc means or any other procedures. I am not going to make any print output other than saveing output sas files for ... yschoikd (4)