topic Create the Same Count for Multiple Columns in SAS Programming

Create the Same Count for Multiple Columns

skatethejake — Tue, 11 Aug 2020 20:58:35 GMT

Hello,

I have this data that I want to transpose.

The data looks like this

Name

Jake

Sophomore

Name

Abigail

Senior

Name

Ronny

Freshman

I have been trying to create a count where it will display a unique identifier for each group of info like this

Name 1

Jake 1

Sophomore 1

Name 2

Abigail 2

Senior 2

Name 3

Ronny 3

Freshman 3

I can only seem to create a count that starts over when the name row appears, hence it goes 1,2,3 instead of 1,1,1 for each group of data. Any help would be much appreciated

Re: Create the Same Count for Multiple Columns

PaigeMiller — Tue, 11 Aug 2020 21:00:31 GMT

Why do you want to transpose this?

data want;
    set have;
    if string='Name' then count+1;
run;

Re: Create the Same Count for Multiple Columns

skatethejake — Tue, 11 Aug 2020 21:11:33 GMT

I'm an idiot lol, thank you so much. I really appreciate this.