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 (March 1998, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 26 Mar 1998 15:10:00 -0500
Reply-To:     george_wang@SMTPLINK.MSSM.EDU
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         george_wang@SMTPLINK.MSSM.EDU
Subject:      help reading the data
Content-Type: text/plain; charset=ISO-8859-1

Dear friends:

I am facing a READING outside file problem. I use WordPad to open the data, and the part of data looks like following: (I do not know what meaning the little black signs in the data and SAS printout, RETURN key or Tab key or something else)

BERD AXXXXXXMS CLOSED #91148 AXXXMS PAUL S. AXXXD 16XXXXXX RD PH 10 ABCDEF RD 26 MNOPQR RD OLD BETXXXXX, NY OLD BETXXXXX, NY SXXXXXX, NY 11894 11894 15883

ARLINE ABCDE PHYLLIS I. DDCCEEFF MANUEL R. SSSSD 1000 PARK AVE 1225 ABCDEDSED ST BASEME 57678 163RD ST APT 9A NT MASSSTH, NY NEW YORK, NY SNOPRSEDC, NY 11378 19928 19998

NORMAN ABCDEFN LOUIS AMMMMMMA DAWN M. BCDEFNNNN 3-5 89TH ST 534 HIJKMNON ST 908 WOODDOWNS DR APT #517 LODI,NJ GSSSSN, NY BROOKLYN, NY 07644 10924 11209

MARK BDBDEE MARY KKKKER MAX J. BBBBBR 2222 E27TH ST 11115 72ND RD 375 NORTH AAA AVE BKLYN,NY APT 8A APT 18S 112295002 FLUSHING, NY NEW YORK, NY 11367 10280

I have read the first and second column groups data without any problems. But when I read the third column group data starting from PAUL S. AXXXD to MAX J. BBBBBR, SAS always give me very strange results. Even I use following the simplest program:

FILENAME GG 'A:\TRIAL2.TXT'; DATA GAA; INFILE GG; INPUT PTNAME $ 1-76; RUN; FILENAME GG; RUN;

PROC PRINT; RUN;

Printout for above SAS program is following:

OBS PTNAME

1 2 BERD AXXXXXXMS CLOSED #91148 AXXXMS PAUL S. AXXXD 3 OLD BETXXXXX, NY OLD BETXXXXX, NY SXXXXXX, NY 4 5 ARLINE ABCDE PHYLLIS I. DDCCEEFF MANUEL R. SSSSD 6 1000 PARK AVE 1225 ABCDEDSED ST BASEME 57678 163RD ST 7 NEW YORK, NY SNOPRSEDC, NY 11378 8 9 NORMAN ABCDEFN LOUIS AMMMMMMA DAWN M. BCDEFNN 10 3-5 89TH ST 534 HIJKMNON ST 908 WOODDOWNS D 11 BROOKLYN, NY 07644 10924 12 13 2222 E27TH ST 11115 72ND RD 375 NORTH AAA A 14 112295002 FLUSHING, NY NEW YORK, NY 15

If I expend the range from PTNAME from $ 1-76, the result will be look like the different, and also very strange.

If some friends want to try and successfully read the data, would you please send me the e-mail and tell me how to do it. I will very appreciate your help.

George


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