@baskisb wrote:
Hi ,
Im using proc export with DBMS = csv and replace option and the email getting generated to outbound location.
But what i observed the the columns which has character values in SAS dataset ( for example : Classfication : 1,2,3 ( in char) ; Flag = 4,7,1 ( in char) ) those are changing as numeric when i open csv file on email.its automatically changing char to numeric as right alignment .
Could you please help in proc export how do we fix this , kindly help on this case.
Thanks
Venkat
A CSV file is jut plain text. It has no metadata about the type of data in contains (other than the optional header row).
What program are you using to view the CSV file? If it is Excel you need to do a little work to tell it what data type to use for each column.
... View more