About sasphd

sasphd · ‎12-13-2021

I put this data _mret_morningstar8; set _mret_morningstar; format date $40.; date2=input(date, YYMMDD8.); run; but it does not work my date format is $40. and I wand YYMMDD8.

sasphd · ‎12-13-2021

Hello, I want to change the date format. I write this data _mret_morningstar; set _mret_morningstar; format date YYMMDDN8.; run; but sas give me an error 635 data _mret_morningstar; 636 set _mret_morningstar; 637 format date YYMMDDN8.; --------- 48 ERROR 48-59: The format $YYMMDDN was not found or could not be loaded. 638 run;

sasphd · ‎12-10-2021

Hello; I want to import excel data file to sas. My file has 455 columns but SAS import only 256. I use proc import proc import datafile = 'C:\MaRecherche\Value added infrastructure MFs\database\_0_Fundname_Morningstar.xlsx' DBMS = Excel OUT = mret_morningstar ; sheet="mret_morningstar"; thanks

sasphd · ‎11-30-2021

I do this but it does not work PROC TRANSPOSE DATA=have; OUT=want ; by secid; RUN;

sasphd · ‎11-30-2021

hello Have secid 01-2020 02-2020 03-2020 1 0.3 0.2 0.6 2 0.25 0.68 0.95 want secid caldt mret 1 01-2020 0.3 1 02-2020 0.2 1 03-2020 0.6 2 01-2020 0.25 2 02-2020 0.68 2 03-2020 0.95

sasphd · ‎11-03-2021

Hello, I want to set three first observations to missing by id Have id mret 1 8 1 5 1 6 1 9 2 63 2 95 2 6 2 8 want id mret 1 . 1 . 1 . 1 9 2 . 2 . 2 . 2 8

sasphd · ‎11-02-2021

hello I have this program to calculate the variable flux. I want that the program begin the calculation only after 3 missing value for each id (rank_no here) data flux1; set JOINT_Ftna2; by rank_no; rtri=((mret))*(lag1(mret))*(lag2(mret))-1; flux=(new_TNA_LATEST-lag3(new_TNA_LATEST)*(1+rtri))/lag3(new_TNA_LATEST); run; Have CALDT Rank_NO CRSP_FUNDNO MRET new_TNA_LATEST rtri 1985-02-28 1 53 1,00062422 39,2 1985-03-29 1 53 1,00935745 39,2 1985-04-30 1 53 1,00061805 39,2 0,01061174 1985-05-31 1 53 1,05514655 39,2 0,06567826 1985-06-28 1 53 1,02113917 39,2 0,07811738 1985-07-31 1 53 1,00115009 39,2 0,07869063 1985-08-30 1 53 0,99478865 39,2 0,01698593 1985-09-30 1 53 0,98020955 39,2 -0,02377722 1997-09-30 2 103 1,05448301 113,689 0,1056362 1997-10-31 2 103 0,97858404 113,689 0,02168359 1997-11-28 2 103 1,02221451 113,689 0,0548234 1997-12-31 2 103 1,00469527 49,983 0,00501959 1998-01-30 2 103 0,9622905 49,983 -0,01171411 1998-02-27 2 103 1,09756894 49,983 0,06113921 1998-03-31 2 103 1,03639974 49,983 0,09462485 1998-04-30 2 103 1,01915709 49,983 0,15931173 want CALDT Rank_NO CRSP_FUNDNO MRET new_TNA_LATEST rtri flux 1985-02-28 1 53 1,00062422 39,2 1985-03-29 1 53 1,00935745 39,2 1985-04-30 1 53 1,00061805 39,2 0,01061174 1985-05-31 1 53 1,05514655 39,2 0,06567826 -0,06567826 1985-06-28 1 53 1,02113917 39,2 0,07811738 -0,07811738 1985-07-31 1 53 1,00115009 39,2 0,07869063 -0,07869063 1985-08-30 1 53 0,99478865 39,2 0,01698593 -0,01698593 1985-09-30 1 53 0,98020955 39,2 -0,02377722 0,02377722 1997-09-30 2 103 1,05448301 113,689 0,1056362 1997-10-31 2 103 0,97858404 113,689 0,02168359 1997-11-28 2 103 1,02221451 113,689 0,0548234 1997-12-31 2 103 1,00469527 49,983 0,00501959 -0,56537283 1998-01-30 2 103 0,9622905 49,983 -0,01171411 0,01171411 1998-02-27 2 103 1,09756894 49,983 0,06113921 -0,06113921 1998-03-31 2 103 1,03639974 49,983 0,09462485 -0,09462485 1998-04-30 2 103 1,01915709 49,983 0,15931173 -0,15931173

