About sasphd

sasphd · ‎05-04-2015

I want to estimate this equation y=a+b1*x+b2*x**(2) using gmm When I write this program it does not work proc model data= bb.mstylevw; parms a b1 b2 ; y=a+b1*x+b2 *x**(2); fit y / gmm; run; quit; when I remove Gmm, it works and it gives me regression using OLS proc model data= bb.mstylevw; parms a b1 b2 ; y=a+b1*x+b2 *x**(2); fit y / ; run; quit;

sasphd · ‎04-21-2015

the answer of Mark is good but not complete, but it was very useful. It dosen't give me what I want it exactly. I complete it by my answer. But if you want that i mark it as correct without adding my part it dosen't give the right anwer!

sasphd · ‎04-21-2015

Ok mark your program work, but I want the sum of proportion of LCGE for the crsp_fund 2761

sasphd · ‎04-21-2015

yes I did not understand how you obtain the proportion for crsp_fundno=2761 proportion LCCE=729/(364+181+729+2100+1826)= 0.1401 sorry i have done a mistake these are the right proportion crsp_fundno begdt enddt lipper_class duration proportion 139 19991231 20000629 MLGE 181 0,08752418 139 20000630 20000831 LCGE 62 0,02998066 2761 19991231 20000629 LCGE 181 0,78980769 2761 20000630 20020629 LCCE 729 0,14019231

sasphd · ‎04-21-2015

I did not want the freq but I want the proportion in funtion of the variable duration crsp_fundno begdt enddt x duration 139 19941230 19980629 1277 139 19980630 19991230 548 139 19991231 20000629 MLGE 181 139 20000630 20000831 LCGE 62 2761 19981231 19991230 364 2761 19991231 20000629 LCGE 181 2761 20000630 20020629 LCCE 729 2761 20020630 20080330 LCGE 2100 2761 20080331 20130331 LCGE 1826 I want to calculate the proportion of variable in colunm X using duration. The table want crsp_fundno x proportion 139 MLGE 0,74485597 139 LCGE 0,25514403 2761 LCGE 0,78980769 2761 LCCE 0,8010989 For example 0.74485597=181/(1277+548+181+62)

sasphd · ‎04-21-2015

proc freq data=cc;by crsp_fundno; table crsp_fundno lipper_class / norow nocol nopercent out= outfreq ;run; this program does not give what I want !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! it gives me this 139 2 . 139 LCGE 1 50 139 MLGE 1 50 1063 2 . 1063 LCGE 1 50 1063 MLGE 1 50 2218 2 . 2218 LCGE 1 100 2761 2 . 2761 LCCE 1 25 2761 LCGE 3 75 but I want crsp_fundno x proportion 139 MLGE 0,74485597 139 LCGE 0,25514403 2761 LCGE 0,78980769 2761 LCCE 0,8010989

sasphd · ‎04-21-2015

Thanks how can I get the output from this??????

sasphd · ‎04-21-2015

more details please

sasphd · ‎04-21-2015

crsp_fundno begdt enddt x duration 139 19941230 19980629 1277 139 19980630 19991230 548 139 19991231 20000629 MLGE 181 139 20000630 20000831 LCGE 62 2761 19981231 19991230 364 2761 19991231 20000629 LCGE 181 2761 20000630 20020629 LCCE 729 2761 20020630 20080330 LCGE 2100 2761 20080331 20130331 LCGE 1826 I want to calculate the proportion of variable in colunm X using duration. The table want crsp_fundno x proportion 139 MLGE 0,74485597 139 LCGE 0,25514403 2761 LCGE 0,78980769 2761 LCCE 0,8010989 For example 0.74485597=181/(1277+548+181+62)

sasphd · ‎04-20-2015

I have two tables. I want to delete from table A observations of table B Table 1 A B 3 5 4 6 1 2 3 4 Table 2 A B 3 5 3 4 Table want A B 4 6 1 2

sasphd · ‎04-20-2015

Hello, I have two to join table 1 A B 1 6 2 8 TABLE2 A B 3 5 4 6 I want A B 1 6 2 8 3 5 4 6

sasphd · ‎02-12-2015

i got this error 2816 proc univariate data=bb.mdist; 2817 var m_max_mret; 2818 by rank_no; 2819 ods output pctlpts=0 to 100 by 5 pctlpre=P_; - 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string. ERROR 76-322: Syntax error, statement will be ignored. 2820 run;

sasphd · ‎02-12-2015

when I run your program I obtain Quantile _TYPE_ _FREQ_ estimate 0 30646 1,023439 0% Min 1 2786 0,084684 1% 1 2786 0,26137 10% 1 2786 0,612162 100% Max 1 2786 2,064825 25% Q1 1 2786 0,791249 5% 1 2786 0,500818 50% Median 1 2786 0,983584 75% Q3 1 2786 1,18967 90% 1 2786 1,403732 95% 1 2786 1,537687 99% 1 2786 1,828053 Why the percentiles are not ordred. and What is the first line means

sasphd · ‎02-12-2015

Yes I want to have the average of each quantile. Like the value of max for all rank_no. the problem here is that how i can apply proc means?

sasphd · ‎02-12-2015

hello, I use proc univariate and i generate output files (quantiles and mean). proc univariate data=bb.mdist; var X; by rank_no; ods output Quantiles=quantiles; run; The file quantiles is like : Rank_NO VarName Quantile Estimate 1 X 100% Max 2,04178 1 X 99% 1,855866 1 X 95% 1,601379 1 X 90% 1,455169 1 X 75% Q3 1,24162 1 X 50% Median 0,976555 1 X 25% Q1 0,75844 1 X 10% 0,549392 1 X 5% 0,47554 1 X 1% 0,132898 1 X 0% Min -0,02425 2 X 100% Max 2,311919 2 X 99% 1,72241 2 X 95% 1,504458 2 X 90% 1,361372 2 X 75% Q3 1,176674 2 X 50% Median 0,986445 2 X 25% Q1 0,804874 2 X 10% 0,65509 2 X 5% 0,558072 2 X 1% 0,244873 2 X 0% Min -0,21428 Then, I want to perform the mean quantile by quantile so I obtain a table like this VarName Quantile Estimate X 100% Max X 99% X 95% X 90% X 75% Q3 X 50% Median X 25% Q1 X 10% X 5% X 1% X 0% Min

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

nonlinear regression

Re: calculate proportion

Re: calculate proportion

Re: calculate proportion

Re: calculate proportion

Re: calculate proportion

Re: calculate proportion

Re: calculate proportion

calculate proportion

delete observation from two tables

join two table

Re: proc univariate

Re: proc univariate

Re: proc univariate

proc univariate