topic Convert summary in column data in SAS Programming

Convert summary in column data

jonatan_velarde — Mon, 31 Aug 2020 15:04:55 GMT

Good day:

i have this data:

data have;

input gender n;

cards;

male 7

female 3;

Gender	n
Male	7
Female	3

What I need is to allocate all 10 individuals shown in the first table into a new one detailed as follows:

ID	Gender
1	Male
2	Female
3	Male
4	Male
5	Female
6	Male
7	Male
8	Female
9	Male
10	Male

The rows can be allocated randomly, it is no need to be in the orther that im presenting it.

Thanks in advance

Re: Convert summary in column data

ballardw — Mon, 31 Aug 2020 15:08:37 GMT

How are we supposed to know that Id 1 is Male and not Female? Or any specific ID and Gender combination.

You are missing some details or data somewhere.

Re: Convert summary in column data

jonatan_velarde — Mon, 31 Aug 2020 15:10:31 GMT

Thanks for the answer:

But is irrelevant if its male of female, this example is just for data simulation

Thanks again

Re: Convert summary in column data

ballardw — Mon, 31 Aug 2020 15:27:12 GMT

@jonatan_velarde wrote:
Thanks for the answer:

But is irrelevant if its male of female, this example is just for data simulation

Thanks again

I beg to differ. You have added a variable from somewhere. We need a rule.

If the spread of ID is not important then why did you go to the work of creating them that way.

It is trivial to get the males first and the females second:

data have;
   input gender $ n;
   do i=1 to n;
      id+1;
      output;
   end;
drop i n;
cards;
male 7
female 3
;

You example strongly implied order had some importance. If not, then the above is one way.

Re: Convert summary in column data

Reeza — Mon, 31 Aug 2020 15:31:54 GMT

data want;
set have;
call streaminit(54);

do i=1 to n;
 x= rand('normal');
output;
end;
run;

proc sort data=want out=want(drop=x);
by x;
run;

Something like above?

Depending on what proc you're using, you may also consider a WEIGHT or FREQ statement.

@jonatan_velarde wrote:

Good day:

i have this data:

data have;

input gender n;

cards;

male 7

female 3;

Gender n

Male 7

Female 3

What I need is to allocate all 10 individuals shown in the first table into a new one detailed as follows:

ID Gender

1 Male

2 Female

3 Male

4 Male

5 Female

6 Male

7 Male

8 Female

9 Male

10 Male

The rows can be allocated randomly, it is no need to be in the orther that im presenting it.

Thanks in advance