topic Re: How to create an index of the funded share to population share in SAS Programming

How to create an index of the funded share to population share

Malewar — Fri, 16 Feb 2018 13:09:12 GMT

How to create an index of the funded share to population share

a. How do I create a variable for the ratio of each state’s population to total US population. Consider the variable name "Popshare".

b. How do I create a variable that has the ratio of total funded-amnt by state divided by total funded_amnt across all observations. Consider the variable name "Loanshare"
c. How do I put both of these share variables by state in one dataset, and divide loanshare by popshare.

By Using above datasets I wanted to find following

1. How many states have ratios of > 1

2. Which state has the highest ratio

Regards,

Roshan Malewar

Re: How to create an index of the funded share to population share

PeterClemmensen — Fri, 16 Feb 2018 13:38:40 GMT

Do you have some data to work with? If so post it to get a code answer

Re: How to create an index of the funded share to population share

Astounding — Fri, 16 Feb 2018 14:21:43 GMT

Here's an approach to create the pieces you will need. Presumably you can take care of the data manipulation steps.

proc summary data=have;

class state;

var population funded_amt;

output out=stats (drop=_freq_) sum=state_population state_funded_amt;

run;

data next_step;

if _n_=1 then do;

set stats (where=(_type_=0) rename=(state_population=total_population state_funded_amt=total_funded_amt));

end;

set stats (where=(_type_=1));

drop _type_;

run;

Re: How to create an index of the funded share to population share

Malewar — Fri, 16 Feb 2018 18:58:30 GMT

No actually I don't have any data on my local machine. Apologies for the inconvenience.

Re: How to create an index of the funded share to population share

Malewar — Fri, 16 Feb 2018 19:20:56 GMT

Actually I'm not able to understand the code

proc summary data=have;

class state; -------------> Why We use this

var population funded_amt; ------------> Do we need to create new variable named Population(Getting error that variable Population Not Found)

output out=stats (drop=_freq_) sum=state_population state_funded_amt; ---------> This is difficult for me to understand

run;

Due to this I'm not able to move further. Please do the needful. Waiting for your replay.

Re: How to create an index of the funded share to population share

Astounding — Fri, 16 Feb 2018 21:07:24 GMT

PROC SUMMARY is something that you will use every week. You need to learn it. Here's a link:

http://documentation.sas.com/?docsetId=proc&docsetTarget=p0aq3hsvflztfzn1xa2wt6s35oy6.htm&docsetVersion=9.4&locale=en