Date:         Tue, 3 Feb 2009 16:00:59 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Data Format
Comments: To: ali6058@GMAIL.COM

Al,

Try:

PROC EXPORT DATA= WORK.have
            OUTFILE= "c:\want.xls"
            DBMS=XLS REPLACE;
RUN;

I don't think it requires SAS Access to PC Files.

Art
-------
On Tue, 3 Feb 2009 12:48:46 -0800, 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..