sasphd · ‎11-02-2021

if first.rank_no then flux=.;

sasphd · ‎11-02-2021

hello, I want to this caluation by rank_no and to specify that if I begin a new rank_no not to do it I write this but it seems not work? data flux1; set JOINT_Ftna2; by rank_no; rtri=((mret))*(lag1(mret))*(lag2(mret))-1; flux=(new_TNA_LATEST-lag(new_TNA_LATEST)*(1+rtri))/lag(new_TNA_LATEST); if first.rank_no then flux=.; run; I have this data CALDT Rank_NO MRET new_TNA_LATEST rtri flux 1985-03-29 1 1,00935745 39,2 1985-04-30 1 1,00061805 39,2 0,01061174 -0,01061174 1985-05-31 1 1,05514655 39,2 0,06567826 -0,06567826 1985-06-28 1 1,02113917 39,2 0,07811738 -0,07811738 1985-07-31 1 1,00115009 39,2 0,07869063 -0,07869063 1985-08-30 1 0,99478865 39,2 0,01698593 -0,01698593 1985-09-30 1 0,98020955 39,2 -0,02377722 0,02377722 1985-10-31 1 1,05225653 39,2 0,02605675 -0,02605675 1985-11-29 1 1,04958722 39,2 0,08257774 -0,08257774 1985-12-31 1 1,04352557 39,2 0,15250617 -0,15250617 1989-01-31 2 1,02924367 2,792 0,01954959 1989-02-28 2 0,98887854 2,792 -0,00035636 0,00035636 1989-03-31 2 1,01144648 2,792 0,02944717 -0,02944717 1989-04-28 2 1,04709994 2,792 0,04730697 -0,04730697 1989-05-31 2 1,05215827 2,792 0,11432562 -0,11432562 1989-06-30 2 0,9864359 2,792 0,0867711 -0,0867711 1989-07-31 2 1,050077 2,792 0,08986095 -0,08986095 1989-08-31 2 1,04562886 2,792 0,08309757 -0,08309757 1989-09-29 2 0,997994 2,792 0,09578825 -0,09578825

sasphd · ‎04-26-2021

in positive!

sasphd · ‎04-26-2021

please can you give the program pour z-test with Anova or ttest

sasphd · ‎04-26-2021

Thank you very much Reeza. How I can do a z-test to test if the proportion of positive variation is equal between id 1 and 2?

sasphd · ‎04-26-2021

Hello, I have this table id variation 1 0.258 1 -0.53 2 0.563 2 -0.386 2 -0.568 I want to calculate the number of negative and positive variations by id. the table that I want id variation count 1 positive 1 1 negatif 1 2 positive 1 2 negatif 2

sasphd · ‎02-23-2021

Hello, I want to calculate the number of id per date or year data have; input date id $; datalines; 1996 5 1996 6 1996 7 1997 1 1998 5 1998 10 1999 11 run; data want; input date nbid $; datalines; 1996 3 1997 1 1998 2 1999 1 run;

sasphd · ‎02-15-2021

Hello I want to select the first row by id like that id r 1 6 1 7 2 89 2 98 want id r 1 6 2 89

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: change format

change format

import an excel file with more than 256 columns

Re: transpose by id

transpose by id

set the three first observations to missing by id

put missing value by id

Re: calculate by id

calculate by id

Re: calculate the frequency of positive and negative values by id

Re: calculate the frequency of positive and negative values by id

Re: calculate the frequency of positive and negative values by id

calculate the frequency of positive and negative values by id

number of id per date

select the first row by id