dummy variable for calculating

Question

King To Leung 2022-8-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1774410-dummy-variable-for-calculating

回答： Walter Roberson 2022-8-5

Hi all,

I have a bunch of sector code in c.sic column (column19). However, there are too many sub sectors and I need to group them to a larger industry. For example, both internet sector (code 123) and microchip sector(code 124) belongs to technology sector. I wanna assign a dummy variable according to the sector code. Like 123 and 124 is A, 234, 255 and 235 is B etc. I wanna have a colum for this. After that I wanna calculate the total return (column 8) for each sector.

Thanks in advance!

3 个评论
显示 1更早的评论隐藏 1更早的评论

King To Leung 2022-8-5

I mean like each code like 123 refers to a sub industry/sector. Sub sector is like sub divisions of an industry. Like the sector is manufacturing sector. And there is sub sectors under the industry, like textile, clothing, heavy mental manufacturing etc.

So I wanna group sub sectors together, like sector code 111 123 125 belongs to the same sector and we give it a dummy variable "A".

Jan 2022-8-5

@King To Leung: It is not clear what your data types are. I do not have any idea about what "code like 123 refers to a sub industry/sector" means. It is not possibloe to suggest some code, as long as you do not clarify with which kind of data you are working.

Please read: https://www.mathworks.com/matlabcentral/answers/6200-tutorial-how-to-ask-a-question-on-answers-and-get-a-fast-answer

请先登录，再进行评论。

请先登录，再回答此问题。