similar to: Extracting data from SQL Server based on R parameters

Displaying 12 results from an estimated 12 matches similar to: "Extracting data from SQL Server based on R parameters"

2005 Nov 13
1
selection of missing data
Hi i'm a french medical student, i have some data that i import from excel. My colomn of the datafram are the localisations of metastasis. If there is a metatsasis there is the symbol "_". i want to exclude the row without metastasis wich represent the NA data. so, i wrote this mela is the data fram mela1=ifelse(mela[,c(11:12,14:21,23,24)]=="_",1,0) # selection of the
2012 Jan 10
1
Extracting Data from SQL Server
Hi, I am new to R (and rusty on SQL!) and I'm trying to extract records from a SQL server database. I have a table of patient records (LoadPUS) which have three code columns which i want to evaluate against a list of particular codes (CVD_ICD$ table). Given the size of the patient table I want to restrict the data I pull into R to the data I only want to analyse so I am using SQL to do this.
2012 Jan 25
1
Converting strings into data frame column names
Hi all, I want to loop through a series of data frames and append them into one data frame, however I do not want all columns of the original data frames to be in the new data frame. I have the following code: phList<-c('ph2010','ph2009','ph2008','ph2007','ph2006') #Name of original data frames for (i in phList) {
2012 Mar 15
0
Job in Scotland - Analyst Programmer/Data Warehouse Manager
Grade: Grade 7 - 8 depending on experience and skills Salary range: Grade 7 (spine point 29; ?29,099) up to grade 8 (point 40; ?40,280) Duration of Post: Two years in the first instance Location: Medical Research Institute, College of Medicine, Dentistry & Nursing, Ninewells Hospital & Medical School Campus, University of Dundee, DD1 9SY. The
2010 Apr 21
1
Bizarre problem
I can not see how this could be a xen and/or amd64 problem but the evendence seem to point to it. I''m running ltsp under xen 3.4.2 64 bit dom0 on 5 servers. Noticed that on some systems that acroread always crashes when opening a pdf with a fillable form. I see no error messages anywere. Some domu are 32bit debian etch using pygrub. Some domu are 64 bit debian lenny using
2005 Jan 15
2
No sound with X100P (clone)
Hi, can't get X100P (fully zapata compatible clone) to work (I'm in Australia). * recognises the card and the channel (1) but has definetely some problems talking to the pots line. I set up this simple dialplan for ZAP ("incoming" context, as setup in zapata.conf, for channel 1) [incoming] exten => s,1,Answer exten => s,2,Playback(somefile) exten =>
2005 Feb 08
2
giving up on x100p in Australia
OK, I've spent way more time than I wanted to on getting an x100p clone to work in Australia. I'm happy to consider other (more functional) options. Does anyone have an opinion on both the Sipura 3000 and other Digium cards (like the TDM400P)? I need something that works with no much fuzz. I know the Sipura 3000 is cheaper the the TDM400P card. All I need is to channel my POTS line
2005 Jan 15
0
X100P no sound problem
Hi, can't get X100P (fully zapata compatible clone) to work (I'm in Australia). * recognises the card and the channel (1) but has definetely some problems talking to the pots line. I set up this simple dialplan for ZAP ("incoming" context, as setup in zapata.conf, for channel 1) [incoming] exten => s,1,Answer exten => s,2,Playback(somefile) exten =>
2005 Jan 16
0
X100P with no sound!
Hi, can't get X100P (fully zapata compatible clone) to work (I'm in Australia). * recognises the card and the channel (1) but has definetely some problems talking to the pots line. I set up this simple dialplan for ZAP ("incoming" context, as setup in zapata.conf, for channel 1) [incoming] exten => s,1,Answer exten => s,2,Playback(somefile) exten =>
2005 Jan 18
0
X100P not working: no sound
Hi, can't get X100P (fully zapata compatible clone) to work (I'm in Australia). * recognises the card and the channel (1) but has definetely some problems talking to the pots line. I set up this simple dialplan for ZAP ("incoming" context, as setup in zapata.conf, for channel 1) [incoming] exten => s,1,Answer exten => s,2,Playback(somefile) exten =>
2005 Jan 31
0
Playing a file upon pickup (dial command?)
Hi, I'm trying to do the following but can't quite get it right: 1) Callers rings DID number 2) Asterisk rings the appropriate channel for 30 second, if no answer sends to voicemail (no problem up to here, of course) 3) IF the channel is answered Asterisk plays an audio file 4) Asterisk connects caller with me I need to do this to "cover up" the delay within the first few
2005 Feb 01
0
Help with DIAL command
Hi, I'm trying to do the following but can't quite get it right: 1) Callers rings DID number 2) Asterisk rings the appropriate channel for 30 second, if no answer sends to voicemail (no problem up to here, of course) 3) IF the channel is answered Asterisk plays an audio file 4) Asterisk connects caller with me I need to do this to "cover up" the delay within the first few