Proc Means error with suffix list131 (9/3/2010 3:01:52 PM) comp.soft-sys.sas I am getting an error that I don't understand with this program: %let minval=1; %let maxval=13; %macro try1; DATA try; do j=1 to 100; %DO i=&minval %to &maxval; a1&i=rand('Uniform'); a2&i=rand('Gamma',2... FPAStatman
Proc Import Excel Range3760 (3/17/2010 6:31:10 PM) comp.soft-sys.sas Does anyone know of a way to specify different ranges in Proc Import?
For example, if I have the labels on row 2 and the data doesn't
actually start until row 15, is there a way to skip rows 3-14?
Thank yo... FPAStatman
Code Review questions033 (6/19/2009 3:46:06 PM) comp.soft-sys.sas We are trying to write up an objectives document for an independent code review. What would you include? I have come up with the following so far: Are the procedures used the most efficient? I.E. would proc... FPAStatman
how to create this output027 (4/14/2009 3:34:35 PM) comp.soft-sys.sas I need to create a text file that I am having problems with. The output should look like the following: numrows=5 rumcols=10 xllcorner=800 yllcorner=0 cellsize=200 NODATA_VALUE=-9999 100.000000 0.000000 0.0000... FPAStatman
Hanging in Batch Mode331 (4/1/2009 3:55:40 PM) comp.soft-sys.sas I have been running a batch process on multiple data sets, and sometimes the program just starts to hang. I am using SAS 9.2 TS Level1M0, NET_ASRV platform; Microsoft Windows Server 2003, Enterprise Edition (5.... FPAStatman
Sort and Merge130 (3/19/2009 9:13:05 PM) comp.soft-sys.sas I have run into an interesting error, which I cannot figure out how to solve. I will provide an example of what I am doing below: DATA a; INPUT name $ id; CARDS; northwest 1 northeast 2 southwest 1 southeast ... FPAStatman
Failure while merging sorted runs040 (12/1/2008 8:32:49 PM) comp.soft-sys.sas While doing a proc sort, I get the following error NOTE: There were 1500722 observations read form the data set user.table7 ERROR: Failure while merging sorted runs from utility file 1 to final output. ERROR: ... FPAStatman
SQL order question131 (11/3/2008 9:51:36 PM) comp.soft-sys.sas I have a program similar to the folllowing: DATA t1; INPUT x y a b c; DATALINES; 1 1 1 2 1 2 2 2 1 2 3 3 3 1 1 4 4 4 1 2 ; DATA t2;INPUT x y d e f; DATALINES; 2 2 4 2 4 4 1 5 1 5 1 4 6 1 6 3 3 7 1 7 ; DATA t3;I... FPAStatman
Difference between Batch and Interactive runs136 (8/20/2008 9:08:00 PM) comp.soft-sys.sas I have a program that I have run through interactive or window mode in SAS, and it runs just fine. I then run the exact same program with the exact same data through batch mode, and it freezes. Does anyone kn... FPAStatman
SAS and XP with dual processors232 (8/8/2008 3:11:06 PM) comp.soft-sys.sas I have SAS 9.1 running on Windows XP Professional (version 5.1.2600) on a machine with dual processors, and 4G ram. I am running a SAS program, which is taking a long time to run, and so I opened task manager ... FPAStatman
Duplicate Records #3148 (2/3/2009 5:39:47 PM) comp.soft-sys.sas I'm trying to duplicate records in a data set to create one row for each event. Right now I have a single row with multiple events (columns). Example: 12345 12Jul2002 13Aug2002 02Jun1999 12Sep2004 19May2001... mikestout(6)
Hanging in Batch Mode331 (4/1/2009 3:55:40 PM) comp.soft-sys.sas I have been running a batch process on multiple data sets, and sometimes the program just starts to hang. I am using SAS 9.2 TS Level1M0, NET_ASRV platform; Microsoft Windows Server 2003, Enterprise Edition (5.... brentvtimothy(57)
Re: how to create this output132 (4/14/2009 7:17:03 PM) comp.soft-sys.sas Do you want to tell us what problems you are having or should we guess? Your observation has three values; your output appears to have 10. Are the extra values random or is there some rule for generating them... barry.a.schwarz(608)
OT: Tuesday Puzzle134 (4/28/2009 3:30:26 PM) comp.soft-sys.sas I posted the following, earlier, in the latest numeric precision thread. However, as many might skip that topic, here is a puzzle for those who need something extra to do today (note: this won't work on a mainf... art297(4237)
new id137 (5/13/2009 1:47:35 PM) comp.soft-sys.sas Hi, I have a question about generate new id. Here are my data look like: A B F001 1 E019 1 B201 2 L081 3 K700 4 How could I simply generate new... cychen9(19)
Do Loops333 (11/9/2009 3:16:50 PM) comp.soft-sys.sas hi, i have a dataset where i need to flag if a magazine subscription was still active at yearly intervals. currently my code is - if age_in_months>=1 then month_1=1; else month_1=0; if age_in_months>=2 then ... nickcorbin0000(9)
fitting a regression line3162 (6/21/2010 5:58:01 PM) comp.soft-sys.sas Hi,
I am trying to fit an exponential curve on the following dataset.
The regression results I got from excel is: SpecHum = 4.7145 *
How can I replicate the regression in SAS?
And ... Thx