I have a full data set (All), and 3 sub data sets (A, B, C). How to select the cases that are in All, but not in any of A, or B, or C?   I can merge A, B, C into a new dataset and then compare All and the newly merged dataset, but I wonder if there is a simpler way to do it?   Thanks ... View more

I have data set with variables Customer_ID, transaction_time, order_amount, etc   I want to: 1) count how many orders each person made per day; 2) sum the total order_amount each day for each person.   transaction_time in datetime16. format, so I can create a new variable of the day by datetime(transaction_time)   Can anyone direct me to an example how to fulfull these two goals? Thanks   ... View more

I have 7 similar data sets, and I want to select cases that exist in two data sets, so I have 21 combinations of 2 of the 7 sets. so I want to use a macro to speed this up. Below is my code: %macro both(A,B); proc sql; create table &A&B as select A.ID, A.Gender, A.age from &A.demographics as A, &B.demographics as B where A.ID = B.ID; quit; * then count; proc sql noprint; select  count(*) into    :OBSCOUNT from    &A&B quit; %put Count=&OBSCOUNT.; %mend both; %both(data1,data2) It works. But I still have to type the 21 combinations, like %both(data1,data2), %both(data1,data3), ...   How can I improve it with a do loop?   also, in the last step, %put Count=&OBSCOUNT.; can I print out the two data sets names, &A and &B? how?   Thank you ... View more

  I was able to use the code belwo to batch process files with names like 201501.csv, 201502.csv,.. etc   Now I have 12 files, whose names are named by months, like xxxx-Jan2014.csv, xxxx-Feb2014.csv, ... xxxx-Dec2014.csv. Is there a way to use the similar code below?   %macro run_me; %let n=1; %do %while (&n <= 9); %let filein = xxxx20150&n..csv; data output&n; infile &filein; <data step--> run; %let n=%eval(&n+1); %end; %mend; ... View more