HI,
what I'm trying to do is export a table to excel with a couple of excel comment boxes in row1 ... I need to auto insert a comment box into the file..
thanks for your assistance
I think it might be in NOTE command.
HI Reeza,
i have this but for some reason it's not finding the file
data _null_;
set class;
file ddedata;
put Name '09'x Sex '09'x Age '09'x Height '09'x Weight;
run;
data test1;
length name $10 sex $1;
input name & sex age height weight;
cards;
Alfred M 14 69.0 112.5
Mary Anne F 12 66.5 94.0
run;
/* WRITE BODY */
filename ddedata dde"excel|[C:\Users\U770846\Desktop\GC.xls]||sheet1!r3c1:r4c5";
data _null_;
set test1;
file ddedata;
put name sex age height weight;
put 'objWorksheet.Cells(1, 1).AddComment "Test comment."';
run;
I found what I needed using tags
Can you post it back to the thread, I'm curious.
Also useful if someone else has the same question.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.