...hree questions in the survey has two questions that can have multiple options selected, and when I use proc transpose with let option it only captures one of the options. I'm unsure of how to have all t...
...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...
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...
...erial;
/* Array of new variables to accept values */
array val[*] $2 Value1-Value5;
/* Multiple input rows for one output row - need to retain values */
retain Value1-Value5;
if first.id then do;
/* C...
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...
Hi community,
I would like to know how to transposevalues from a table that I have to table that I want as it is described below:
What I have
ID
Marketed
Value1
Valu...
I have this data set that I want to transform so that it's one row per ID. The problem is that there are multiplevalues for the an ID variable.
Here is the data set in question:
data h...
...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...
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...
