Hi all, I can't execute a simple Random walk forecast in SAS Studio because of this error below. Before today, I was able to run the said forecast with same date field and dependent field.  I have not change anything.   Thank all for the advices on what to do. ... View more

I want to have two datasets split evenly from a much larger dataset but before the split, SAS must not split obersvations that are in same zipcodes (criteria).  We want to mail an food offer from a dataset we created but  with two different valid dates.  The first valid date is assigned to the first splited dataset and second valid dates assigned to the second splited dataset.   However, we don't want to separate married couple who want to dine together.  Our manual logic is to sort by zip codes and split the datasets evenly and right before the split make sure no two address are the same.  Below is what our rows of data look likes.    ID FN LN Address City State state ZIP 1111111 Wayne Smith 111 Left St BROOKLYN NY 11234 1111112 Mary Smith 111 left BROOKLYN NY 11234   A dataset with 10,000 rows split evenly: Dataset 1 = 5,000 Dataset 2 = 5,000    But don't separate same zip codes.    Please help!   ... View more

HI, I have  SAS EG version 6.1(64-bit).  I want to export a dataset into an already created xls file.  The codes went through without any errors but nothing in the file when i opened it.  The file, "Test" is completey blank.  Below are my codes.  Appreciate the help.   proc sort data=WORK.QUERY_FOR_QUERY_TABLE_PRELOADS out=class; by 'Type of Mailer'n; where 'Type of Mailer'n in ('Active - Low Freq'); run ;quit; proc export data =work.class outfile ='C:\Users\User\Documents\My SAS Files\Test.xls' dbms=xls replace; sheet='Test'; quit; ... View more