BookmarkSubscribeRSS Feed
Inp
Obsidian | Level 7 Inp
Obsidian | Level 7
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
4 REPLIES 4
PatrickG
SAS Employee
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?
Inp
Obsidian | Level 7 Inp
Obsidian | Level 7
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;
LinusH
Tourmaline | Level 20
This documentation might shed some light over your problem:

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

/Linus
Data never sleeps
Flip
Fluorite | Level 6
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 684 views
  • 0 likes
  • 4 in conversation