Date: Thu, 7 Jun 2001 10:16:19 -0400
Reply-To: "Williams, Jeffrey O CONTRACTOR-USARIEM"
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Williams, Jeffrey O CONTRACTOR-USARIEM"
Subject: Re: Proc Import and 0's in SSN's
Content-Type: text/plain; charset="iso-8859-1"
I wasn't specific enough when referring to the SSN's. The SSN's appear
minus the 0's upfront.
However, I was able to resolve the problem using this sas generated code
that I took from the log file and modified (I gave up a bit prematurely):
data WORK.TEST1 ;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile 'path\preforms.txt' delimiter = ',' MISSOVER DSD
lrecl=32767 firstobs=2 ;
format SSN $9. ;
informat SSN $9. ;
if _ERROR_ then call symput('_EFIERR_',1); /* set ERROR detection
macro variable */
From: Louis Broekhuijsen [mailto:email@example.com]
Sent: Thursday, June 07, 2001 10:08 AM
Cc: 'Jeff williams'
Subject: RE: Proc Import and 0's in SSN's
Don't the ssn's appear or just not the zero's?
If the latter try formatting your ssn column with the Zw.d format or the
For "format myssnvar SSN11.;"
CMG Trade, Transport & Industry B.V. Divisie Systems Development
Division Information Management (RTIM1)
PO Box 8566, 3009 AN Rotterdam, The Netherlands
The Information contained in this email and its attachments is confidential
and may be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it. If you are not the intended recipient you are hereby notified
that any disclosure, copying, distribution or taking any actions in reliance
of the contents of this email and any attachments is strictly prohibited and
may be unlawful. CMG is neither liable for the proper and complete
transmission of the information contained in this email and any attachments
nor for any delay in its receipt. If received in error, please contact CMG
on +31 (0)020 50 33 000 quoting the name of the sender and the addressee
and then delete it from your system. Please note that CMG does not accept
any responsibility for viruses and it is your responsibility to scan the
email and attachments (if any). No contracts may be concluded on behalf of
CMG by means of email communications.
From: Jeff williams [ mailto:jeffrey.williams@NA.AMEDD.ARMY.MIL
Sent: donderdag 7 juni 2001 15:00
Subject: Proc Import and 0's in SSN's
Probably a simple answer out there; I'd appreciate some help finding it.
I'm using the following code to read in a dataset in .txt format:
proc import out=test
It reads in the data fine with the exception of ssn's that begin with one
or more zero's; they simply don't appear. How do I get them to appear?
Thanks in advance for your assistance,