Date:         Mon, 13 Sep 2010 14:01:57 -0400
Reply-To:     Yusuf Mohamedshah <zulsdad@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Yusuf Mohamedshah <zulsdad@GMAIL.COM>
Subject:      SAS to Excel conversion problem
Content-Type: text/plain; charset=ISO-8859-1

I have a SAS dataset with a  char 21 variable called CASENO with following
values:

Obs           caseno
  1    200002120940915013529
  2    200010211919915009018
  3    200002291540915008307
  4    200002221040915008307
  5    200003081520915008307
  6    200008101050915011201
  7    200008121500915013529
  8    200008071630915013529
  9    200012201445915015839
 10    200011040915915015839
 11    200011121840915015839
 12    200005291850915013529
 13    200008061500915013529
 14    200004282040915008307
 15    200011032215915015839
 16    200004061530915008307
 17    200005201204915008307
 18    200010290800915013529
 19    200005281630915013529
 20    200010261900915013529
 21    200009131840915009018
 22    200011141315915010538
 23    200012150930915013529
 24    200009151730915013529
 25    200007041645915013529

I am trying to convert this file to CSV so that it can be read by Excel.
When I convert the file using SAS Export facility the CASENO gets converted
as numeric and it shows as a scientific notation number with 2E+20 and when
I try to format the column as number all the last five digits are replaced
by zeros. How do I convert this SAS file to CSV file keeping CASENO intact?
I am using SAS 9.2 on windows XP machine.

I even used DBMSCOPY to convert the file but with the same results.

Thanks any help would be appreciated.
--
Yusuf Mohamedshah