Everything works fine except that I want only to fill the dates upto most current date(upto 12 months).  I don't want to fill the dates beyond 12 months.. ... View more

data_null_, I need some help in adding missing dates.  I want the output following way based on the most current dt.  I want to fill the dates upto most current date(upto 12 months). data have;     input ID prod :$1.  dt  val;    informat dt yymmn6.;    datalines; 10  A  201208  2 10  A  201212  3 10  B  201306  5 10  B  201309  2 10  B  201310  1 10  C  201402  9 10  C  201403  3 ;;;;    run;    I want to fill the missing dates based on the most current date available which is  eg. 201403 Output wanted as follows based : ID     prod     dt     val 10      A      201208   2 10      A      201209   . 10      A      201210   . 10      A      201211   . 10      A      201212   3 10      A      201301   . 10      A      201302   . 10      A      201303   . 10      A      201304   . 10      A      201305   . 10      A      201306   . 10      A      201307   . 10      A      201308   . 10      A      201309   . 10      A      201310   . 10      A      201311   . 10      A      201312   . 10      B      201309   2 10      B      201310   1 10      B      201311   . 10      B      201312   . 10      B      201401   . 10      B      201402   . 10      B      201403   . 10      C      201402   9 10      C      201403   3 ... View more

I will be running it on daily basis and checking for the same day.   Yes I would check for records for that day so that I can send email based on which dataset has 0 records. ... View more

I want to send the email saying that "Sales data and Inventory data missing"  /*** if both data are missing *********/  or "Sales data is missing"  /*****if only sales data is missing  *******/ or "Inventory data is missing"  /*****if only Inventory data is missing  *******/ I will be mailing from PC.    SAS running on Windows 7 environment. ... View more

Hi Data_null_, I figured  it out.. I will let you know if I need any help. Thanks ... View more

Hi data_null_, Somehow the above code is not working against my real data.  It does not fill up the missing dates instead it repeats the same the dates in the missing months. Please let me know if how can I can send you the dataset of just 10 obs and 5 columns to test. Thanks ... View more

I am sorry I changed the format to yymmn6. and it worked... Thanks.. ... View more

One more question.   After running the code, In my dt field I am getting M, for example 2010M01.  Is there anyway I can get only 201001? ... View more

Thanks data_null_ for the solution.  It worked.. ... View more

I have tried something like below but it does not give the result I want.  Can anybody help me ?? data have; informat dt yymmn6.; input ID    prod $2.  dt  val; datalines; 10  A  201001  8 10  A  201003  9   10  A  201005  2 10  A  201008  3 10  B  200903  1 10  B  200906  5 10  B  200909  2 10  B  200910  1 run; proc sort data = have;   by id prod dt; run; data want(keep=id prod dt val);   set have;     by id prod dt;   retain StartDate EndDate val;   if first.prod then do;     StartDate=dt;   end;   if last.prod then do;     EndDate=dt;         do dt=StartDate to EndDate;         output ;         end;    end; output; run; proc print; run; ... View more

Thanks Tom... ... View more

I am able to copy the files from one folder to another folder: Below is the code with changes: options missing = ' ' xsync noxwait nosymbolgen nomlogic; filename DIRLIST1 pipe 'dir "c:\Test2013\test*.*" ';                                                                            data dirlist1;                                               infile dirlist1 lrecl=200 truncover;                          input line $200.;                                            if input(substr(line,1,10), ?? mmddyy10.) = . then delete;   length file_name $ 100 ;    file_name=scan(line,-1," ");    keep file_name;   run;         filename DIRLIST2 pipe 'dir "c:\Test2014\test*.*" ';                                                                            data dirlist2;                                               infile dirlist2 lrecl=200 truncover;                          input line $200.;                                            if input(substr(line,1,10), ?? mmddyy10.) = . then delete;   length file_name $ 100 ;    file_name=scan(line,-1," "); keep file_name;   run;      proc sort data = dirlist1;   by file_name; run; proc sort data = dirlist2;   by file_name; run; data final;   merge dirlist1(in=a) dirlist2(in=b);   if a and not b;   by file_name; run; data final;   set final end=eof;   count+1; call symput('read1' || strip(put(count,8.)),left(trim(file_name)));   if eof then call symputx('max_cnt',count);                        run; %put &max_cnt.; %macro file_copy;  data _null_;   %do i=1 %to &max_cnt;    x "copy c:\Test2013\&&read1&i  c:\Test2014\&&read1&i"; %end; run; %mend; %file_copy; ... View more