[R] Obtaining the unmerged cases from one of the two data set

results. See the R codes below. Please assist. Looking forward to hearing from the group sooner and thanking you in advance Kind regards Mangalani Peter Makananisa Statistical Analyst South African Revenue Service (SARS) Segmentation and Research : Data Modelling Tel: +27 12 422

[R] Controlling the dates in R;

Dear R gurus, I am currently using the chron package for date manipulation in R and I am able to control the date which take the format - 1998/07/03, and - 2006-09-15 (date without time) Library(chron) As.Date(2006-09-15, format = '%Y-%m-%d') However I have a

[R] Merging two data set in R,

Dear R Gurus, I am currently working on the two dataset ( A and B), they both have the same fields:ID , REGION, OFFICE, CSTART, CEND, NCYCLE, STATUS and CB. I want to merge the two data set by ID. The problem I have is that the in data A, the ID's are unique. However in the data set B,

[R] Adding dummy variable zero/one in ARIMA model in R

Dear R gurus, How do I add dummy variable zero/ one in the ARIMA model both in the in-sample and outside the sample(forecasts)? Regards Peter South Africa Tell: +2712 422 7357 Please Note: This email and its contents are subject to our email legal notice which can be viewed

[R] Scheffe test

Dear all, Please help me with the R code which compute SCHEFFE TEST Thanking you in advance Kind regards Mangalani Peter Makananisa Statistical Analyst South African Revenue Service (SARS) Segmentation and Research : Data Modelling Tel: +2712 422 7357 Cell: +2782 456 4669

[R] Scheffe test

Dear all, Please help me with the R code which compute SCHEFFE TEST Thanking you in advance Kind regards Mangalani Peter Makananisa Statistical Analyst South African Revenue Service (SARS) Segmentation and Research : Data Modelling Tel: +2712 422 7357 Cell: +2782 456 4669

[R] Scheffe test

Dear Prof, Please help me with the R code which compute SCHEFFE TEST Thanking you in advance Kind regards Mangalani Peter Makananisa Statistical Analyst South African Revenue Service (SARS) Segmentation and Research : Data Modelling Tel: +2712 422 7357 Cell: +2782 456 4669

[R] Recall: Scheffe test

Mangalani Peter Makananisa would like to recall the message, Scheffe test. Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Email_Disclaimer.pdf [[alternative HTML version deleted

[R] GLS 95% CI

Dear R Gurus, How do I generate/obtain the 95% CI of the predicted values from the GLS model? Not plot.Predict Currently I know how to get the 95% CI for the GLS model parameters. Please advice Regards Peter South Africa Please Note: This email and its contents are subject to our

[R] 95% CI of the Predicted values from the GLS Model

Dear all, I have just constructed the GLS model in R . How do I print the 95% confidence intervals for the vector of predicted values R code/s for GLS CI? See the model below: Please advice Regards Peter South Africa +2712 422 7357 +2782 456 4669 Generalized

[R] Combining character, numeric and dates fields in one data frame

Hi, I am try to fix the data frame and I see that we only have two fields defined characters and numeric fields. How do I add date field on the same data after using the as.Dateas.yearmon and be able to manipulate the data on the date field(s)? Please advise Kind regards peter

[R] *.rpt data

Hi, Could you please assist, how do I load the rpt data into R without converting it first to csv? Kind regards Peter Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Pages/Email-disclaimer.aspx [[alternative

Re: [R] Dates in R (Year Month)

Thanks. -Original Message- From: David L Carlson [mailto:dcarl...@tamu.edu] Sent: 13 July 2016 05:05 PM To: Mangalani Peter Makananisa; r-help@r-project.org Subject: RE: Dates in R (Year Month) You need to look at the examples on the manual pages for ?yearmon and ?strptime: >

[R] Regression with ARMA residual

n? Please advice Kind regards Peter 082 456 4669 -Original Message- From: Ismail SEZEN [mailto:sezenism...@gmail.com] Sent: 13 July 2016 04:55 PM To: Mangalani Peter Makananisa Cc: r-help@r-project.org Subject: Re: [R] Dates in R (Year Month) You can not convert numeric vectors directly

[R] Dates in R (Year Month)

Hi All, I am trying to convert the vector below to dates please assist I have tried to use information on the links you sent, but it is not working. X = c(201501, 201502, 201503, 201505, 201506, 201507, 201508, 201509, 201510, 201511, 201512, 201601, 201602, 201603, 201604, 201605, 201606)

Re: [R] Package sqldf in R and dates manipulation

Thank you very much for the help you provided. RH2. -Original Message- From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] Sent: 11 August 2017 05:49 PM To: Mangalani Peter Makananisa Cc: r-help@r-project.org; Vito Ricci (vito_ri...@yahoo.com); mangindu...@gmail.com Subject: Re

Re: [R] Package sqldf in R and dates manipulation

t the data by dates in sqldf? I am not getting Djoni Darmawikarta email address. Please see the practice data attached and advise, Kind regards, Mangalani Peter Makananisa (0005786) South African Revenue Service (SARS) Specialist: Statistical Support TCEI_OR (Head Office) Tell: +2712 422 7357, Cell:

[R] Importing Big data to R

the full data in to R? Kind regards, Mangalani Peter Makananisa (5786) South African Revenue Service (SARS) +2782 456 4669 / +2712 422 7357 Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Pages/Email-discl

Re: [R] dplyr help

Thank you very much for the support. I have just used the reshape library and my problem was solved. Kind regards, Peter -Original Message- From: Jeff Newmiller [mailto:jdnew...@dcn.davis.ca.us] Sent: 10 July 2017 03:52 PM To: r-help@r-project.org; Mangalani Peter Makananisa; r-help

Re: [R] dplyr help

Thank you very much for the support. I just used the reshape library and my problem was solved. Kind regards, Peter -Original Message- From: PIKAL Petr [mailto:petr.pi...@precheza.cz] Sent: 10 July 2017 11:17 AM To: Mangalani Peter Makananisa; r-help@r-project.org Cc: Vito Ricci

[R] dplyr help

HI all, Is it possible to use one column spread on multiple columns values. example spread( Key_col, value1:value7) spreading Key_col to variable value1, value2, ... Value7 Please advise, Kind regards Mangalani Peter Makananisa (5786) South African Revenue Service (SARS) - HO +2782 456

[R] Case statement in sqldf

nd as FY + from cr + where ReportDate >= '2012-04-01' + ") Thanking you in advance Kind regards, Mangalani Peter Makananisa (0005786) South African Revenue Service (SARS) Specialist: Statistical Support TCEI_OR (Head Office) Tell: +272 422 7357,

Re: [R] Case statement in sqldf

Thank you very much, I will work on it -Original Message- From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] Sent: 11 September 2017 06:50 PM To: Mangalani Peter Makananisa Cc: r-help@r-project.org Subject: Re: Case statement in sqldf 2018-03-3 in your code should be 2018-03-31

Re: [R] Case statement in sqldf

Thanks D, I will work on the solution you gave and give feedback. -Original Message- From: David Winsemius [mailto:dwinsem...@comcast.net] Sent: 11 September 2017 05:19 PM To: Mangalani Peter Makananisa Cc: r-help@r-project.org Subject: Re: [R] Case statement in sqldf > On Sep