My money is on Excel being at fault in the conversion from CSV to Excel. You might look into Mary's solution - I think you can use Excel tagsets without SAS/ACCESS.

Otherwise, you either need to format the field as a text field when you bring it in from the CSV before converting to excel, or add a ' in the field (excel character field marker) before the data so, '1-2 for example. You can put that in while in SAS, not sure how CSV will handle it but I think it should preserve it.

-Joe

On Tue, Feb 3, 2009 at 2:48 PM, Al <ali6058@gmail.com> wrote:

> On Feb 3, 9:36 am, Al <ali6...@gmail.com> wrote: > > Hi : > > i am trying to import a SAS dataset in to exceel spread sheet .. one > > of the variable X has data values > > > > X > > > > 1 > > 2 > > 4 > > 56 > > 1-2 > > 2-6 > > > > when i import it into spread sheet the values in the spread sheet are > > showing up as > > x > > 1 > > 2 > > 4 > > 56 > > 2-Jan > > 6-Feb > > > > any suggestions please > > > > Thanks in advance.. > > I am just right clicking on the SAS dataset from explorer window and > selecting the export and saving it to a csv file > first .. and then to excel spread sheet .. i dont have SAS/Access > on my machine .. > > Thanks in advance.. >