worked for me! Thanks! ... View more

Thanks so much for this:     data want; set want; char_account_number = put(account_number, $15.) ; drop account_number ; rename char_account_number=account_number ; run;     I'm sure that there are other ways to accomplish this, but this certainly worked for me.  I am posting SAS data to a SQL server and SAS likes to push dates as numeric.  I've tried various versions of the PUT statement, FORMAT, etc.  But this did it.  Thanks again. ... View more

Drop statement will only be effect when outputing, and being one of the 'declarative', it doesn't matter where you put it. Drop= option will be effect on the data set where it attaches, so it is the inputing data set, then it won't show up in your log, unless you have it assigned again, which is btw in your case. ... View more

Hi Astounding, Thank you very much for your code. It worked well. Regards Mirisa ... View more

Thanks again stat@sas for this knowledge. Mirisa ... View more

data want;      set have;      format month z2.; run; ... View more

Hi Reeza, Thank you very much for this information which is very helpful. Regards Mirisa ... View more

Hi Ahmed, Thank you for your help. Miris ... View more

Thank you very much everyone. Hi Dalveer and RW9, Your examples were very helpful. Regards Mirisa ... View more

Hi DBailey, Thank you very much for your suggestion which worked well. Regards Mirisa ... View more

Hi Art and RW9, Many thanks to both of you. Regards Mirisa ... View more

Hi SASKiwi and LinusH, Many thanks to both of you. Regards Mirisa ... View more