Re: formats and using multiple libraries09 (9/9/2003 10:10:27 PM) Kristie - Try the full path in quotes... libname dat_02 'C:\sas\SASdata\company\study1\data\'; libname dat_03 'C:\sas\SASdata\company\study3\data\'; libname dat_04 'C:\sas\SASdata\company\study4\data\'; Paul... pchoate(2551)
Re: Date Difference #209 (9/9/2003 9:57:20 PM) Pradnya- The datetime format only accepts dates in the form of 01oct2003 not 10/01/2003, so you need to break it up and read the date and time seperately. I also think you want an input rather than a put funct... pchoate(2551)
Re: Date Difference025 (9/9/2003 9:51:55 PM) A more SAS-like way to do this would be to transform the dates to SAS datetime values, and then use the INTCK function to count the number of hours between them. -- JackHamilton@FirstHealth.com Manager, Tec... JackHamilton(928)
Re: DATA Step -> SQL Conversion #3018 (9/9/2003 5:00:29 PM) Here is another way using CASE and WHEN, useful when you have to set different values for WHEN condition instead of 1 or 0. data a; input hosp $ drg los; cards; A 1 13 A 1 9 A 1 15 A 2 24 A 2 1 A 2 52 A 2 24... prasad.s.ravi(144)
Re: Handbook of small data sets book by Hand et al #2022 (9/9/2003 3:01:48 PM) For a review see http://www.stats.gla.ac.uk/cti/activities/reviews/95_08/small_data.html Regards - Jim. Y. (Jim) Groeneveld MSc Biostatistician Vitatron B.V. Meander 1051 6825 MJ Arnhem The Netherlands +31/0 ... jim.groeneveld(895)
Re: stats question on quartiles #3011 (9/9/2003 2:55:07 PM) Roland- If you cut the ordered 20 into quartiles of 5 the breaks come between obs 5-6 10-11 and 15-16, not at 5, 10, and 15. Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: Ro... pchoate(2551)
Re: Handbook of small data sets book by Hand et al011 (9/9/2003 2:52:00 PM) Doug- Your data sets are here: http://www.stat.ucla.edu/data/hand-daly-lunn-mcconway-ostrowski/ Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: Doug [mailto:queanbeyan@HOTMAI... pchoate(2551)
Re: DDE to Excel freezes SAS #2019 (9/9/2003 2:43:49 PM) The form of the filename statement that I always use looks like the following: filename xlout DDE "excel|c:\temp\[new.xls]sheet1!r2c1:r65536c27" notab; The difference being that before the worksheet filename,... Curtis.Smith(93)
Re: conditional assignment in SQL #2044 (9/9/2003 1:49:41 PM) Kevin: From the context, I'm assuming the proc format should specify a value of zero for 'N' rather than 2. I don't know what the performance differences will be, but you can also use the SQL CASE stuff: pro... Harry.Droogendyk(308)