Hi Kurt, the 2 lines have the same hex value which is exactly the problem. Two different values are treated as the same. A value with and without space should have than a different hex value which is not the case. Also when I run a query builder and select distinct rows I get 1 row.   The problem is that I receive from a supplier this value as a primary key. I think it cannot be solved by SAS because of the padding. I should ask the supplier not to accept ending spaces in primary keys. ... View more

Hi thx for your quick response. I added the DLM (without the import was also working). The value B4595 is 6 long (with the space). You can see there is a space in the CSV file. After the import the space is removed in the Work.test table.   I attached the file and I use the following code:   DATA WORK.TEST; LENGTH Fieldname $ 10 Fieldname_2 $ 10; FORMAT Fieldname $CHAR10. Fieldname_2 $CHAR10.; INFORMAT Fieldname $CHAR10. Fieldname_2 $CHAR10.; INFILE '/opt/sas/data/testfile.csv' LRECL=500 MISSOVER DLM=',' firstobs=2 DSD; INPUT Fieldname : $CHAR10. Fieldname_2 : $CHAR10.; RUN; ... View more