Hello everyone I have a set of files (more than 60 files) i want to merge the in one table using set ...... ...... etc but the problem are in two variables which are saved as character in some files and as number in other files actually these files are recieved as .csv files and you have to import them in Excel using Data>>>from text and then do the usual steps when exporting to excel and choosing the right format for the variabels... but that was not done correctly for all the files and now when i want to combine them in one file it doesnt work I tried to use this code: MKGchar = put(MKG, f10. -L); drop MKG; rename MKGchar=MKG it does work but the problem is I have a variable which is a long number; in excel it appears like 2,76+14  (because the format is standard) and you can change it to text using "Data >>> text to column" and then the right long number will appear 276001303712181 but when i use this code in sas the variable does converted to text but the number does not come any more even when i export it to excel again. that can be done in excel but takes long time because i have  alot of files and to do this for every file is a very long and hard job is there any way to do this using SAS? (to convert this variable to text and at the same time the right number appear) ... View more