Date:         Thu, 7 Jun 2001 10:16:19 -0400
Reply-To:     "Williams, Jeffrey O CONTRACTOR-USARIEM"
              <Jeffrey.Williams@NA.AMEDD.ARMY.MIL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Williams, Jeffrey O CONTRACTOR-USARIEM"
              <Jeffrey.Williams@NA.AMEDD.ARMY.MIL>
Subject:      Re: Proc Import and 0's in SSN's
Comments: To: SAS-L@LISTSERV.VT.EDU
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. ;

       input
                   SSN

       ;
       if _ERROR_ then call symput('_EFIERR_',1);  /* set ERROR detection
macro variable */

run;

Cheers,

Jeff

-----Original Message-----
From: Louis Broekhuijsen [mailto:louis.broekhuijsen@cmg.nl]
Sent: Thursday, June 07, 2001 10:08 AM
To: 'SAS-L@AKH-WIEN.AC.AT'
Cc: 'Jeff williams'
Subject: RE: Proc Import and 0's in SSN's


Dear Jeff,

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

For "format myssnvar SSN11.;"

Kind regards,

Louis Broekhuijsen
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CMG Trade, Transport & Industry B.V. Divisie Systems Development
Division Information Management (RTIM1)
PO Box 8566, 3009 AN  Rotterdam, The Netherlands
E-mail: Louis.Broekhuijsen@CMG.NL
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.

-----Original Message-----
From: Jeff williams [ mailto:jeffrey.williams@NA.AMEDD.ARMY.MIL
<mailto:jeffrey.williams@NA.AMEDD.ARMY.MIL> ]
Sent: donderdag 7 juni 2001 15:00
To: SAS-L@AKH-WIEN.AC.AT
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
     datafile="path.txt";
     delimiter=",";
run;

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,

Jeff Williams