topic Re: Guidance, trying to take the difference of columns to an output table. in SAS Programming

Guidance, trying to take the difference of columns to an output table.

zsmith93 — Thu, 21 Mar 2019 18:03:08 GMT

So my goal is to take two data sets and make an output table in which I take the difference between two fields while also keeping one of the fields from both data sets that correspond to their records.

E.g., import(major, median, ...) and import1(name, region, strtMedian, ...)

data Diff_Acct_Cali;
set work.accounting_major, work.cali_region;
difference = (accounting_major.median - cali_region.startMedian);
keep accounting_major.major cali_region.name difference;
run;

What I'm trying to do is take a record from work.accounting_major and work.cali_region particularly median and startMedian respectively. Save the difference into a new record that has the field major from accounting_major and name from cali_region.

All that gets outputted is a table with a column labeled difference with nothing in it. What am I doing wrong?

Re: Guidance, trying to take the difference of columns to an output table.

PaigeMiller — Thu, 21 Mar 2019 18:28:35 GMT

Since we don't have your data, all we can do is clean up your code. Then it's up to you to get it to work.

set work.accounting_major, work.cali_region;

probably should be

merge work.accounting_major work.cali_region;
by id_variable; /* MAY NOT BE NEEDED, but we don't have your data to know for sure */

Merges are usually needed if you want to do a subtraction of a variable in one data set from a variable in another data set.

Then,

difference = (accounting_major.median - cali_region.startMedian);

is a problem as well, you can't use SQL syntax mixed in with DATA step syntax. You need to use only data step syntax. Most likely you want:

difference = median - startmedian;

but again, I don't have your data.

You might want to work through some beginner examples and view some beginner tutorials on SAS, as these are rather basic errors.

Re: Guidance, trying to take the difference of columns to an output table.

zsmith93 — Thu, 21 Mar 2019 21:02:52 GMT

https://www.kaggle.com/wsj/college-salaries#degrees-that-pay-back.csv

The data sets can be found there. What I'm trying to do is compare the median salary of each major from the degrees-that-pay-back.csv compared to each university in a given region from the salaries-by-region.csv. I'm trying to present this as a bar graph where the y axis is the median salary and the x axis would the universities. Yes I understand this should be very easy but when I run my proc's the process just keeps running indefinitely.

Re: Guidance, trying to take the difference of columns to an output table.

PaigeMiller — Fri, 22 Mar 2019 10:54:06 GMT

@zsmith93 wrote:

https://www.kaggle.com/wsj/college-salaries#degrees-that-pay-back.csv

but when I run my proc's the process just keeps running indefinitely.

Show us your code, or better yet, the LOG (the entire LOG, not just the errors) by pasting the LOG into the window that appears when you click on the {i} icon.