Hello everyone, I'm trying to automatize a simple yet time-consuming task. Everyday I have new data on interviews. I need to keep track of how many interviews are created each day and how many of these interviews are closed. What I have (variables): Created (date of creation, e.g. "30/01/2018") closetim (date when interview is completed, e.g. "02/02/2018") Now, what I'm trying to accomplish is to create a dataset with 4 columns: 1st column: which tells me the date of when the data was downloaded (e.g. 03/02/2018), 2nd column = "Created" date 3rd column = "count of interviews with date = "created" date 4th column = "count of observations that has been closed (closetim not equal to missing) where date = "created" date" Then, each day I can run the code and append new counts of interviews created and closed to an access database. I have tried to visualise it in the attached screendumps: Any help is much appreciated, Kind regards, Kristian I'm using SAS Base 9.4 at work (student assistant), and sas university edition at home. My code so far: DATA have; SET have; DATA have;
SET have;
created = datepart(created);
closetim = datepart(closetim);
ATTRIB created FORMAT = ddmmyy8.;
ATTRIB closetim FORMAT = ddmmyy8.;
RUN;
PROC SQL;
CREATE TABLE newdata AS
SELECT Created, closetim
FROM have
ORDER BY created;
QUIT;
DATA newdata;
set newdata;
downloaddate = today();
ATTRIB downloaddate FORMAT = ddmmyy8.;
RUN;
DATA newdata;
SET newdata;
c_created = count(created);
RUN;
DATA newdata;
SET newdata;
if closetim ^= . then c_closetim = "closed";
RUN;
... View more
