DATA Step, Macro, Functions and more

Converting numeric to character

Accepted Solution Solved
Reply
Regular Learner
Posts: 1
Accepted Solution

Converting numeric to character

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,

Proc contents.JPG

 

Thanks.

 

 


Accepted Solutions
Solution
‎03-18-2018 07:39 AM
Super User
Posts: 5,920

Re: Converting numeric to character

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).
Data never sleeps

View solution in original post


All Replies
Solution
‎03-18-2018 07:39 AM
Super User
Posts: 5,920

Re: Converting numeric to character

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).
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 260 views
  • 0 likes
  • 2 in conversation