SAS

ERROR: Connect: External table is not in the expected format.
Lee, There are a number of SAS technical notes on this. If you're not on 9.2 phase 2, you may have to intall that to solve the problem (other than, of course, simply opening the file in Excel and saving it in an earlier format). I really don't know if that version of office/excel has to be intalled as well. ... 28 Feb 2010 20:03

area under the curve
i have 100 subjects with repeated measurements at unbalanced time points, some start at time 0 some at time 1.1 etc. and not all subjects were measured at same time points. How do i find the area under the curve for each subject with a baseline response value which is negative ie -10? ... 1 Mar 2010 12:31

SAS Code
Hello , I used the code - DATA home; INFILE 'c:\Cwa\Home.txt'; INPUT Owner $ 1-7 Description $ 9-33 Cost; IF Cost=. THEN CostGroup='missing'; ELSE IF Cost<2000 THEN CostGroup='low' ELSE IF Cost<10000 THEN CostGroup='medium'; ELSE CostGroup='high'; PROC PRINT DATA=home; TITLE 'Home Improvement Co... 28 Feb 2010 13:20

how to prevent SAS macro from interpreting "&"
On Feb 26, 8:18 pm, xin...(a)STAT.PSU.EDU (xin) wrote: Hello, everyone: I am writing a string containing "&" into a macro variable. When I invoke this "&" containing macro variable in my code, SAS try to interpret this "&" as a presence of macro variable and as a result, gives warning msg "WARNING: Apparen... 1 Mar 2010 23:10

Reading an XML parsed file
Wendi I once tried the mapper and did not get very far but you may have better luck. It looks like there are a number of potential observations here that start with <GRResolvedRequest ReqID= and continue through </GRResolvedRequest>< I have not visually parsed the string carefully enough but if you have a specif... 1 Mar 2010 18:44

Reading an XML parsed file
I need to read in an XML file that comes all in one string (one line). The current string I am using is currently at length 968,273 and could easily be longer. We will be receiving these strings from an MQ server on our mainframe - we are fetching them to the PC and this is how they appear. The example below (w... 27 Feb 2010 11:00

using proc export/dbms=xls and excel lost date format
I think it's very weird. And it's very easy to reproduce the problem. SAS 9.2 (32-bit/64-bit) proc export data=whatever_dataset_with_datetime; outfile='path\filename' dmbs=xls replace; sheet='01'; run; Note: the reason I am using "dbms=xls" instead of "dbms=excel" is xls is only option in 64-bit sas. This... 1 Mar 2010 09:09

Robust standard errors in Zero inflated Poisson and Zero inflated
On Feb 26, 2:41 pm, v.bal...(a)GMAIL.COM (Vishal Bali) wrote: I have used Proc Genmod and Repeated Subject statement to obtain robust standard errors in Poisson and negative binomial regression. Could anyone please tell me something  about the STATEMENT AND possible SYNTAX that can be used to obtain robust st... 26 Feb 2010 22:00

FPC Sample Size Power?
Hi all, Is there any way (SAS or otherwise) to determine the required sample size to test the difference in two means or proportions for a given power, given a finite population? In other words, say we have a sample frame of X people and I want to test a control versus a treatment. Short of 50/50 split, how can ... 3 Mar 2010 10:39

Char() vs substr() (was Re: How to - Hex IP address to dotted
Hi there, Can anyone comments on why SAS introduced the new function char()? What is the advantage of char(a,1)? Isn't it the same as substr(a,1,1)? Thanks Ya ... 26 Feb 2010 15:20