windofoct's articles:

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

why special characters read in from txt file 5 514 (6/23/2010 4:07:55 PM) comp.soft-sys.sas Hi SAS experts, I am trying to read a large raw data file into SAS. The raw data is sent by txt file and comma delimited. I could not find anything wrong with the data if you open it with UltraEdit or word... Ruby

about sheet= statement in proc export 2 360 (6/18/2010 8:59:44 PM) comp.soft-sys.sas Hi SAS experts, I am trying to export the summary results to excel and create each table names based on plan names. However, I am having trouble creating table names with SHEET= statement in proc export st... Ruby

SAS code help #3 0 24 (1/27/2010 3:33:49 PM) comp.soft-sys.sas hi SAS experts, I need to read some raw data files into sas. However, the files name has an invalid "-' sign in it. So, I tried to modify the old program by adding a new variable "sourcefile1" but with no succ... Ruby

how to flag out the old claims? 0 25 (11/5/2009 3:08:46 PM) comp.soft-sys.sas Hi SAS experts, I have a claim dataset and want to flag out the old version claims. How can I do it in SAS? Thanks very much! ******* input ******* clmno version AAA 001 AAA 001 AAA 002 AAA 002 BBB ... Ruby

SAS drove me crazy! Please help me! 0 26 (9/25/2009 8:01:42 PM) comp.soft-sys.sas Hi SAS experts, I extracted my findings from my dataset. I did a simple mathematics here and the results should be all 5s. However SAS doesn't think so. What the hell is! data temp; input drugcost :8.2 amtpa... Ruby

how to code my question? #3 1 21 (5/22/2009 4:14:28 PM) comp.soft-sys.sas Hello SAS experts, I am really stuck on this question please help me if you have good idea to code my question in SAS. Thanks a lot. I have a dataset with patient ID and each test results info. And also it is... Ruby

how to read trailer lines into SAS 2 18 (5/11/2009 2:52:46 PM) comp.soft-sys.sas Hello SAS experts, I have a raw .txt file with two trailer lines at the end of this file. I created a very simple example showed below to illustrate my question. First, I don't know how to read the line second... Ruby

What does this error message mean? 0 27 (5/4/2009 2:24:56 PM) comp.soft-sys.sas Hello folks, There was a I/O error when I was trying to append 6 million around records to a large dataset and log showed only 20 around records had been added when I/O error happened. So, I tried to delete th... Ruby

which option could prevent base dataset change if append procedure failed? 0 24 (5/1/2009 3:19:30 PM) comp.soft-sys.sas Hello folks, I remember there is an option setting could prevent base dataset change if the append processing is failed for some system reason, for example, I/O failures. However, I couldn't remember what exa... Ruby

question about proc surveyselect #2 1 31 (4/23/2009 2:22:57 PM) comp.soft-sys.sas Hello folks, I was trying to pull out some samples for a survey. And I only need to pull out some samples from some particular strata. So, I tried to use the '0' to hold the place for non-selected stratas. How... Ruby

windofoct's replies:

Items(2) /1

Re: how to code my question? 1 24 (3/3/2009 4:41:14 PM) comp.soft-sys.sas With the help of INTNX function you can make this much more concise. data have; array c[13] $1.; retain c13 'N'; input memID:$3. (c1-c12) (1.); do _n_ = 1 to dim(c)-1; if missing(start) and ... iebupdte (1746)

Re: SAS code help #3 1 56 (1/27/2010 5:10:49 PM) comp.soft-sys.sas Hi Ruby, Typically, the hyphen is not going to cause it not to work. You can see in first sample set of datasteps below that the hyphen works just fine very straight forwardly. There could be several subtle ... mterjeson (1932)