About sasphd

sasphd · ‎04-03-2018

Thanks you. Just to give you an idea of my data id EI G LTG GI MC MRC SC MCG 1 0 0 0 0 0 0 0 1 2 1 0 0 0 0 0 0 0

sasphd · ‎04-03-2018

for each dummy variable is 1 or 0 and I have nine dummies variables

sasphd · ‎04-03-2018

so I did not understand your question ?? can you please explain what did you mean by levels How did you create your dummy variables? if the style = AG so AG=1 else AG=0

sasphd · ‎04-03-2018

this my model disGDFF=a+a1*logage+a2*logTNA+a3*logMT+a4*EXP_RATIO+a5*turn+a6*logtnasq+a7*AG+a8*EI+a9*G+a10*LTG+a11*GI+a12*MC+a13*MRC+a14*SC+a15*MCG; AG EI G LTG GI MC MRC SC MCG are style dummies variables. by line dummy will be 1 for one style for example G and 0 for others styles

sasphd · ‎04-03-2018

I am runnig proc model and when I add dummies in my regression the model converges but in the output T-values are B. what does it mean and How I can solve that????

sasphd · ‎01-10-2018

Before Asking for my problem here I have mistake in my table here the format of the data is not good to give the table I want to present for you. please correct it before. My problem now is to count the number of CRSP_fundno that have the same MGMT_NAME for each CALDT?????????????? Table I have is data family; input Rank_NO crsp_fundno MGMT_NAME CALDT; format MGMT_NAME $80. caldt YYMMDDN8.; cards; 1 53 SCUDDER STEVENS & CLARK 19921231 2 105 AMERICAN PENSION INVESTORS INC. 19921231 3 113 WINSBURY COMPANY (THE) 19921231 5 131 WINSBURY COMPANY (THE) 19921231 9 309 CAPSTONE FINANCIAL SERVICES 19921231 11 606 KEYSTONE GROUP INC. 19921231 14 720 OHIO COMPANY (THE) 19921231 15 828 INVESCO FUNDS GROUP INC. 19921231 17 871 SIGNATURE FINANCIAL GROUP INC. 19921231 532 7235 CENTURY SHARES TRUST 19931231 536 7317 PACIFIC FINANCIAL RESEARCH 19931231 537 7353 WANGER ASSET MANAGEMENT L.P. 19931231 539 7374 COLUMBIA FUNDS MANAGEMENT CO. 19931231 540 7405 COLONIAL MANAGEMENT ASSOCIATES INC. 19931231 541 7406 COLONIAL MANAGEMENT ASSOCIATES INC. 19931231 543 7428 COLONIAL MANAGEMENT ASSOCIATES INC. 19931231 ; run; the table I want is MGMT_NAME CALDT number SCUDDER STEVENS & CLARK 1992-12-31 1 AMERICAN PENSION INVESTORS INC. 1992-12-31 1 WINSBURY COMPANY (THE) 1992-12-31 2 CAPSTONE FINANCIAL SERVICES 1992-12-31 1 KEYSTONE GROUP INC. 1992-12-31 1 OHIO COMPANY (THE) 1992-12-31 1 INVESCO FUNDS GROUP INC. 1992-12-31 1 SIGNATURE FINANCIAL GROUP INC. 1992-12-31 1 CENTURY SHARES TRUST 1993-12-31 1 PACIFIC FINANCIAL RESEARCH 1993-12-31 1 WANGER ASSET MANAGEMENT L.P. 1993-12-31 1 COLUMBIA FUNDS MANAGEMENT CO. 1993-12-31 1 COLONIAL MANAGEMENT ASSOCIATES INC. 1993-12-31 3

sasphd · ‎06-08-2017

can anyone help me????

sasphd · ‎06-07-2017

