Hi Mike, You might also use the following alternative:      %put %superq(cc%eval(&g+1)); Regards, Florent ... View more

In my opinion, it will never update any row unless the account statuses and "as of" dates have been updated between the moment of your selection and the moment you execute the update statement. This because 'ACCOUNT_STATUS' and 'AS_OF_DT' are used in the where clauses of both the inner select and the update statement. ... View more

Certainly because the last data step was missing. I have edited my original post. ... View more

Hi, Am I the only one having troubles with the email notifications when an answer to a thread is posted? In fact I don't get any email at all Thanks ! Regards, Florent ... View more

Thanks! So, here is the sample program that I used to save an email as a .msg file: data _null_;       currentDate= compress(put(today(), yymmdd10.), '-');       currentTime= compress(put(time(), time8.), ':');       call symput('timespan', compress(currentDate || currentTime)); run; filename vbs "C:\WINDOWS\Temp\SaveEmail_&timespan..vbs" lrecl=256; data _NULL_;       file vbs;       put 'Set objOutlook = CreateObject("Outlook.Application")';       put 'Set objMailMessage = objOutlook.CreateItem(0)';       put 'With objMailMessage';       put '.To = "&sysuserid."';       put '.Subject = "Test Email"';       put '.Body = "Hello," & Chr(10) & Chr(10) & _';       put '"This is a test email." & Chr(10) & Chr(13) & _';       put '"The purpose of this email is to test that it was correctly saved on your desktop."';       put ".SaveAs ""C:\Documents and Settings\&Sysuserid.\Desktop\Test_Email_&timespan..msg""";       put 'End With'; run; options noxwait xsync; X "WScript //NoLogo //B C:\WINDOWS\Temp\SaveEmail_&timespan..vbs"; filename ERASEIT pipe "del ""C:\WINDOWS\Temp\SaveEmail_&timespan..vbs"""; data _NULL_;       infile ERASEIT; run; ... View more

I've tried but it still looses some lines of my code... It also breaks some lines of code into multiple lines in my post  :smileyconfused: Isn't it possible to use an html tag in order to quote the code ? I saw a lot of correctly formatted code on the old SAS discussion forum. Thanks! ... View more

All, I did accomplish the goal of my request by: generating a VB script with SAS having the VB script executed via a DOS command launched from SAS For those who are interested, I could share a sample of the SAS program that I have created. Regards, Florent P.S: What is the trick to use in order to copy/paste a SAS program into a post ? Each time I do it, I loose a lot of code... ... View more

Hi Ruth, Maybe the following macro could help on earlier versions of SAS. Regards, Florent %MACRO SearchMissingValues(ds=); %local lib table; /* Retrieves the library and table (dataset) name from the parameter of the macro */ %let lib   = %upcase(%scan(&ds, 1, '.')); %let table = %upcase(%scan(&ds, 2, '.')); options nonotes; /* Count the number of variables in the dataset provided as parameter of the macro */ proc sql noprint;   select count(name)   into :cnt   from dictionary.columns   where upcase(libname) = "&lib"     and upcase(memname) = "&table"; quit; %let cnt = &cnt; /* Removes the leading and trailing blanks */ /* Retrieves all the variables' names which are stored in the dataset provided as parameter of the macro */ proc sql noprint;   select name   into :var1-:var&cnt   from dictionary.columns   where upcase(libname) = "&lib"     and upcase(memname) = "&table"; quit; %IF &cnt > 0 %THEN %DO;    data work.&table (keep= missingVar:);      set &ds;      %DO i=1 %TO &cnt;           missingVar&i = missing(&&var&i);      %END;    run;   %DO i=1 %TO &cnt;     %let var&i = &&var&i ; /* Removes the leading and trailing blanks */    %put var&i = &&var&i;   %END; %END; %MEND SearchMissingValues; ... View more