topic Re: Multiplying positive and negative numbers in SAS Programming

Multiplying positive and negative numbers

PDevi — Thu, 30 Sep 2021 04:11:39 GMT

Hi all,

I am struggling to find the product of a negative and a positive number. My data is as below:

Product Year Variable1 Variable2

1 2010 0.234 -12345

1 2011 0.545 -59865

2 2010 0.896 -56896

2 2011 0.568 -13899

I need to multiply variable 1 and variable 2. How do I deal with this? Would appreciate all your help. Thanks in advance.

Re: Multiplying positive and negative numbers

SAS47 — Thu, 30 Sep 2021 05:12:35 GMT

Hi,
You can use assignment statement to multiply the two variables.

Refer to documentation below.
https://documentation.sas.com/doc/en/pgmsascdc/v_014/ds2ref/n1eexsj5t1lpn3n1bflloua85i1p.htm

You can use he code below.

data abc_mult; */creates a temporray data /*
set abc; */Read your data/*
var_prod=Variable1*Variable2; */Assignment Statement to multiply two variables/*
run;

This assignment statement will help you to multiply positive and negative variable as well.

Re: Multiplying positive and negative numbers

PDevi — Thu, 30 Sep 2021 13:05:47 GMT

@SAS47 I was running this exact same code but it is returning only empty values; hence my struggle. 🙂

Re: Multiplying positive and negative numbers

PaigeMiller — Thu, 30 Sep 2021 14:19:27 GMT

@PDevi wrote:
@SAS47 I was running this exact same code but it is returning only empty values; hence my struggle. 🙂

Show us the actual LOG for this data step, all of it, every single line, do not chop out parts of the log for this data step. Also, show us the results.

Re: Multiplying positive and negative numbers

tarheel13 — Thu, 30 Sep 2021 16:01:14 GMT

can you post your data and code?

Re: Multiplying positive and negative numbers

ballardw — Thu, 30 Sep 2021 16:57:07 GMT

@PDevi wrote:
@SAS47 I was running this exact same code but it is returning only empty values; hence my struggle. 🙂

When you read the LOG did you see any "invalid data" messages?

Or "Variable xxxxxx is unitialized"? That typically means you used a variable name with no values. Which happens when you mean to type "height" but misspell such as "hheight" "heght" or such. SAS will in this case 1) create a variable of the wrong name and 2) assign missing values to it and almost any calculation using that misspelled name.

Re: Multiplying positive and negative numbers

PDevi — Fri, 01 Oct 2021 14:44:14 GMT

@ballardw that was exactly the issue. I had made a very stupid mistake, the label and variable names were slightly different and that was causing this whole issue. Feeling very stupid right now. 😞

Thanks for your help and time.

Re: Multiplying positive and negative numbers

PaigeMiller — Fri, 01 Oct 2021 16:07:41 GMT

This is why we always ask to see the log, when the code isn't working right. From now on, please show us the log when the code isn't working, and you will then get faster and better answers.

Also, this is why "Read the Log" has risen to number 2 in the "Maxims of Maximally Efficient SAS Programmers".

Re: Multiplying positive and negative numbers

PDevi — Fri, 01 Oct 2021 17:57:53 GMT

@PaigeMiller I will, thanks Paige. And sorry!