Hi SAS community,  I know how to do matching if there is already a test group set up.  But if we are trying to select test/control group before the intervention happens, what code do I use? the idea is to select comparable 1:1 cohorts and randomize one to test and one to control. The variables we are trying to control for are demographic, access to internet, and previous received marketing volumes, etc.  Is there any paper on this where I can read on? or any existing codes?   Thanks so much for your help!   SAS user ... View more

Dear SAS users,  this task has been killing me.... Please help me if you can.  I am trying to develop a customer base by creating a xls out of thousands of vcf.  Is there any way I can automate this process instead of doing thousands times of copying and pasting?   basically a vcf card looks like this in a text format, and I want to write a program that reading N, FN, ORG, TITLE, TEL, ADR Even if I can't automate the entire process, I will be very appreciative if anyone can share any shortcuts! BEGIN:VCARD VERSION:2.1 N:Doe;John;;; FN:John Doe ORG:Doe Company, The; TITLE: President NOTE;ENCODING=QUOTED-PRINTABLE: This is a note associated with this contact=0D=0A TEL;WORK;VOICE:(987) 123-4567 TEL;HOME;VOICE:(987) 765-4321 TEL;CELL;VOICE:(987) 135-8642 TEL;WORK;FAX:(987) 246-1357 ADR;WORK:;;1234 North Street;Anytown;TX 751234;;United States of America LABEL;WORK;ENCODING=QUOTED-PRINTABLE:1234 North Street=0D=0AAnytown, TX 751234 =0D=0AUnited States of America URL: URL:<WWLINK TYPE="GENERIC" VALUE="http://www.doeweb.com">http://www.doeweb.com</WWLINK> EMAIL;PREF;INTERNET:jdoe@nowhere.com REV:19980114T170559Z END:VCARD   Thank you! ... View more

Hi,  I was given an interesting task with somehow complicated logic to caluclate monthly consumption. I was given three variables as such, and I have certain logic, look for the next order date, and if volume is bigger than the previous order, if volume is bigger, assuming the customer has used up all the inventory. if the next order is smaller, then assuming customer has only used up the new order amount (for replenshiment). Then I need to count the daily consumption volume based on the volume and number of days between order. Then I calculate number of days used in any given month to come up with a monthly consumption number for any given customer. My final goal is to sum up by month, so I can get a consumption total by month.   company  order date  volume  111 12/23/2016 4 111 1/4/2017 5 111 1/20/2017 3 123 11/22/2016 5 123 12/22/2016 3 123 2/25/2017 2   outcome (or my way of thinking) is attached.  I have tried several different ways, but can't quite figure it out. can someone help, Is there any easier way to do this?    Thanks so much!   Joanne ... View more