sql

  1. O

    Predict user departure time from parking lot with user behavior learning \ Filtering unnecessary data

    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...
  2. S

    Healthcare applications

    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...
  3. D

    Using RStudio Server with PostgreSQL Database

    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...
  4. A

    closest value into a macro variable

    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...
  5. F

    How many data rows can SPSS handle?

    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...
  6. M

    Create unique variable names in macro

    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...
  7. N

    SQL Pass through DB2

    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 *...
  8. B

    Could anyone recommend an interactive application for mass data analysis?

    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...