How can I change year+1 in your program data test; input id rankdate eq; cards; 1 19880331 . 1 19880630 . 1 19880930 . 1 19881231 . 1 19890331 . 1 19890630 . 1 19890930 . 1 19891231 . 1 19900331 . 1 19900630 . 1 19900930 . 1 19901231 39.2 1 19910331 . 1 19910630 . 1 19910930 . 1 19911231 127.336 1 19920331 . 1 19920630 . 1 19920930 . 1 19921231 252.952 1 19930331 . 1 19930630 . 1 19930930 . 1 19931231 209.567 1 19940331 . 1 19940630 . 1 19940930 . 1 19941231 239.622 1 19950331 . 1 19950630 . 1 19950930 . 1 19951231 265.222 1 19960331 . 1 19960630 . 1 19960930 . 1 19961231 458.352 1 19970331 . 1 19970630 . 1 19970930 . 1 19971231 881.127 1 19980331 . 1 19980630 . 1 19980930 . 1 19981231 1752.1 1 19990331 . 1 19990630 . 1 19990930 . 1 19991231 2298.734 1 20000331 . 1 20000630 . 2 19911231 . 2 19920331 . 2 19920630 . 2 19920930 . 2 19921231 . 2 19930331 . 2 19930630 . 2 19930930 . 2 19931231 . 2 19940331 . 2 19940630 . 2 19940930 . 2 19941231 2.792 2 19950331 . 2 19950630 . 2 19950930 . 2 19951231 2.795 2 19960331 . 2 19960630 . 2 19960930 . 2 19961231 8.635 2 19970331 . 2 19970630 . 2 19970930 . 2 19971231 20.477 2 19980331 . 2 19980630 . 2 19980930 . 2 19981231 48.377 2 19990331 . 2 19990630 . 2 19990930 . 2 19991231 56.088 ; run; Data want1; Set test; By Id; retain new_EQ; if missing(eq) then new_eq = eq; else if last.id then Do; next(rankdate); output; Output; run;

sasphd · ‎06-07-2017

I try to change the chrac to numeric but it does not work data test; input id rankdate eq; cards; 1 19880331 . 1 19880630 . 1 19880930 . 1 19881231 . 1 19890331 . 1 19890630 . 1 19890930 . 1 19891231 . 1 19900331 . 1 19900630 . 1 19900930 . 1 19901231 39.2 1 19910331 . 1 19910630 . 1 19910930 . 1 19911231 127.336 1 19920331 . 1 19920630 . 1 19920930 . 1 19921231 252.952 1 19930331 . 1 19930630 . 1 19930930 . 1 19931231 209.567 1 19940331 . 1 19940630 . 1 19940930 . 1 19941231 239.622 1 19950331 . 1 19950630 . 1 19950930 . 1 19951231 265.222 1 19960331 . 1 19960630 . 1 19960930 . 1 19961231 458.352 1 19970331 . 1 19970630 . 1 19970930 . 1 19971231 881.127 1 19980331 . 1 19980630 . 1 19980930 . 1 19981231 1752.1 1 19990331 . 1 19990630 . 1 19990930 . 1 19991231 2298.734 1 20000331 . 1 20000630 . 2 19911231 . 2 19920331 . 2 19920630 . 2 19920930 . 2 19921231 . 2 19930331 . 2 19930630 . 2 19930930 . 2 19931231 . 2 19940331 . 2 19940630 . 2 19940930 . 2 19941231 2.792 2 19950331 . 2 19950630 . 2 19950930 . 2 19951231 2.795 2 19960331 . 2 19960630 . 2 19960930 . 2 19961231 8.635 2 19970331 . 2 19970630 . 2 19970930 . 2 19971231 20.477 2 19980331 . 2 19980630 . 2 19980930 . 2 19981231 48.377 2 19990331 . 2 19990630 . 2 19990930 . 2 19991231 56.088 ; run; data want ; set test ; array _char eq ; array _num 8 eq1; do i=1 to dim(_char); _num(i) = input(_char(i),best32.); end; drop eq1 i; run; data want1; set want; by ID; retain lstv; If first.ID then lstv = ""; if EQ ne "" then lstv=EQ; if EQ="" then EQ=lstv; run;

