☑ This topic is solved.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 02-23-2024 08:22 AM
(662 views)
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
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
proc report data=have;
column id response,qualification n;
define id / group;
define response / "" across;
define qualification / "" display;
define n / "" noprint;
run;
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
proc report data=have;
column id response,qualification n;
define id / group;
define response / "" across;
define qualification / "" display;
define n / "" noprint;
run;