topic Re: Trying to Transpose Multiple Variables Long to Wide in SAS Programming

Trying to Transpose Multiple Variables Long to Wide

skatethejake — Tue, 25 Aug 2020 19:08:42 GMT

Hello All,

I am trying to transpose some stock data that I generated in R. There are two entries for one stock symbol, I will attach the photo so that you may be able to understand better what I am saying. All I want is one row, not two, for each stock symbol.

I have tried this

proc transpose data=pa.regression_stats out=pa.transposed_data;
	by Var;
	var estimate p_value statistic std_error;
run;

But it does the exact opposite of what I want, converting it into four rows instead of two

Re: Trying to Transpose Multiple Variables Long to Wide

Reeza — Tue, 25 Aug 2020 19:12:36 GMT

A merge is probably easier for this one IMO.

data want;
merge have (where=( term = '(Intercept)'))
           have (where=( term = 'VFINX') rename = (estimate = vfinx_est std_error = vfinx_std_error statistic = vfinx_stat));
by Var;
run;

@skatethejake wrote:

Hello All,

I am trying to transpose some stock data that I generated in R. There are two entries for one stock symbol, I will attach the photo so that you may be able to understand better what I am saying. All I want is one row, not two, for each stock symbol.

I have tried this
proc transpose data=pa.regression_stats out=pa.transposed_data;
	by Var;
	var estimate p_value statistic std_error;
run;
But it does the exact opposite of what I want, converting it into four rows instead of two

Re: Trying to Transpose Multiple Variables Long to Wide

skatethejake — Tue, 25 Aug 2020 19:35:30 GMT

What does the have represent? Is that just a keyword? Do I have set this data to my previous data?

Re: Trying to Transpose Multiple Variables Long to Wide

Reeza — Wed, 26 Aug 2020 19:23:54 GMT

Have represents your input data set. Replace it with your data set name.