topic Re: IF/Then Statement tying multiple rows together in SAS Forecasting and Econometrics

IF/Then Statement tying multiple rows together

Tglass55 — Mon, 21 Jul 2014 00:49:35 GMT

Here is the basic idea:

1	2	3	Goal
Person 1	Household 1	Wages - 10	Household 1 Wages - 20
Person 2	Household 2	Wages - 10	Household 2 Wages - 10
Person 3	Household 1	Wages - 10	Household 1 Wages - 20

I'm trying to write an If/then statement that would search throughout all of column 2 to find similar household #'s and then find the sum and put them in the "goal column."

Would appreciate your help!

Re: IF/Then Statement tying multiple rows together

Patrick — Mon, 21 Jul 2014 01:36:48 GMT

The data you show us are all strings but you want to use the digits of column '3' as numeric values and sum them up. Not sure if your real data looks as posted or if this is already formatted data.

It would help in the future if you could post a proper SAS data step which creates sample data together with a description of how the expected result should look like. This way you're taking out the guess-work for us and you also have a better chance to get an answer which fits your actual data.

Below some code which deals with the data as posted.

data have;

infile datalines truncover dlm=',' dsd;

input (person household wages) (:$20.);

datalines;

Person 1,Household 1,Wages - 10

Person 2,Household 2,Wages - 10

Person 3,Household 1,Wages - 10

;

run;

proc sql;

create table want as

select

person,

household,

wages,

catx(' ',household,'Wages',sum(input(scan(wages,-1,' -'),? best16.))) as goal length=40

from have

group by household

order by person

;

quit;

Re: IF/Then Statement tying multiple rows together

Tglass55 — Sun, 27 Jul 2014 22:20:26 GMT

Sorry, let me try to be more specific. in a different question.