topic Re: How can I use SAS to combine my variables to create a completely new variable? in New SAS User

How can I use SAS to combine my variables to create a completely new variable?

SM8 — Mon, 27 Jan 2020 16:34:09 GMT

Hello,

So I have two variables in my dataset, pounds and Ounces. I am trying to combine these variables into a total weight variable.

For example, if an observation has a recorded 8 pounds and a recorded 2 ounces, I want to create this new variable to say 8.2. Is this possible in SAS, and if so, how do I accomplish this?

Re: How can I use SAS to combine my variables to create a completely new variable?

ballardw — Mon, 27 Jan 2020 16:46:14 GMT

@SM8 wrote:

Hello,

So I have two variables in my dataset, pounds and Ounces. I am trying to combine these variables into a total weight variable.

For example, if an observation has a recorded 8 pounds and a recorded 2 ounces, I want to create this new variable to say 8.2. Is this possible in SAS, and if so, how do I accomplish this?

Be very careful of that sort of non-standard representation. If you want a decimal version you would be better off where 2 ounces is represented as 0.125 then you actually have unit for the variable in pounds:

data want;

set have;

newweight = pounds + ounces/16;

run;

Would be the way with a data step to convert ounces to pounds.

You would have to very clearly describe the actual advantage or use of storing the value as 8.2. You couldn't do substraction, such as determining change in weight, or look up with standard tables a value as you propose.

Or perhaps change the whole value to ounces? Newweight = pounds*16 + ounces;

I dealt with some data that was provided in a form similar to what you propose only the "decimal" portion was fourths of a pound. And none of the uses wanted that sort of units so had to be converted to actual pounds before anything could be done.

Re: How can I use SAS to combine my variables to create a completely new variable?

Reeza — Mon, 27 Jan 2020 16:47:04 GMT

Yes it's possible. But do you really want 8.2 as 8 lbs and 2 ounces? Then you're deviating from the standard definition of the decimal value which is problematic.

If you really want that, try CATX().

new_var = catx(".", put(pound, 8. -l), put(ounces, 8. -l));

A better approach is to store everything in one unit, ounces.

weight_ounce_total = pound*16 + ounce;

@SM8 wrote:

Hello,

So I have two variables in my dataset, pounds and Ounces. I am trying to combine these variables into a total weight variable.

For example, if an observation has a recorded 8 pounds and a recorded 2 ounces, I want to create this new variable to say 8.2. Is this possible in SAS, and if so, how do I accomplish this?

Re: How can I use SAS to combine my variables to create a completely new variable?

Patrick — Tue, 28 Jan 2020 04:16:01 GMT

@SM8

I'd convert this data asap into a metric unit (kg) stored in a single variable to allow for any sort of calculation and aggregation.

If you must print pounds and ounces in reports then consider creating a format for it (you'd likely would need Proc FCMP and then create a format which calls the function).