sql

First, I say I have no choice but to explain the whole process in favor of the question that will be asked at the end of the explanation. I'm sorry for the large amount of words that came out. your help is important to us further down the road so please, take a few minutes to help us with this...

I work in healthcare and I was wondering what sort of analytics/modeling projects members of this forum are doing. I guess it would be nice to see how other healthcare institutions are utilizing different tools to solve different problems. I for instance have just embarked on developing a...

I have installed a RStudio Server on Ubuntu OS machine and PostgreSQL data base for ingesting data. I am able to connect to DB using RPostgreSQL package. I have been able to successfully execute many SQL queries on the data. Can I analyze the data without ingesting data in RStudio. How do I...

Hi everyone, I have a numeric variable, lets call it 'times'. I have a macro variable 'myTime' defined to be some value, lets say 200. I would like to extract the closest value in 'times' to 'myTime' as a new macro variable 'closestTime'. Would anyone know how to modify the code below so it...

In a few weeks an internet survey will hopefully start that should get a response rate of somewhere between 2 and 6 thousand people. I'm assuming the latter for now, just to be sure. The (MySQL) table will be split into subtables, but the biggest subtable might still have some 2500 records...

Hi I have a functioning macro running through daily datasets. The macro itself works as it should and I get the outputs I want. I would however like for SAS to save the files it generates as OUTPUTAdate OUTPUTBdate etc. I can do so using this: data&year&mon2&day2 and then substitute...

I am new to the pass thru code, i am using the following code to connect to db2 thru EG libname abc db2 dsn=*** uid=*** pwd=*** schema=****; proc sql noerrorstop; CONNECT TO db2 as myODBC (DSN=**** UID=*** PWD=****); create table def as select *...

Hi, everybody I need to conduct a large amount of data analysis on database. Could anyone recommend an interactive application for data analysis? The requirements are: 1. Able to cope with the unexpected requirement rapidly. 2. Able to perform further computations on results...