topic Variable Day converting numeric to character in SAS Data Management

Variable Day converting numeric to character

jackice — Mon, 31 Oct 2016 16:58:43 GMT

Hi, running Glimmix on Variable "Day" has to be not numeric

I have Variable Day with values from 1,3,5,7,9,11,13 ...24)

Just want SAS University to consider the variable Day as char and not as numeric as it is from the proc import ...

how to do this simply for a dummy please?

Re: Variable Day converting numeric to character

ballardw — Mon, 31 Oct 2016 17:17:36 GMT

Easiest is going to be using a data step or transform to create a new variable.

Data step code would look like:

data want;

set have;

DayText = put(day,best5.);

run;

You don't say what your actual range of DAY is best5 will work for values up to 99999. If you don't need that many characters you could use BEST2. or Best3. or ..

Re: Variable Day converting numeric to character

jackice — Fri, 04 Nov 2016 15:55:21 GMT

Thanks kindly!