similar to: Teradata ODBC driver

Hello All, I am very new to the R and i want to know how to connect to the teradata in R and import data from there. Currently I am using SAS to import data and i use the following syntax to connect to teradata. *Proc Sql; connect to odbc (dsn=teradata username = '**********' password = '*********'); create table dorm.bkg_tables as select * from connection to odbc* Could you

Hello, Does anyone know a way to connect from R on Linux box to TeraData server? I can use ODBC connection on Windows box, but with amount of data I need (and prefer) to use large Linux box. Thanks, Vadim

Hi all, I am trying to connect Teradata with R using Windows. Due I need to install any specific package or what? I am bit clue-less. Can someone help. Regards, Saj _________________________________________________________________ [[alternative HTML version deleted]]

Hi. I am trying to follow this forecasting tutorial at: https://www.r-bloggers.com/basic-forecasting/ Using my own data, I cannot get past the first step, lots of laughs. dat3 <- structure(c(5973156.76, 5159011.20, 6695766.64, 6365359.00, 6495218.53, 7226302.39, 6835272.70, 7383501.57, 6962748.19, 7623278.72, 7274994.33 ,7919421.80, 7360740.81, 7436693.35,

Hi Don, wow, you are so right. I picked that piece up from the bloggers tutorial and since I am R naive yet, I thought it was all one step moving_average = forecast(ma(tdat[1:31], order=2), h=5) Truly, I usually print and check at every step I can, as painful as it is sometimes. Great lesson for this novice usR. So the first and last values are NA in each case? Do you know why? Should I replace

You are right that there are no NAs in the practice data. But there are NAs in the moving average data. To see this, break your work into two separate steps, like this: tnr.ma <- ma(dat3[1:28], order=3) TNR_moving_average <- forecast(tnr.ma, h=8) I think you will find that the warning comes from the second step. Print tnr.ma and you will see some NAs. -Don -- Don MacQueen Lawrence

Instead of Tsp = c(2016, 2018, 12) try Tsp = c(2016, 2018.25, 12) Hence, you can specify the object as structure(c(5973156.76, 5159011.2, 6695766.64, 6365359, 6495218.53, 7226302.39, 6835272.7, 7383501.57, 6962748.19, 7623278.72, 7274994.33, 7919421.8, 7360740.81, 7436693.35, 8545765.55, 7337269.76, 8180585.44, 8376635.05, 7758261.24, 10374641.22, 8000314.11, 9114958.9, 9805149.15,

Hi, I'm trying to connect to a Teradata database via RODBC on a Linux 64 machine (Red Hat Enterprise Linux 5). The ODBC driver is properly configured and queries sent via unixODBC's isql tool work properly. However, this is what happens when I try to connect via RODBC: > library(RODBC) > conn = odbcConnect("thedsn", uid="theuid", pwd="thepass") ***

My guess would be that if you inspect the output from ma(dat3[1:28], order=3) you will find some NAs in it. And then forecast() doesn't like NAs. But I can't check, because I can't find the ma() and forecast() functions. I assume they come from some package you installed; it would be helpful to say which package. -Don -- Don MacQueen Lawrence Livermore National Laboratory 7000

Hello Don, thank you for your response. I appreciate your help. I am using the forecast package, originally I found it following a forecasting example on bloggers.com https://www.r-bloggers.com/time-series-analysis-using-r-forecast-package/ And subsequently located the complete pdf https://cran.r-project.org/web/packages/forecast/forecast.pdf Since I created this practice data using the

... and see also ?print.data.frame , the "digits" argument. See also ?str It might be worth your while spending time with an R tutorial or two that covers such topics, i.e. distinguishing between an object and various (S3) methods that "represent" it, such as print(), summary(), plot() etc. -- Bert Bert Gunter "The trouble with having an open mind is that people keep

Hi, Novice UsR here. I have a csv file that contains 13 columns of numeric data that have decimal places (for the most part). After reading in the file RevFCast = read.csv("RevAnalysisNov2016_April2018.csv", header=TRUE, dec = ".", stringsAsFactors=FALSE) and viewing the data View(RevFCast) Some of the fields came in with the correct decimals and some not? The view in R:

The stored numbers are correct. They are rounded on printing. print(RevFCast, digits=17) See ?options And scroll down to digits. On Mon, May 7, 2018 at 11:50 Bill Poling <Bill.Poling at zelis.com> wrote: > Hi, Novice UsR here. > > I have a csv file that contains 13 columns of numeric data that have > decimal places (for the most part). > > After reading in the file >

Dear All .. I use webmin to do the samba PDC configuration The authentication is work well. I've a problem with share permission, the condition is : 1. I've group named "warehouse" 2. I've user named "wh01", with home dir /home/wh01, and be a group member of "warehouse" Both created via webmin. 3. Next I created share, named "warehouse"

Hi , I have created .R file which connects to Teradata database and then does some manipulation and produces the output graph. How to create executable for .R file? Thanks Pariksheet -- View this message in context: http://r.789695.n4.nabble.com/How-to-create-R-executable-tp3790883p3790883.html Sent from the R help mailing list archive at Nabble.com.

A new package is now available on CRAN - pmml. PMML is the Predictive Modelling Markup Language, and is accepted by a number of large database and data warehouse systems (IBM DB2 and NCR Teradata) for deployment of models as SQL. The current package is an "early release" in that it is very basic (and primarily supports the Rattle package). But it is a start! It currently supports rpart

You''ll have to forgive me ... I''ve been toying with rails for about a week and although I don''t feel completely lost there''s still a lot that I don''t understand. Here goes. Assume I have a controller called admin in app/controllers as well as three model classes in app/models: product, category, warehouse. How exactly do I use the admin controller to

Hi, I am working on an old Unix system, UNIX SVR4 MP-RAS, running a Teradata database. Due to the age of the system (notably the C compiler, which won't handle v3 source code), I have built Samba 2.2.12 I want to use this to share Unix directories out to XP clients as network drives, for read-write access, keeping the file ownership as strict unix users. This all works fine, except for

Hey all, I have a fileserver running Debian Etch and Samba 3.0.24 that I use to serve media and private home directories. I have a couple roommates, and therefore have a couple accounts on the box for those users. I had everything working perfectly until last week when my system drive took a crap. I've reinstalled everything exactly the same (I think?) but now I am having problems with

It looks like you made a copy/paste error below. Your ata.frame should be data.frame. Kevin On 05/04/2018 08:18 AM, Bill Poling wrote: > Good morning. > > Novice usR. Here. > > I am following this string, among many, learning as I go. > > Quick question please? > > I thought that perhaps ata.frame was part of the zoo pkg, b/c when I > searched it came up in