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.
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;
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.
Thank you for replaying
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;
Thank you very much for the solution, it works.
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
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
@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,
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.