Creating value weighted industry portfolios in SAS? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experience Should we burninate the [wrap] tag?SAS/R calculate distance between two groupsFilling in the months and years in date range?extracting from dataset using another dataset in SASSAS creating subtables ordered by yearcalculate market weighted return using SASAsking SAS to compute calculations based on datesReturn dataset of column sums in SASSAS Regression Output Data StructureCreating portfolios depending on 2 variables with SASCreate variables with years based on the start and end dates
If a contract sometimes uses the wrong name, is it still valid?
What happens to sewage if there is no river near by?
Is a manifold-with-boundary with given interior and non-empty boundary essentially unique?
Doubts about chords
Should I discuss the type of campaign with my players?
Is there a way in Ruby to make just any one out of many keyword arguments required?
Is high blood pressure ever a symptom attributable solely to dehydration?
Is there a concise way to say "all of the X, one of each"?
Should I use Javascript Classes or Apex Classes in Lightning Web Components?
The logistics of corpse disposal
List *all* the tuples!
How do I determine if the rules for a long jump or high jump are applicable for Monks?
3 doors, three guards, one stone
Sorting numerically
Does surprise arrest existing movement?
How do I mention the quality of my school without bragging
Is there a Spanish version of "dot your i's and cross your t's" that includes the letter 'ñ'?
What's the purpose of writing one's academic bio in 3rd person?
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
Why is black pepper both grey and black?
If Jon Snow became King of the Seven Kingdoms what would his regnal number be?
How does cp -a work
Check which numbers satisfy the condition [A*B*C = A! + B! + C!]
Are my PIs rude or am I just being too sensitive?
Creating value weighted industry portfolios in SAS?
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experience
Should we burninate the [wrap] tag?SAS/R calculate distance between two groupsFilling in the months and years in date range?extracting from dataset using another dataset in SASSAS creating subtables ordered by yearcalculate market weighted return using SASAsking SAS to compute calculations based on datesReturn dataset of column sums in SASSAS Regression Output Data StructureCreating portfolios depending on 2 variables with SASCreate variables with years based on the start and end dates
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I am new to SAS and I would like to create industry portfolios based on market capitalization.
I have an excel file which has a a number of variables:
- Date
- Company Name
- Industry code (between 1 and 26)
- Return of each company
- Market cap
I would like to create a portfolio in June of each year based on the market cap and then create the value-weighted return.
I will need to re balance the portfolio in the next year.
Any advice or reference which would be useful would be greatly appreciate.
Thanks
sas
asked Mar 8 at 16:20
user11140153user11140153
53
add a comment |
I am new to SAS and I would like to create industry portfolios based on market capitalization.
I have an excel file which has a a number of variables:
- Date
- Company Name
- Industry code (between 1 and 26)
- Return of each company
- Market cap
I would like to create a portfolio in June of each year based on the market cap and then create the value-weighted return.
I will need to re balance the portfolio in the next year.
Any advice or reference which would be useful would be greatly appreciate.
Thanks
sas
asked Mar 8 at 16:20
user11140153user11140153
53
Hello, welcome to Stack Overflow. Please see this post on creating quality questions that are more likely to be answered: stackoverflow.com/help/how-to-ask. There are free SAS courses online that can be taken to get yourself introduced to SAS. I recommend starting there. coursera.org/learn/sas-programming-basics
– Stu Sztukowski
Mar 8 at 21:34
add a comment |
I am new to SAS and I would like to create industry portfolios based on market capitalization.
I have an excel file which has a a number of variables:
- Date
- Company Name
- Industry code (between 1 and 26)
- Return of each company
- Market cap
I would like to create a portfolio in June of each year based on the market cap and then create the value-weighted return.
I will need to re balance the portfolio in the next year.
Any advice or reference which would be useful would be greatly appreciate.
Thanks
sas
asked Mar 8 at 16:20
user11140153user11140153
53
I am new to SAS and I would like to create industry portfolios based on market capitalization.
I have an excel file which has a a number of variables:
- Date
- Company Name
- Industry code (between 1 and 26)
- Return of each company
- Market cap
I would like to create a portfolio in June of each year based on the market cap and then create the value-weighted return.
I will need to re balance the portfolio in the next year.
Any advice or reference which would be useful would be greatly appreciate.
Thanks
sas
sas
asked Mar 8 at 16:20
user11140153user11140153
53
asked Mar 8 at 16:20
user11140153user11140153
53
asked Mar 8 at 16:20
user11140153user11140153
53
asked Mar 8 at 16:20
user11140153user11140153
53
asked Mar 8 at 16:20
user11140153user11140153
53
53
Hello, welcome to Stack Overflow. Please see this post on creating quality questions that are more likely to be answered: stackoverflow.com/help/how-to-ask. There are free SAS courses online that can be taken to get yourself introduced to SAS. I recommend starting there. coursera.org/learn/sas-programming-basics
– Stu Sztukowski
Mar 8 at 21:34
add a comment |
Hello, welcome to Stack Overflow. Please see this post on creating quality questions that are more likely to be answered: stackoverflow.com/help/how-to-ask. There are free SAS courses online that can be taken to get yourself introduced to SAS. I recommend starting there. coursera.org/learn/sas-programming-basics
– Stu Sztukowski
Mar 8 at 21:34
Hello, welcome to Stack Overflow. Please see this post on creating quality questions that are more likely to be answered: stackoverflow.com/help/how-to-ask. There are free SAS courses online that can be taken to get yourself introduced to SAS. I recommend starting there. coursera.org/learn/sas-programming-basics
– Stu Sztukowski
Mar 8 at 21:34
Hello, welcome to Stack Overflow. Please see this post on creating quality questions that are more likely to be answered: stackoverflow.com/help/how-to-ask. There are free SAS courses online that can be taken to get yourself introduced to SAS. I recommend starting there. coursera.org/learn/sas-programming-basics
– Stu Sztukowski
Mar 8 at 21:34
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55067111%2fcreating-value-weighted-industry-portfolios-in-sas%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55067111%2fcreating-value-weighted-industry-portfolios-in-sas%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Hello, welcome to Stack Overflow. Please see this post on creating quality questions that are more likely to be answered: stackoverflow.com/help/how-to-ask. There are free SAS courses online that can be taken to get yourself introduced to SAS. I recommend starting there. coursera.org/learn/sas-programming-basics
– Stu Sztukowski
Mar 8 at 21:34