topic Convert data set from summary to full data in SAS Programming

Convert data set from summary to full data

jonatan_velarde — Tue, 23 Mar 2021 20:59:01 GMT

HI friends:

I have this data set:

data have;

input Questions sex yes no;

cards;

Question_1 male 2 5

Question_2 male 3 4

Question_3 male 5 1

;

and i have to obtain this table:

Question	Sex	yes_no
1	male	1
1	male	1
1	male	0
1	male	0
1	male	0
1	male	0
1	male	0
2	male	1
2	male	1
2	male	1
2	male	0
2	male	0
2	male	0
2	male	0
3	male	1
3	male	1
3	male	1
3	male	1
3	male	1
3	male	0

need to be notice that 0 means NO and 1 means YES, from the origin dataset

Thanks in advance

Re: Convert data set from summary to full data

Reeza — Tue, 23 Mar 2021 21:14:58 GMT

data want;
set have;

Question = input(compress(questions, , 'kd'), 8.);

do i=1 to yes;
yes_no=1;
output;
end;

do i=1 to no;
yes_no=0;
output;
end;

run;

Re: Convert data set from summary to full data

ballardw — Tue, 23 Mar 2021 22:30:19 GMT

Be aware that you cannot do any meaningful analysis of combinations of the questions such as "males that answered yes to questions 1 and 2" with data from a summary like this..