Displaying 8 results from an estimated 8 matches for "stodnr".
2004 Jul 23
2
retrieve rows from frame assuming criterion
Hi all,
I have a data frame in which one column(PUNTAR) is of character type.
What I want is to retrieve is the frame but only with those rows matching elements of PUNTAR with a list characters (e.g c("IX49","IX48") )
Year TUR STODNR PUNTAR
1994 9412 94020061 IX49
1994 9412 94020062 IX48
1994 9412 94020063 X32
1994 9412 94020065 X23
1994 9412 94020066 X27
1994 9412 94020067 XI19
1994 9412 94020068 XI16
1994 9412 94020069 XI14
1994 9412 94020070 XI8
1994 9412 94020071 X25...
2014 Apr 01
3
problema con RStudio
...una base de datos.
Desde la terminal no tengo problemas para ejecutar, por ejemplo:
library(RODBC)
channel <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd =
"MiContrasena")
datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \
, M.STODNR \
...
...
...")
pero desde Rstudio me encuentro siempre con el siguiente error:
Warning messages:
1: In odbcDriverConnect("DSN=MiBaseDatos;UID=MiUsuario;PWD=MiContrasena") :
[RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver
Manager]Can't open lib
'/u01/app/lui...
2004 Jul 23
0
retrieve rows from frame assuming criterion [corrected]
...column(PUNTAR) is of
> > character type.
> > > What I want is to retrieve is the frame but only with those
> > > rows matching elements of PUNTAR with a list characters (e.g
> > > c("IX49","IX48") )
> > >
> > > Year TUR STODNR PUNTAR
> > > 1994 9412 94020061 IX49
> > > 1994 9412 94020062 IX48
> > > 1994 9412 94020063 X32
> > > 1994 9412 94020065 X23
> > > 1994 9412 94020066 X27
> > > 1994 9412 94020067 XI19
> > > 1994 9412...
2004 Jul 23
1
R: retrieve rows from frame assuming criterion [corrected]
...have a data frame in which one column(PUNTAR) is of
> character type.
> > What I want is to retrieve is the frame but only with those
> > rows matching elements of PUNTAR with a list characters (e.g
> > c("IX49","IX48") )
> >
> > Year TUR STODNR PUNTAR
> > 1994 9412 94020061 IX49
> > 1994 9412 94020062 IX48
> > 1994 9412 94020063 X32
> > 1994 9412 94020065 X23
> > 1994 9412 94020066 X27
> > 1994 9412 94020067 XI19
> > 1994 9412 94020068 XI16
> > 1994 9...
2014 Apr 01
2
problema con RStudio
...ar, por ejemplo:
> >
> > library(RODBC)
> > channel <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd =
> > "MiContrasena")
> >
> > datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \
> > , M.STODNR \
> > ...
> > ...
> > ...")
> >
> > pero desde Rstudio me encuentro siempre con el siguiente error:
> >
> > Warning messages:
> > 1: In
> odbcDriverConnect("DSN=MiBaseDatos;UID=MiUsuario;PWD=MiContrasena") :
> > [RODBC] ERROR...
2014 Apr 01
3
problema con RStudio
...RODBC)
> >> > channel <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd =
> >> > "MiContrasena")
> >> >
> >> > datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \
> >> > , M.STODNR \
> >> > ...
> >> > ...
> >> > ...")
> >> >
> >> > pero desde Rstudio me encuentro siempre con el siguiente error:
> >> >
> >> > Warning messages:
> >> > 1: In
> >> > odbcDriverConnect(&...
2014 Apr 01
2
problema con RStudio
...l <- odbcConnect("MiBaseDatos", uid = "MiUsuario", pwd =
>>> >> > "MiContrasena")
>>> >> >
>>> >> > datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \
>>> >> > , M.STODNR \
>>> >> > ...
>>> >> > ...
>>> >> > ...")
>>> >> >
>>> >> > pero desde Rstudio me encuentro siempre con el siguiente error:
>>> >> >
>>> >> > Warning messages:
>>...
2014 Apr 01
2
problema con RStudio
...s", uid = "MiUsuario", pwd =
>> >>> >> > "MiContrasena")
>> >>> >> >
>> >>> >> > datos <- sqlQuery(channel,"SELECT TO_CHAR(S.B_STOD_DATO,'YYYY') \
>> >>> >> > , M.STODNR \
>> >>> >> > ...
>> >>> >> > ...
>> >>> >> > ...")
>> >>> >> >
>> >>> >> > pero desde Rstudio me encuentro siempre con el siguiente error:
>> >>> >> >...