Adding to the fine advice from others: it doesn't matter where the values come from, database or Excel or otherwise. It matters what the values are in your SAS data set. And to make the proper decision about how to program this, as demonstrated above, you MUST know if in SAS these variables are numeric or text (also called "character"), and in many cases, you also MUST know what the format of the SAS variable in the SAS data set is.   Although you @kalyan11 have been asked several times to tell us this, you haven't given us this information, and you absolutely will need this to program the conversion properly.   You can find this information by running PROC CONTENTS on your SAS data set. Here is an example of running PROC CONTENTS on a different data set:   proc contents data=sashelp.cars; run;   As you can see, there is a variable named Cylinders which is numeric, and variable named DriveTrain which is Character. Variable named INVOICE has a format assigned to it. ... View more