About reef

reef · ‎06-14-2016

Thanks to all. I replied as soon as answers were sent but was not aware that my final update was not recorded on the site. I have opted to remove the apostrophe from the filename and path. Best regards and thanks again.

reef · ‎05-29-2016

I have been using dde to send data to an excel file without a problem until I found one case where the file path contains an apostrophe. In this case the dde link fails due to the apostrophe in the path. I tried every masking function to no avail and in the end I had to remove the apostrophe from the folder name. Has anyone resolved a similar case? Example, data d; do x=1 to 10; y=exp(-x); output;end; run; %let xlf = %bquote(c:\temp\sas\dde'tests\test.xlsm); filename xl dde "exce|[&xlf.]sheet1!r1c1:r11c2" notab lrecl=200; data _null_; file xl; set d; put x y; run;

reef · ‎04-18-2016

Finally it works! a combination of notab in the fielname statement and the naming of variables as Reeza suggested ie. 'REPORTING MONTH' '09'X 'CLAIM COUNT'; Thank you all.

reef · ‎04-18-2016

as i said previously, all ideas with '09'x, notab, @ etc were considered and all failed. there's no error in the log except that variables are not unitialised message due to spaces in variable names. here's a simple dataset for you to experiment on with the aim of writing it to excel. data d; format 'report month'n ddmmyy10.; 'report month'n = "1mar16"d; 'claim count'n = 1; output; 'report month'n = "1apr16"d; 'claim count'n = 2; output; 'report month'n = "1may16"d; 'claim count'n = 3; output; run; please note that I'm aware there are other ways to do this but I need this done using DDE.

reef · ‎04-18-2016

It makes no difference. The notab option is included in both the filename and file. Filename xl dde "&xlfile." notab lrecl =2500; Data _null_; set dat ; file xl notab; /* with or without */ If _n_ = 1 then put 'report month'n 'claim count'n; ##- Please type your reply above this line. Simple formatting, no attachments. -##

reef · ‎04-18-2016

is there a way to export sas variables to excel via dde when the variable names contain spaces? eg. put 'reporting month'n 'claim count'n. I have explored every idea using '09'x and @ and formats with the put statement but all failed.

Online Status	Offline
Date Last Visited	‎01-21-2017 01:47 PM

Re: using dde where path contains an apostrophe

using dde where path contains an apostrophe

Re: sas variable names with spaces

Re: sas variable names with spaces

Re: sas variable names with spaces

sas variable names with spaces

Re: Concatenate multiple rows into a single value

Re: using dde where path contains an apostrophe

using dde where path contains an apostrophe

Re: sas variable names with spaces

Re: sas variable names with spaces

Re: sas variable names with spaces

sas variable names with spaces