topic Re: changing numeric to character in SAS Programming

changing numeric to character

uttara_96 — Mon, 11 Sep 2017 20:53:45 GMT

I have a code with a data set with a variable titled average with the average housing prices by month since 1975. These observations are in char format and need to be converted to numerics. The code is below:

data mortdata.housingproces; set mortdata.house_price;

AVG = input(average, Best5.);

run;

This isn't working, and I'd like to know why. The output that I keep getting is just "." for all the rows.

Thank you for your help in advance!

Re: changing numeric to character

Reeza — Mon, 11 Sep 2017 21:09:26 GMT

BEST5 seems low for house prices, have you tried BEST12?

Post your log as well please.

Re: changing numeric to character

uttara_96 — Mon, 11 Sep 2017 21:42:10 GMT

I tried BEST12, but the output was the same.

Re: changing numeric to character

Reeza — Mon, 11 Sep 2017 21:48:09 GMT

Post your code and log.

Re: changing numeric to character

ballardw — Mon, 11 Sep 2017 22:03:17 GMT

Does you text value have commas? Show some example values, what you are currently getting for results and what you expect.

Re: changing numeric to character

uttara_96 — Mon, 11 Sep 2017 22:17:36 GMT

My text values had commas in them, and I removed them right now. The results are now populating. Thank you so much for y'all's help!

Re: changing numeric to character

Reeza — Mon, 11 Sep 2017 22:22:24 GMT

The informat represents the format your data was in.

So it should have been something like:

input(average, comma12.);

Re: changing numeric to character

ShiroAmada — Tue, 12 Sep 2017 01:44:48 GMT

data mortdata.housingproces; set mortdata.house_price;

AVG = average+0;

run;

Re: changing numeric to character

Reeza — Tue, 12 Sep 2017 02:03:53 GMT

@ShiroAmada wrote:

data mortdata.housingproces; set mortdata.house_price;

AVG = average+0;

run;

Implicit conversion isn't a great idea in the long run. It will leave notes in the log and make it hard to distinguish actual errors, if they crop up later on.