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 (April 2003, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 8 Apr 2003 15:00:11 -0400
Reply-To:     Howard_Schreier@ITA.DOC.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Howard_Schreier@ITA.DOC.GOV
Subject:      Re: Infile Statement : Immediate response reqd.

I too presume that the asterisk designates a missing value.

Assuming that there are no asterisks which must be preserved as such, "_INFILE_ Magic" can be employed here:

data asterisk_means_missing; infile 'copy.txt' firstobs=2; input @ ; _infile_ = translate(_infile_,'.','*'); input wealth age region $; run;

On Mon, 31 Mar 2003 20:13:09 -0800, SASler <soundblast100@YAHOO.COM> wrote:

>wealth age region >37 50 M >24 88 U >14 64 A >13 * U >13 66 U >11.7 72 E > >i need to copy this text file into sas. when i tried to use the infile >statement, INFILE "C:\test\copy.txt" FIRSTOBS=2; >i am getting an error "invalid data for age". >how do i copy this file? Thanks all.

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