BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Yazeed_10
Calcite | Level 5

Hi SAS users,

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

 

DateCompany-ACompany-BCompany-C
date-1Returns-A-1Returns-B-1Returns-C-1
Date-2Returns-A-2Returns-B-2Returns-C-2
Date-3Returns-A-3Returns-B-3Returns-C-3

 

I would like to sort the data this way

 

DataComanyNameReturns
Date-1Company-AReturns-A-1
Date-1Company-BReturns-B-1
Date-1Company-CReturns-C-1
Date-2Company-AReturns-A-2
Date-2Company-BReturns-B-2
Date-2Company-CReturns-C-2
Date-3Company-AReturns-A-3
Date-3Company-BReturns-B-3
Date-3Company-CReturns-C-3

 

 

I have attached a sample of the dataset.

 

Many thanks for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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;

View solution in original post

7 REPLIES 7
Kurt_Bremser
Super User

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
Calcite | Level 5

Thank you for replaying 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Calcite | Level 5

Thank you very much for the solution, it works. 

Martin2018
Calcite | Level 5

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
Super User

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
Calcite | Level 5

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 776 views
  • 1 like
  • 4 in conversation