SAS

Connection with Microsoft Access 2003
Hi, I read in SAS an access-query-file. How can i disconnect access after reading the query? Tx ... 5 May 2010 16:01

ods Output vs ??
Hi All, I have a question about outputting 'usable' results. I would like to have SAS output my results into a simple text file (or something easy to manipulate) even .csv would be great. I dislike the ODS output because of the junk code that SAS writes. My question is, What 'simple' text formats can I have ... 5 May 2010 19:23

Help Cox Models
Hi Everyone, I want to run cox proportional hazard models using a longitudinal dataset. I want sas to recognize subjects that had events at baseline and that had only baseline visits in the statement and not include them in the analysis. I was able to solve this by simply deleting those subjects from the datase... 4 May 2010 21:17

Excel Load
Swammy, I'll stick with a slightly modified version of my original suggestion: Since you've got tab delimited files, and proc import works (except for the problem), you could just copy and paste the code resulting from proc import and change the formats, informats and lengths of those fields which you want ... 5 May 2010 11:31

interaction term in Proc Logistic
I got different results when running logistic regression using Proc Logistic with interaction term. One way, I directly put the cross product term in the model statement of Proc Logistic; the other way I created an interaction variable in DATA step. Results are different when I included the missing in the analys... 16 May 2010 16:49

proc report - calculating %'s across
I have this: proc report data=full nowindows headskip; column schoolid a1 i15 wave; define schoolid/group "School"; define a1/group "Gender"; define i15 /group "Ever Pregnant"; define wave/across "Wave" ; run; Which gives me the frequencies of pregnancy (yes/no) across wave by gender & school. Now, ... 4 May 2010 14:34

Proc Import Excel Range
This should work - use getnames for the labels and datarow for the data. proc import datafile="c:\My Spreadsheet.xls" dbms=xls out=NewDataSet replace ; sheet="Sheet1"; getnames=Yes; datarow=15; run; ... 4 May 2010 12:19

Sample Size determination for a multiple comparisons to control Dunnett's test
Hi there, I need to find out how many patients I need to power sufficiently my primary analysis, which would be a Dunnett's test comparing means of two active trt groups versus a placebo. Does one know whether proc power or proc glmpower can do this in SAS ? I did look into the on-line doc. The contrast stat... 4 May 2010 12:19

Analytics
Hi To all the analytics guru's out there, where do I start learning analytics. Do I have to have a modelling back ground? Is there any free online courses? I have an engineering back ground and 10 years of SAS programming experience. So far I have done only programming and administration. Where do I start? Than... 4 May 2010 10:04

Top Few Solutions from Proc LP
Hi, I need to obtain top 100 solutions to a LP problem where all the decision variables are binary. For this I have written a code that works as follows - 1. Solve the LP (maximize SOME OBJECTIVE subject to CONSTRAINT1 CONTRAINT2 etc.). This gives me the best solution to the problem. 2. Add another constrai... 4 May 2010 10:04