Many thanks to answer my question.. Let me explain what i did: 1. I have an excel file with multiple sheets. 2. I used user wiritten to generate the excel file in DI using the code. an example:   proc import datafile="/home/coba.xlsx" out=TRS.eir dbms=xlsx replace; sheet="Outstanding EIR"; getnames=yes;   Then, the datasets are created. 3. I made a library then I registered the tables (datasets) into the library. 4. I made a job for mapping the datasets using Data Validation, so that I could get Portfolio Dataset. 5. But the problem is i can't make sure if my client sets the variables types (excel) as general, so sometimes it may be different every month (numeric or character), the type doesn't fix. Then, my partner suggested me to change the all variables types to character (the same way i did to txt file in DI), so it would be easy for me to map the columns without afraid if the data type has changed next month.  My question is : How to change the all variables types to character (before i map the columns)?   NB: Another experiment I've tried to change the variables types one by one to be character by added external file without the code, just import by choosing the dataset (from the sama excel file) in library before as reference table then I got the result like this picture below:         I have no idea to change the all variable types to character.. Is it possible or not? Or maybe you have another suggestion??  Thanks before..  ... View more

Thanks for the code..  But if you don't mind, could you show me a code that used to change the all variable type to be character? ... View more

thanks Mr.Kurt for the suggestion. I will receive the excel file every month and it's not possible to me for saving it in csv file because the excel file will generate automatically.. ... View more