Creating a New Column for Count

cassylovescats — Thu, 21 Nov 2019 22:38:45 GMT

Hello,

I am creating a code to view the district position and soil type. I wanted to create a count for the soil type so instead of the data being like this:

DistrictPosition SoilID SoilName

S 838 Prior

N 802 Liverpool

N 803 Brosnan

To this: I need to remove soilname, I am running a dataset with 3775 lines but condensed it to just the 5.

DistrictPosition SoilID Count

S 838 1

N 802 3

N 803 1

Hopefully this is possible,

I appreciate the help!

Re: Creating a New Column for Count

novinosrin — Thu, 21 Nov 2019 22:49:45 GMT

proc sql;

select DistrictPosition ,SoilID , n(SoilName) as count

from your_data

group by DistrictPosition ,SoilID;

quit;

Re: Creating a New Column for Count

cassylovescats — Thu, 21 Nov 2019 22:53:42 GMT

Thank you! It is extremely appreciated! This is for a final presentation for school.

topic Re: Creating a New Column for Count in New SAS User

Creating a New Column for Count

Re: Creating a New Column for Count

Re: Creating a New Column for Count