05-18-2016 01:06 PM
I've been trying to solve this problem on and off for a number of days without much luck. Appreciate any thoughts on it.
I create this variable:
%let today = today(); data _null_; call symput ('Stamp',"Report created: "||put(today(),mmddyy10.)); run; %put &Stamp;
It gives me the following: Report created: mm/dd/yyyy
All I want to do is take this variable and export it to a specific cell in excel. Seems easy, maybe it is, but I haven't been able to figure out how to do it without creating a table in SAS first.
I can't use DDE because the code will ultimately run from a server that does not have excel installed. I can do it locally but ultimately that's not gonna work.
Code for the curious:
options noxwait noxsync xmin; %sysexec "&Directory\&tprogram..xlsb"; data _null_; rc = sleep(15); run; filename Workbook DDE 'Excel|Sheet1!R1C1'; data _null_; file Workbook; Stamp = "&Stamp"; put Stamp; run;
I've resorted to creating a table and appending it.:
data Stamp; Time_Stamp = "&Stamp"; run; Libname WrkBk EXCEL "&directory\&program..xlsb" Scan_Text = No; PROC DATASETS LIB = WrkBk; DELETE Stamp; RUN; QUIT; PROC APPEND BASE = WrkBk.Stamp DATA = Stamp; RUN; Libname WrkBk CLEAR;
Is there a way to just export the variable without having to go through the process of creating a table for it while also not using DDE? Maybe ODS? Appreciate any thoughts.