Re: [R] RODBC results from stored procedure

2010-10-14 Thread ang
I know this thread is from a while back, but hopefully I can still get some help on this. I also used RODBC to connect to a SQL Server, and my stored procedure returns a results set (that is not stored as a temp or permanent table). So I was wondering if there was a way to access this results se

Re: [R] ThinkCell type waterfall charts in R?

2011-01-10 Thread ang
I was actually looking to create a similar type of graph in R. But I guess I am going to try to approach it by using a stacked column chart and hiding the 'net' series, while only showing the increases/decreases in value. I'll post an update later on what I come up with. -- View this message i

Re: [R] ThinkCell type waterfall charts in R?

2011-01-11 Thread ang
Hi Jim, I looked through the plotrix documentation, and the waterfall plot comes from the stackpoly function right? I'm not sure if I can modify the stackpoly to create the plot I want, since stackpoly is a line plot and fills the area under with color. I haven't played with all the options yet

[R] Coloring Continents/Regions of World Map

2011-05-13 Thread ang
Dear All, This may be a silly question, but I have tried searching through a few of the existing threads already, and haven't found any information on this. I am trying to color code entire continents/regions (Asia, North America, Africa, etc.) based on the number of relevant companies. The data

[R] Converting matrices into row vectors and saving as ASCII text

2009-09-19 Thread Xi Ang
Hi I have some data with these dimensions: 5 3 100 which correspond to the x, y, and time dimensions, for a variable, p. I need the data in this format: 100 rows (1 row per time unit), and 15 values in each row. I have attempted to reshape my data >dim(data) 5 3 100 >attr(data,'dim')<-c(dim

Re: [R] Converting matrices into row vectors and saving as ASCII text

2009-09-19 Thread Xi Ang
50, dim=c(3,5,10)) > XYbyT= matrix(apply(XYT, 3, I), ncol=10) > > ...or even... > > XYbyT= matrix(XYT, ncol=10) > > -- > David. > > On Sep 19, 2009, at 1:11 PM, Xi Ang wrote: > >> >> Hi >> >> I have some data with these dimensions: >>

[R] A Gamma-GLM with log link

2009-12-07 Thread choonhong ang
Hi, I have a set of data (total number of record = 144,122), and I would like to use gamma-glm with log link to set up a model. IC is number of records IL is paid amount The table below shows that I have 30.578% of the data in the level of "1 - 1000" paid amount 20.320% of the data in the level

[R] help - read SAS into R

2010-08-31 Thread choonhong ang
HI All, How to read SAS data directly into R ? Thank you [[alternative HTML version deleted]] __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-g

[R] vglm

2010-08-31 Thread choonhong ang
Hi All, could anybody help me to understand what is this error means ? mydata=read.table("C:/Documents and Settings/angieb/Desktop/CommercialGL/cl_ilf_claimdata.csv",header=TRUE,sep=",") > names(mydata) [1] "ILFTable""liabLimit" "AnnAggLimit" "DedAmt" "Loss" "TIL" > fit=vglm(Loss~1,pa

[R] vglm help

2010-09-03 Thread choonhong ang
Hi All, I am using vglm & the fitted values is NA. As in the R documentation that for Pareto1, if the estimate of k is less than or equal to unity then the fitted values will be NA. what is NA means ? how to solve it ? how to get the k estimate ? (in the R document the estimate of alpha is f.

[R] Insurance data in library(MASS)

2009-02-23 Thread choonhong ang
I have used the insurance data from R library and I have 2 questions: I use the following: >library(MASS) >data(Insurance) > m1=glm(Claims ~ District + Group + Age + offset(log(Holders)),data = Insurance, family = poisson) >summary(m1) Call: glm(formula = Claims ~ District + Group + Age + offset(l

Re: [R] Insurance data in library(MASS)

2009-02-24 Thread choonhong ang
Hi, In the result shown, the District 1 is used as the base category. How to change to make District 4 as a base category ? On Mon, Feb 23, 2009 at 11:05 AM, choonhong ang wrote: > I have used the insurance data from R library and I have 2 questions: > I use the following: > >

[R] R question - combine values

2009-02-25 Thread choonhong ang
The district a is the baseline and we observe the difference between District a & b is not significant, we can choose to combine these 2 values. How to write code to combine these 2 value ? > m1=glm(Claims~District+Group+Age+log(Holders),fami ly=poisson,data=mydata) > summary(m1) Call: glm(formul

[R] select Intercept coefficients only

2009-02-27 Thread choonhong ang
Hi friends, Is there a function to select intercept coefficients only ? When I use "coeficients" it shows me all the coefficients, but I only want a specific coefficients. [[alternative HTML version deleted]] __ R-help@r-project.org mailing li

[R] comment on this book "A Handbook of Statistical Analyses Using R by Brian S. Everitt (Author), Torsten Hothorn (Author)"

2009-03-02 Thread choonhong ang
Is this book a good reference to learn R for statistical analysis ? A Handbook of Statistical Analyses Using R by Brian S. Everitt(Author), Torste

[R] detect outliers and high levarage points

2009-03-03 Thread choonhong ang
Hi friends, How to detect outliers and high leverage points for GLM ? Could I use plot(model) (i) "Residuals vs Fitted" graph to detect the outliers ? (ii) "Residuals vs Leverage" graph to detect the high leverage points ? And then remove those points from the data and re-run the model ?

[R] Model confusion

2008-03-10 Thread Christopher De Ang
Hi, I m wondering is there any rules on what variables are used for factor analysis/ loading. For instance, increase reputation lead to increase in volume of post. So is volume need to be calculated in factor loading. InDependent Variable dependent Variables