topic Re: what is the wrong with this data step? Please help me in SAS Programming

what is the wrong with this data step? Please help me

Inp — Wed, 21 Jan 2009 17:22:54 GMT

Hi

The field and the associated vaule in the flat file is follows

ORIGINALFACEVALUE
=================
52.92
52.92

I am reading it as @366 ORIGINALFACEVALUE 17.2

The field and value in the xls file are as follows
ORIGINALFACEVALUE
52.92
52.92

After I import the xls file into to SAS database then I compare using Proc compare to the sas database which I created from the flat file, I see the following results.

|| ORIGINALFACEVALUE
|| BASE COMPARE
OBS || ORIGINALF ORIGINALF DIFF. % DIFF
|| ACEVALUE ACEVALUE
________ || _________ _________ _________ _________
||
1 || 52.9200 52.9200 3.553E-15 6.713E-15
2 || 52.9200 52.9200 3.553E-15 6.713E-15

This is one example, I have more like this. Can anyone please explain me why this difference?

Thank you so much in advance.

Thanks

Inp

Re: what is the wrong with this data step? Please help me

PatrickG — Wed, 21 Jan 2009 19:31:21 GMT

I'm not sure we can tell from what you've posted just what you're trying to do (or how). Can you post your data step and/or your proc compare?

Re: what is the wrong with this data step? Please help me

Inp — Wed, 21 Jan 2009 20:13:12 GMT

Thanks Patrick,
I can explain simply this, because the process is little complicated. All I am importing a very huge excell file in to SAS database and then ftp to mainframe. Also I have same information on the mainfram flat file Now I read flat file and cretated SAS database. Now I am testing by comparing those databases for testing

Here is compring step

PROC COMPARE BASE=NEWDB COMPARE=OLDDB
LISTBASEVAR LISTCOMPVAR;
TITLE1 " MEMBER: - DATA";
RUN;

when I read the flat file from the maifram the data step is as follows

DATA REDEEM1;
INFILE REDINCOM MISSOVER FIRSTOBS=3;
@366 ORIGINALFACEVALUE 17.2 ;

RUN;

DATA REDEMDB.REDEEM;
SET REDEEM1;
RUN;

Re: what is the wrong with this data step? Please help me

LinusH — Wed, 21 Jan 2009 20:53:19 GMT

This documentation might shed some light over your problem:

http://support.sas.com/documentation/cdl/en/lrcon/59522/HTML/default/a000695157.htm

/Linus

Re: what is the wrong with this data step? Please help me

Flip — Wed, 21 Jan 2009 20:54:44 GMT

This is due to the difference in storage bits on the 2 platforms. This is a common problem when migrating numeric data. Just round your data to 14 decimals after loading to the mainframe and the problem goes away.

Flip