Hello
Let's say that I want to create a data set based on sas_help.class data set.
The new data set will have only 2 columns: Var_name , Var_Value
What is the way to do it?
I e...
I have a dataset of fund holdings as attached. It is currently in a wide format. I would like to change it to a long format where there is one date column and one number_of_share column. Attached i...
Hello
What are the ways to restructure the data from widetolong structure.
Is it possible to use function VNAME here?
IF we use proc transose then is it essential to perform 2 proc tranpose o...
Hello
With continue to previous post,
I want to create a new data set based on sashelp.class data set .
I want that in new data set will have 2 columns; Var_name ,Var_value.
I want it to be d...
I have created a data set (have) using following code. Code may not work properly. The print shows as table-1 below. I would like to make the dataset wide, so it shows like table-2.
data h...
Hi everyone, I'm new with SAS and I am trying to transpose multiple variable from widetolong, as in the example mention below The A,B,C is the prefix followed by time (year). ID &n...
Hi All,
I have a dataset below that I would like to transpose from widetolong format. I've always struggled with getting proc transpose to do what I envision but thinking that proc transpose c...
I have this wide dataset structure.
data have;
input ID 7. CO2 Methane N2O HFC;
datalines;
1004377 54 28 54 30
1000112 88 40 72 1
;
And I want this long dataset structure.
d...
