topic Re: Sorting Datastream/Bloomberg data in SAS Programming

Sorting Datastream/Bloomberg data

Yazeed_10 — Fri, 08 Jun 2018 08:24:15 GMT

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.

Re: Sorting Datastream/Bloomberg data

Kurt_Bremser — Fri, 08 Jun 2018 08:36:12 GMT

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.

Re: Sorting Datastream/Bloomberg data

RW9 — Fri, 08 Jun 2018 08:39:23 GMT

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;

Re: Sorting Datastream/Bloomberg data

Yazeed_10 — Fri, 08 Jun 2018 12:15:40 GMT

Thank you for replaying

Re: Sorting Datastream/Bloomberg data

Yazeed_10 — Fri, 08 Jun 2018 12:17:40 GMT

Thank you very much for the solution, it works.

Re: Sorting Datastream/Bloomberg data

Martin2018 — Thu, 16 Aug 2018 05:37:20 GMT

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

Re: Sorting Datastream/Bloomberg data

Kurt_Bremser — Thu, 16 Aug 2018 06:49:50 GMT

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

Re: Sorting Datastream/Bloomberg data

Martin2018 — Thu, 16 Aug 2018 06:56:56 GMT

@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,