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 (475 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 (457 views)  |   In reply to GS2

PROC TRANSPOSE

--
Paige Miller
0 Likes
Reply

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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
  • 476 views
  • 0 likes
  • 2 in conversation