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 (December 2010, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 <> 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

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