Date:         Wed, 1 Dec 2010 14:40:31 -0800
Reply-To:     art297 <atabachneck@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         art297 <atabachneck@GMAIL.COM>
Subject:      Re: Proc Export
Content-Type: text/plain; charset=ISO-8859-1

First, not related to your question, your code has some redundancy.
Why use proc sql to create a macro variable, and then include a %let
to convert the macro variable into itself?

Regardless, does your log specify exactly what you showed?  Typically,
it will show the line and column where the conversion occured and,
with proc export, it is usually where the proc creates macro variables
based on returned error codes.  Those aren't a problem in themselves,
but I've never seen a log message like you report (i.e.,
> NOTE: Numeric values have been converted to character values at the
> places given by: (Line):(Column).
>       -47E5:***   -47E5:***

Art
-------------
On Dec 1, 11:35 am, dc353 <dc...@hotmail.com> wrote:
> I'm running the follow code.  The csv file that it creates is correct
> but I'm getting the following log message and wondering if there's a
> problem:
>
> %let out_tbl = fees.all_detail;
>
> data file_csv;
> length fname $25;
> keep fname;
>      fname= "&out_tbl";
>      xlen = length(fname);
>      do i = 1 to xlen;
>      if substr(fname,i,1) = '.' then fname = "'c:\fees\" ||
> substr(fname,i+1,xlen-i) || ".csv' ";
>      end;
> run;
>
> proc sql noprint;
>      select fname into: file_csv
>      from file_csv;quit;
>      %let file_csv = &file_csv;
>
> proc export data = &out_tbl
>      outfile = &file_csv
>      dbms = csv
>      replace;run;
>
> NOTE: Numeric values have been converted to character values at the
> places given by: (Line):(Column).
>       -47E5:***   -47E5:***
> NOTE: The file 'c:\fees\all_detail.csv' is:
>       File Name=c:\fees\all_detail.csv,
>       RECFM=V,LRECL=32767