| 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.
| 
