Sorting Datastream/Bloomberg data

[Yazeed_10]

Hi SAS users,

I have uploaded data from Bloomberg and the data is sorted in a columns as follow

Date	Company-A	Company-B	Company-C
date-1	Returns-A-1	Returns-B-1	Returns-C-1
Date-2	Returns-A-2	Returns-B-2	Returns-C-2
Date-3	Returns-A-3	Returns-B-3	Returns-C-3

I would like to sort the data this way

Data	ComanyName	Returns
Date-1	Company-A	Returns-A-1
Date-1	Company-B	Returns-B-1
Date-1	Company-C	Returns-C-1
Date-2	Company-A	Returns-A-2
Date-2	Company-B	Returns-B-2
Date-2	Company-C	Returns-C-2
Date-3	Company-A	Returns-A-3
Date-3	Company-B	Returns-B-3
Date-3	Company-C	Returns-C-3

I have attached a sample of the dataset.

Many thanks for your help.

[Kurt_Bremser]

Do a proc transpose by date with var company:

For code fitting a dataset, please post that dataset in the form of a data step; see my footnotes for help.

[Yazeed_10]

Thank you for replaying 

[RW9 · Accepted solution]

Not tested, post test data in the form of a datastep!

So untested but:

proc transpose data=have out=want;
  by date;
  var company:;
run;

[Yazeed_10]

Thank you very much for the solution, it works. 

[Martin2018]

Hi All,

could someone advise me please,

my question is:

Can we download the Tobin's Q for the Australian listed firm from Bloomberg Terminal?

my question means,

Is Bloomberg provide Tobin's Q information for Australian listed firms? and if so, can we download it if we have the Bloomberg Terminal

[Kurt_Bremser]

You should check this with Bloomberg.

For SAS-related questions, please open your own new thread. Do not hijack other people's question threads.

---

@Martin2018 wrote:

Hi All,

could someone advise me please,

my question is:

Can we download the Tobin's Q for the Australian listed firm from Bloomberg Terminal?

my question means,

Is Bloomberg provide Tobin's Q information for Australian listed firms? and if so, can we download it if we have the Bloomberg Terminal

---

[Martin2018]

---

@Kurt_Bremser wrote:

You should check this with Bloomberg.

For SAS-related questions, please open your own new thread. Do not hijack other people's question threads.

---

@Martin2018 wrote:

Hi All,

could someone advise me please,

my question is:

Can we download the Tobin's Q for the Australian listed firm from Bloomberg Terminal?

my question means,

Is Bloomberg provide Tobin's Q information for Australian listed firms? and if so, can we download it if we have the Bloomberg Terminal

---

---

The reason for my question is just to see if anyone has download this before or not?

it is clear that i need to ask them,