cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MCandun
‎10-05-2022
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Transposing

by Calcite | Level 5 in New SAS User
‎10-05-2022 05:56 PM
‎10-05-2022 05:56 PM
Hi, thanks for your reply! I am looking to create a a dataset that will be merged (with 2 other datasets) by ID to create a complete line list for each case (ID). There are several outcomes possible and each entry (i.e., Outcome1 to Outcome8) could be any one of the outcomes. ... View more

Transposing long to wide

by Calcite | Level 5 in New SAS User
‎10-05-2022 05:30 PM
‎10-05-2022 05:30 PM
I'm using SAS-EG (version: 7.15 HF3 7.100.5.6132) and have imported my data (from an excel file). The data I have looks like this: ID Intake_Date Closed_Date Outcome Result Outcome_time_spent Case Status 110 2022-04-01 2022-05-01 Consult Individual 30 Closed 110 2022-04-01 2022-05-01 Training Complete 45 Closed 120 2022-01-01 2022-04-01 Consult Pending 15 Closed 120 2022-01-01 2022-04-01 SessionA Complete 30 Closed 130 2022-05-01 2022-05-15 Consult Complete 60 Closed 130 2022-05-01 2022-05-15 SessionB Complete 30 Closed   I want to rearrange the data to capture all the info in one line per ID, like this:   ID Intake_Date Closed_Date Outcome Result Outcome_time_spent Outcome2 Result2 Outcome_time_spent2 Case Status 110 2022-04-01 2022-05-01 Consult Individual 30 Training Complete 45 Closed 120 2022-01-01 2022-04-01 Consult Pending 15 SessionA Complete 30 Closed 130 2022-05-01 2022-05-15 Consult Complete 60 SessionB Complete 30 Closed     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-05-2022 11:12 PM
Quick links