sasphd · ‎06-07-2017

this is the real data data test; input rank_no rankdate eq; cards; 1 19880331 . 1 19880630 . 1 19880930 . 1 19881231 . 1 19890331 . 1 19890630 . 1 19890930 . 1 19891231 . 1 19900331 . 1 19900630 . 1 19900930 . 1 19901231 39.2 1 19910331 . 1 19910630 . 1 19910930 . 1 19911231 127.336 1 19920331 . 1 19920630 . 1 19920930 . 1 19921231 252.952 1 19930331 . 1 19930630 . 1 19930930 . 1 19931231 209.567 1 19940331 . 1 19940630 . 1 19940930 . 1 19941231 239.622 1 19950331 . 1 19950630 . 1 19950930 . 1 19951231 265.222 1 19960331 . 1 19960630 . 1 19960930 . 1 19961231 458.352 1 19970331 . 1 19970630 . 1 19970930 . 1 19971231 881.127 1 19980331 . 1 19980630 . 1 19980930 . 1 19981231 1752.1 1 19990331 . 1 19990630 . 1 19990930 . 1 19991231 2298.734 1 20000331 . 1 20000630 . 2 19911231 . 2 19920331 . 2 19920630 . 2 19920930 . 2 19921231 . 2 19930331 . 2 19930630 . 2 19930930 . 2 19931231 . 2 19940331 . 2 19940630 . 2 19940930 . 2 19941231 2.792 2 19950331 . 2 19950630 . 2 19950930 . 2 19951231 2.795 2 19960331 . 2 19960630 . 2 19960930 . 2 19961231 8.635 2 19970331 . 2 19970630 . 2 19970930 . 2 19971231 20.477 2 19980331 . 2 19980630 . 2 19980930 . 2 19981231 48.377 2 19990331 . 2 19990630 . 2 19990930 . 2 19991231 56.088 ; run;

sasphd · ‎06-07-2017

I never succeed to put the data at the right format for the forum

sasphd · ‎06-07-2017

thanks a lot I remark that the problem is on my original data when I put only this program log indicates Character values have been converted to numeric values at the places given by: (Line):(Column). data joint1; set joint; by ID; retain lstv; if EQ ne "" then lstv=EQ; if EQ="" then EQ=lstv; run; when I add If first.ID then lstv = ""; the program does not work

sasphd · ‎06-07-2017

I try this but not change in my data data joint1; set joint; by rank_no; retain lstv; if EQ ne "" then lstv=EQ; run;

sasphd · ‎06-07-2017

I think the year+1 is the problem

sasphd · ‎06-07-2017

REEZA your solution does not work because in my real data I have monthly data of this form 19880331

Online Status	Offline
Date Last Visited	‎11-08-2024 11:07 PM

how to get Residuals Standard Deviation in output proc model

change date format from Best12. / informat 12. to yymmn6.

create dummy by ticker and year

Re: change date format from $10.

change date format from $10.

select variables

Re: select the last observation by id and date

select the last observation by id and date

Re: date difference in year between two date YYMMDDN8.

Re: date difference in year between two date YYMMDDN8.

Re: change date format from Best12. / informat 12. to yymmn6.

Re: change date format from Best12. / informat 12. to yymmn6.

Re: change date format from Best12. / informat 12. to yymmn6.

Re: create dummy by ticker and year

Re: change date format from $10.

add day to format date

Re: change format form char $28 to numeric

Re: proc model dummies

Re: proc model dummies

Re: proc model dummies

Re: proc model dummies

proc model dummies

count the number of occurences

Re: repeat the last observation

Re: repeat the last observation

Re: repeat the last observation

Re: repeat the last observation

Re: repeat the last observation

Re: repeat the last observation

Re: repeat the last observation

Re: repeat the last observation

Re: repeat the last observation