Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
287 results
Sorted by:
03-20-2023
10:21 PM
...olumns, values in rows) to a long one (variable name in one column, values as columns per year and sequence). It works very well when values are unique, but failed for some datasets as there are multiple o...
12-13-2019
08:37 PM
I am attempting to combine multiple account records with multiple variables into one observation with the TRANSPOSE procedure but I keep getting the following error:
ERROR: The ID1 valu...
03-11-2024
12:15 PM
Hello,
I am trying to transpose my dataset from long to wide, but I keep getting errors due to reoccurring ID values.
Context: it is survey data taken over 5-year period so there are multiple...
11-11-2018
02:43 PM
Hi all, I have a dataset that looks like this. I want to transpose it with the SBP_FU values for each month as the variables by ID, but also retain the first and last followup dates. I was able to d...
01-23-2022
07:01 PM
3 Likes
...ontains the values that shall be transposed.
The output data (only 3 dogs are shown) looks as follows:
Dog
ID Drug Depleted _NAME_ histamine0 h...
03-10-2017
12:50 AM
...000 2000 3000 4000 1000 However, if I write the following program I get values of different columns in different rows. proc transpose data=Y out=check ; id ID; var d a...
08-23-2022
10:26 AM
I have this data set that I want to transform so that it's one row per ID. The problem is that there are multiple values for the an ID variable.
Here is the data set in question:
data h...
07-30-2021
04:28 PM
Hi community,
I would like to know how to transpose values from a table that I have to table that I want as it is described below:
What I have
ID
Marketed
Value1
Valu...
02-19-2020
11:32 AM
Hi all, this may sound incompetent but I would like to explore the possibilities to proc transpose columns with different values into correspond columns. Let's say I have a d...
04-15-2017
04:35 AM
...ut with all the paid and cost values in it as well. Is this achievable? Understand that using proc transpose might not work and have been playing around by using arrays but have been u...