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!!
create table table4 as
(N_tot / sum(N_tot) * 100) as N_tot_Pct
from table4a where circdist ne 0;
numbers in sas are outtputted as
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