Hi All,   I have a requirement to convert a ODM xml file to sas dataset. i have used below method to do that, but the execution time is more as it is  a 25MB file. Is there any way to do it faster.     filename NHL  "/path/ODM.xml"; filename map "/path/odm_map.map";   libname NHL xmlv2 xmlmap=map;   proc copy in=nhl out=work; run;   ODM.xml is a 25 mb file so when i try to copy those datasets present in NHL to work library, it's taking allmost 10 min, is there any way to reduce the execution time.   Thanks& regards, Sandeep Reddy ... View more

Hi All,   I have requirement to find the encoding type of a .xpt file, if i use libname+xport engine i am getting encoding type as"Default" but thats not the actual encoding.   If i use libname+xport engine+proc copy getting the encoding type of sas environment, means irrespective filetype, getting default sas encoding type.(i.e. UTF-8).   Please let me know, is there any way or X commands to find the encoding type. ... View more

Hi All,   I have one .sas7bdat having some variables, one of the variable(LBSTNRLO) format is 13.7, and we have loaded this file to oracle database and extracted it, now same variable(LBSTNRLO) format is now 8. I have compared these two datasets and got mismatch between these files which is expected.   I have removed formats of all the variables and compared it, i can see same value in both files, but having mismatch in compare output.   Even i have given format 13.7 for LBSTNRLO in extracted file and compared it but still it has mismatch. Can you please suggest how can we get a match in compare output.   eg: LBSTNRLO  - 12.100000  - in original file having 13.7 format.      LBSTNRLO  - 12    in extracted file having 8. format.    After i remove the formats in both files i have 12.100000. but still have mismatch.        Thank you. ... View more