Thank you guys.   The reason i started this thread was because i saw this thread here: https://communities.sas.com/t5/SAS-Programming/How-to-import-dbf-file-into-sas/td-p/561827   i was having same issue as the poster of that thread where the error kept saying "non-supported file is specified". Of course i can do a workaround and convert my foxpro dbf file into csv and import it. But i believe in the power of SAS and there should be a solution.   Some of the comments there mentioned about the license part. Which led me want to check if the license when bought, if they were given partially or full based on some sales agreement. Since as mentioned that license would be given as full, i went on digging further and found a solution.   The solution was to put dbms=dbfmemo in the proc import statement. PROC IMPORT OUT=WORK.TEST DATAFILE='orders.dbf' DBMS=DBFMEMO REPLACE; RUN; Thank you!   ... View more

Thanks Josvander,   I have this when i run proc setinit  ---SAS/ACCESS Interface to PC Files   and i get this when i run proc product_status For SAS/ACCESS Interface to PC Files ... Custom version information: 9.4_M7   My problem is that when i try to proc import a dbf file it says ---->non-supported file is specified So i am wondering whether my license was customised? But if as you highlighted, i should have full license then i should be able to proc import dbf file.  I have also tried proc dbf but not able to do so because my dbf was not db=2, db=3, db=4, db=5 .   ... View more

Hi I had my hands full with the team I got. Let's connect. ... View more

Thanks for your reply.   I chose a different column for the ID columns of the transpose transform, it worked. I supposed the original column i wanted to transpose must have some issues, so transpose wasn't allowed. I didn't have time right now to figure out what was the cause. I am able to transpose now so i am happy as i am chasing time.    It might be the original column had too many characters or other characters such as: (.) , (-)  ... View more