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: 
inquisitive_man
‎11-10-2016
  • 3 Posts
  • 3 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Create single records from multiple rows

by Fluorite | Level 6 in SAS Programming
‎08-19-2015 01:54 PM
‎08-19-2015 01:54 PM
Thank you for your post and link to the article. It offered great insight on multiple topics. Ultimately I understand the article better than your proc summary above. Thank you again! ... View more

Re: Create single records from multiple rows

by Fluorite | Level 6 in SAS Programming
‎08-19-2015 01:53 PM
‎08-19-2015 01:53 PM
@Tom Thank you for the prompt feedback. Your method works perfectly but in order to name the variables appropriately all within a singular step the method outlined by @xia keshan works best for my usage. Thanks again for the insight! ... View more

Create single records from multiple rows

by Fluorite | Level 6 in SAS Programming
‎08-17-2015 04:56 PM
1 Like
‎08-17-2015 04:56 PM
1 Like
Say I have a SAS dataset created by the following: data try;      input ID $ q1 $ q2 $;     datalines;      A R1 smart      A R3 queue      B R3 queue      C R1 smart      C R4 dumb      C R5 okay ; run; quit; Now I want to create a new dataset with the following structure (where I have each ID letter on a row and all its data): A     R1     smart     R3     queue B     R3     queue C     R1     smart     R4     dumb     R5     okay I am fairly new to SAS and was looking for a quick easy to understand way in how to do this. Anybody out there that can help ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-10-2016 11:22 PM
Likes given to
View All
Likes from
View All
Quick links