Cannot find a delete post feature. so please ignore as problem has been resolved!!
I am creating a percentage via sql. I am transferring it to Excel through a DDE Link. I have successfully done this for a few tables. the problem is for 1 table I keep getting trailing "--" or " ." in the entries. I cannot determine why!!
proc sql;
create table table4 as
select *,
(N_tot / sum(N_tot) * 100) as N_tot_Pct
from table4a where circdist ne 0;
quit;
numbers in sas are outtputted as
0.6 .
0.3 .
1.5 .
or
0.6 --
0.3 --
1.5 --
I removed any formatting options from both the sas data set and excel set to ensure that this was not the issue
Message was edited by: Hart