topic assigning numberic statemetn to character observation and visa versa in SAS Procedures

assigning numberic statemetn to character observation and visa versa

deleted_user — Wed, 01 Apr 2009 19:54:14 GMT

when using the if then statements, can you assign a character statemetn to a numberic variable adn visa versa?

Re: assigning numberic statemetn to character observation and visa versa

deleted_user — Wed, 01 Apr 2009 20:08:10 GMT

why would you want to do that?

Re: assigning numberic statemetn to character observation and visa versa

deleted_user — Thu, 02 Apr 2009 00:31:34 GMT

this will make it easier to check the data once it has been run and make it easier to read for example i was trying to do this if age >= 1 and age < 4 then agegroup = toddler, but it didn't work.

Re: assigning numberic statemetn to character observation and visa versa

Cynthia_sas — Thu, 02 Apr 2009 02:21:17 GMT

Hi:
You have a good idea. The way I would describe what you want to do is: create a new character variable or new category variable based on the VALUE of a numeric variable. Technically, you are not assigning a numeric statement to a character variable or a character value to a numeric variable.

There are 2 ways to do what you want:
1) is to create your own format and then use either the PUT function or INPUT function to create either a character or numeric variable
2) use a series of IF statements to assign a value to either a character or numeric variable.

There are some rules about creating variables. For example:
[pre]
newnumvar = 10; <-- numeric variable being created
newcharvar = 'Wombat'; <--character variable being created

OR

** NUMERIC variable AGECAT being created;
if age gt 0 and age lt 4 then agecat = 1;
else agecat = 2;

OR

** CHARACTER variable AGECAT2 being created;
if age gt 0 and age lt 4 then agecat2 = 'toddler ';
else agecat2 = 'pre-school';

[/pre]

Note that character variables are -usually- assigned quoted strings or assigned the values of other character variables. So when you had something like:
agegroup = toddler

SAS thought that toddler was a variable and you wanted to assign the value of the toddler variable to the new variable agegroup.

You might want to look in the documentation for the section about variables and how to create them and how to use them.

cynthia

Re: assigning numberic statemetn to character observation and visa versa

deleted_user — Thu, 02 Apr 2009 19:51:19 GMT

thankyou for the information. I will run it and see how it comes out.