Hi Patrick, Sorry. let me clarify. I didnt get customer to go to SAS tech. I took your advice to reach out to them to further resolve the whatever issue as we managed to conclude using the code you gave me to find pd and pd_char and confirm it is odbc and not my data issue. So I told them I proved by those code and request to look into it.   Sorry please dont get upset. I really appreciate your help. OK I will work with them further. Thanks a milion ... View more

I have now reached out to SAS technical they are asking why is it that the pd_char has the cast function whereas the pd does not?   please kindly let me know thanks,     ... View more

how can I check the metadata definition of the table? I always thought we dont setup schema or metatable for sas tables? ... View more

yes it is working   pls see pic showing result ... View more

connect in the second line show up in red, does that means my user'sas sas do not have this function? ... View more

yes I only pass to user to execute no particular sas admin in this place may be they think I am now Thank you Patrick for your kind support!   ... View more

this is how the data shows up on SAS enterprise guide  ... View more

oh I checked with user, actually they dont need to use any sas code, it is already saved in a library available the strange thing is I have over 30 files and only this one field from 2 files has precison issue   ... View more

Hi Patrick,   Thank you very much for your help. I was not able to follow your method where you provide below as I dont know what to put after ODBC libname yourlib ODBC .....; proc contents data=yourlib.<table name>(keep=<varname under investigation>); run; What my user did was just saved the files to a newly created library and proc content from there. Every entries show only 2 decimal places. I have checked all the platforms before the files reach SAS all were able to display 4decimal places. That is why I think it is to do with ODBC set up or SAS setup.   ... View more

tries 1 shows 2 decimal places only   ... View more

I mean we created it as decimal(8,4) in db2 then sent as text with same decimal places which is then uploaded to another platform which is also showing 4 decimal places and then it again got to sent to another platform which is also showing 4 decimal places all the way is correct until it reach SAS after ODBC   so I need to know if there is any setting in ODBC that rearrange it to 2 decimal places as it is showing 21.2 for format and informat as shown in proc content     ... View more

Request the DDL (table definition) from the Sybase DBA --- what do you mean by this? this DDL is in SAS, relates to SAS?  or you mean from DB2 where pd was created? PD is defined as (8,4) in DB2   and also all the subsequent platform the files go through has capabilities to show 3 decimal places ... View more

pd is a between 0 and 1 it is basically equals total bad count/total active count e.g. 4/10 so 0.4 so it will never be 20 as we kept decimal place to 4 only in all the sources     ... View more

4 d.p. mean I need output in 4 decimal place   all input before SAS (from DB2 to text file in a platform to another big data platform) are all showing 4 decimal place but SAS is showing 2 decimal place only. I need to confirm if there are settings somewhere in SAS that has change it to 2 decimal places.   I attached proc content for your reference it is highlighted in yellow the variable PD what governs the output format in sas via odbc? the informat show here ? was there schema somewhere already setup somewhere?     ... View more

actually the people who set up the odbc confirmed they can show 4d.p. and ask me to check sas setting. what kind of setting does he mean, where do we have prior format setting in SAS? ... View more