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: 
BookmarkSubscribeRSS Feed
GS2
Obsidian | Level 7 GS2
Obsidian | Level 7

Rename all columns in table at once

Posted 02-24-2020 12:12 PM (527 views)

Using SAS 9.4

 

I have a data set that has multiple time points per person and each time point is a separate row and I would like to create a wide data set from this (i.e. all time points on 1 row for each person) so I can compare the dates. Is there an efficient to rename all variables in a data set to include "_1", "_2" etc. at the end of each variable? Thank you 

0 Likes
Reply
1 REPLY 1
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Rename all columns in table at once

Posted 02-24-2020 12:29 PM (509 views)  |   In reply to GS2

PROC TRANSPOSE

--
Paige Miller
0 Likes
Reply

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Watch Mastering the WHERE Clause in PROC SQL on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎02-24-2020 12:12 PM
  • 528 views
  • 0 likes
  • 2 in conversation