topic Copying numerical data between observations in SAS Programming

Copying numerical data between observations

ebowen — Fri, 10 Jan 2014 20:15:32 GMT

I have a dataset sorted by three variables, and I'm trying to copy another variable from the previous observation within each grouping conditional on whether the variable has a value or not. So far, here's the code that I have:

DATA test3;

length V1 8;

Set FuelCost11;

By PlantID PMStd Fuel;

Retain V1;

if first.Fuel then V1 = .;

if HeatRate ^=. then V1 = HeatRate;

HeatRate = V1;

Run;

When I run this code, I get the following error:

"ERROR: Variable V1 has been defined as both character and numeric."

I don't know why this would happen, since I'm defining the variable V1 as a numerical variable in the first statement of the data step. The variable V1 doesn't exist prior to this data step. I've run this same code with a character variable (after defining V1 as $5), and it works perfectly. Thanks in advance for any help you can provide.

Re: Copying numerical data between observations

Reeza — Fri, 10 Jan 2014 20:21:24 GMT

What variable type is HeatRate? Your missing a period after the eight in the length statement, not sure if thats an issue as well.

Can you post proc contents results on FuelCost11?

Re: Copying numerical data between observations

ebowen — Fri, 10 Jan 2014 20:40:40 GMT

It turns out I had defined V1 previously as a character variable. After fixing that, the code works great. Sorry for the mix-up.

Re: Copying numerical data between observations

data_null__ — Fri, 10 Jan 2014 21:39:03 GMT

Why would you need a period after 8 in the length statement.

Re: Copying numerical data between observations

Reeza — Fri, 10 Jan 2014 22:33:29 GMT

I realized that and deleted it...but the forums are having issues today...or maybe I am.