Date:         Wed, 24 May 2000 13:06:43 -0400
Reply-To:     RHODESD1 <RHODESD1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         RHODESD1 <RHODESD1@WESTAT.COM>
Subject:      Proc Access - Excel to SAS creates missing values???
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-Type: text/plain; charset=US-ASCII

Amy,
If you have embedded decimal points in your icd-9 codes, you might do
best to use a format to tell excell it is character data.  Also, make sure there
is valid character data in the first row of your spread sheet.

 Snippet below:

%do i = 1 %to &nf ;
%let outp="n:\mepsfy97\dianne\mps\excel\mps98cnd&i..xls";
/* write data to excel spreadsheet */
    proc dbload dbms=excel data=out1.test ;
    path=&outp ;
    putnames=y ;
    format condnam $char46. ctextnum 4.;
    where rset=&i ;
    delete rset ;
    version=5;
    limit=0;
    load ;
   run;
%end ;

Dianne Rhodes
rhodesd1@westat.com
running those #!$% imputations!
--------------------------------------------------------------
original message:
Date:    Wed, 24 May 2000 11:22:30 -0400
From:    Amy Lavis <alavis@DFMC.ORG>
Subject: Proc Access - Excel to SAS creates missing values???

Hi!!

I tried proc access to create a SAS dataset from Excel, but am
getting missing values for icd-9 codes. The problem (I think) is
that the field looks like it has numeric and character values but
it is really supposed to be character in SAS. Any suggestions??

Thanks!
Amy