SAS

ERROR: DATA STEP Component Object failure
Here is a simple piece of code that causes an error and warning in the SAS log. I don't understand this errror message, what it tries to tell me: data testdata; length Testpunkt $2.; input Testpunkt; datalines; 02 09 09 09 16 16 17 19 19 ; run; Filename GenFile "D:\SAS_KODE\Generate_testdat... 28 Sep 2009 15:54

Cross-Summing problem. Data hash error msg
Thank you Paul and Wei for your help. I was able to run Paul code but the data hash solution from Wei generate this error message ERROR: Hash object added 2228208 items when memory failure occurred. FATAL: Insufficient memory to execute data step program. Aborted during the EXECUTION phase. ... 29 Sep 2009 04:08

SUBSTR Madness
Hi Dimitri, This should work: y =left( put(x,10.)); Ruslan ------Original Message------ From: Dimitri Shvorob Sender: SAS(r) Discussion To: SAS-L(a)LISTSERV.UGA.EDU ReplyTo: Dimitri Shvorob Subject: SUBSTR Madness Sent: Sep 27, 2009 9:39 AM I am trying to extract first 6 digits of a (variable-length) nume... 27 Sep 2009 18:59

Move File with Sas pgm
Hello Sas-Users, How can I move all the file .Txt and the file .Html in a directory (without using the X command)? I am working on Window environment. Thanks. Ash007. ... 12 Oct 2009 04:06

Variable reduction method
I've been reading a SUGI paper regarding to variable reduction but couldn't figure out one part of the code on page 6. I attach the code below and for anyone who is interested in the paper I also attached the link. *--------------------------------------------------------------* | Loop through all Numeric Variab... 25 Sep 2009 17:32

SAS DSD Option on a delimited file
How can a field be properly read that has a newline character within double quotes? Right now I'm using the INFILE statement below and it loads the observation but shifts values of the fields. Raw File ------------------------ Field 1,Field 2,"Field 3 Spans 2 lines",Field4,Field5,,,,,, Field 1,"Field 2 Spans... 24 Sep 2009 20:38

modify MS SQL tabel using ODBC
On Sep 24, 7:24 am, jim.1s...(a)YAHOO.COM (Jim Groeneveld) wrote: Hi friends, My problems consists of wanting to modify the contents of an MS SQL table on a server from SAS, more specifically emptying it (removing rows and columns) and refilling it. Deleting the rows succeeds, but the columns doesn't. My ... 24 Sep 2009 13:50

Create data set if condition
Hi there. I need some help. I want to create dataset if the condition is satisfied, else don't create at all a dataset. Here a code I wrote, but it doesn't work. Can anyone correct this code below? Thanks. data outputa _NULL_ ; set outliers; attrib &vara length=8 informat=DOLLAR8. format=DOLLAR8. ; if... 23 Sep 2009 14:26

Clean up *.sas7bitm files from WORK?
> From: Ya Huang Sent: Monday, September 21, 2009 4:56 PM To: SAS-L(a)LISTSERV.UGA.EDU Cc: Ya Huang Subject: Clean up *.sas7bitm files from WORK? Hi there, Is there a way I can clean up the *.sas7bitm files? I used proc datasets to clean up all temp datasets. But I can see tons of (10,000+) ... 22 Sep 2009 17:28

Totals and Subtotals with Proc Means
Subtotals meaning what? The total of each region*item break? Use the types statement to see that combination, if that's what you mean. Also, you could use PROC REPORT if you're looking for more control over totals/subtotals. -Joe On Mon, Sep 21, 2009 at 4:01 PM, Irin later <irinfigvam(a)yahoo.com> wrote: ... 21 Sep 2009 19:12