Hi guys!   I am using the following script to send e-mails: Filename OK&id Email From = ("&SENDER") Sender = ("&SENDER") To = ("&RECEIVER" ) Subject = "&SUBJECT" ATTACH = ("&AttachmentPath") ; data _null_; file OK&id; PUT "&Content" //; run; In the log file I see the following: NOTE: 3 records were written to the file OK4.       The minimum record length was 0.       The maximum record length was 19.   I want to execute a subsequent data step which is based on if recrods were written to the file because if the mail part fails there's no records written to the file (or at least indicated in the log). Is there a way for me to check how many records are in the file OK4 in my code?   ... View more

Hello everyone,   Basically, I'm trying to create the following macro:   %Macro CheckDate;   %if &month= this month %then %do;             Proc Sql;           Create table Work.Test1 as           Select A.*           From Work.Table1            ;           Quit; %End;   %Else %do;   signoff   %End; %Mend; %CheckDate;     I am trying to get my month macrovariable to be the month part for the first observation from a datetime column from another table (lets say Work.Table2). Any ideas how can I do that? ... View more

Hey guys!   I currently have a programme that generates new records every Sunday for a certain period. Two of the columns in the table are PERIOD_START and PERIOD_END. I want the programme to add the new weeks' records into another table after every run.   Currently I use INSERT INTO in PROC SQL, which works fine, however if I have a change in source data and need to re-run the programme again mid-week(not a Sunday) it creates duplicate records in my destination table. How can I re-write the PROC SQL so the query first checks if the PERIOD_START and PERIOD_END dates from the new table match in the destination table and: 1. If they do - overwrite the rows with the new data 2. If they don't - just execute the insert into.   Cheers!   ... View more