LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2006, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 23 Jun 2006 14:11:16 -0700
Reply-To:   "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Subject:   Re: How to change .xls files into .txt files in SAS
Comments:   To: SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL.COM>
In-Reply-To:   <200606232052.k5NJbGs5008299@mailgw.cc.uga.edu>
Content-Type:   text/plain; charset="us-ascii"

Hmmm, I ran the sample code on 8.2 with XP-Pro and got the expected tab delimited text files. ...I presume you are looking at the results with a text editor...

Mark

-----Original Message----- From: SUBSCRIBE SAS-L Chandra Gadde [mailto:ddraj2015@GMAIL.COM] Sent: Friday, June 23, 2006 1:53 PM To: SAS-L@LISTSERV.UGA.EDU; Terjeson, Mark (IM&R) Subject: Re: How to change .xls files into .txt files in SAS

Hi Mark,

I couldn't see any data in the dataset we imported. All I could see is bunch of html language.I am using Microsoft Windows XP, Professional. Should I be using something else for this configuration. I have SAS 8.2.

PROC IMPORT OUT=theTmpDS DATAFILE="&theXlsNm" DBMS=EXCEL2000 REPLACE; GETNAMES=YES; RUN;

Thank you for your help.


Back to: Top of message | Previous page | Main SAS-L page