How to format a table while combining two variables

NewUsrStat — Fri, 23 Feb 2024 13:22:15 GMT

Hi guys,

suppose to have the following:

data have;
input Id response $ qualification $;
cards;
1 temperature Professor
1 disfunction Professor
1 comorbidities Professor
2 comorbidities Psichol
2 flu Psichol
33 temperature Doctor
44 behavior Psy
44 temperature Psy
44 flu Psy
5 flu oss
5 temperature oss
5 disfunction oss
5 behavior oss
;;;;
run;

Is there a way to format the table in this way?

Desired table:

Id	temperature	disfunction	comorbidities	flu	behavior
1	Professor	Professor	Professor	not_selected	not_selected
2	not_selected	not_selected	Psicholog	Psicholog	not_selected
33	Doctor	not_selected	not_selected	not_selected	not_selected
44	psy	not_selected	not_selected	psy	psy
5	oss	oss	not_selected	oss	oss

Thank you in advance

Re: How to format a table while combining two variables

Kurt_Bremser — Fri, 23 Feb 2024 13:55:01 GMT

proc report data=have;
column id response,qualification n;
define id / group;
define response / "" across;
define qualification / "" display;
define n / "" noprint;
run;

topic How to format a table while combining two variables in New SAS User

How to format a table while combining two variables

Re: How to format a table while combining two variables