Converting numeric to character

maggi — Sun, 18 Mar 2018 09:29:30 GMT

Hello,

I want to convert 2 numeric variables (DemAffl & DemAge) from an existing data set to character variables on a new data set. I tried to use the informat statement:

data sasuser.newset; 
set sasuser.organics(obs=20000);
informat ID $10. DemAffl $10. DemAge $8. DemCluster $2. DemClusterGroup $1. DemGender $1. DemReg $10. 
DemTVReg $12. PromClass $8. PromSpend 8.2 PromTime 8. TargetAmt 8. TargetBuy 8.;
run;

But it is not working & the log shows the following:

WARNING: Variable DemAffl has already been defined as numeric.
WARNING: Variable DemAge has already been defined as numeric.

Attaching the proc contents output below for reference,

Thanks.

Re: Converting numeric to character

LinusH — Sun, 18 Mar 2018 10:13:37 GMT

Informat statement does not convert anything. It adds metadata to the variables listed.
Use the PUT function to create character variables (And INPUT function to create numerical ones).

topic Converting numeric to character in SAS Programming

Converting numeric to character

Re: Converting numeric to character