About yael

yael · ‎02-12-2019

Thanks a lot! Yael

yael · ‎02-12-2019

@Kurt_Bremser thanks for your reply. I hope that my following sample will be clearer. I have the following data: Firm stages variables / stages 1 2 3 4 5 Sales Growth (%) 6 11 4 2 -3 Firm Age 30 33 34 34 30 Debts / T. assets (%) 60 62 55 57 51 These figures are based on 5000 observations. The variables figures are means in each firm stage. There are criterions for each firm stage and the variables figures are divided into the firm stages by these criteria. I want to check if there is a statistical significance between the firm stages means. I believe I can check every 2 stages with the t-test, but I wonder if there is any other way to check it? Thanks a lot for your remarks Have a nice day Yael

yael · ‎02-12-2019

Hello I am asking for your help, I have 5 continuous variables while each of it has 5 categories. For example, a variable of the "firm age" has five existing categories such as an observation can be shown only in one category. Or a variable of "firm size" has also 5 categories and a single observation can only be in one of the existing categories. My question - what are the statistical ways for checking the difference between the categories (columns)? F test is the only way? Thanks for your help

yael · ‎01-28-2019

@ballardw Thanks a lot!

yael · ‎01-28-2019

Hello to you, Thanks for your attention, I have a question regarding sample characters definition. For example, I have yearly observations of 300 firms for 10 years (2004-2013), total observations are 3000. 30 firms are defined as partnership ownership for the whole period (2004-2013). So, if I want to check the difference between partnership ownership to other firms, I check the gap between the 30 firms to 270 firms. But, part of the "other firms" (270) holds also partnership ownership in specific years but not throughout all the years. Will it be correct to add also these observations to the group of partnership ownership, or should I use only the 300 observations that I mentioned above. I hope that I clarify my question Thanks a lot Yael

yael · ‎03-08-2018

Hello I have SAV file that includes 124 columns and 4000 lines. I do not know why I can not import an excel file to SAS (working via the university), so now I am trying to do other action in order to add data. I want to add an additional column (new variable) with 4000 lines to the existing SAV file. How do you suggest to do it (I check in this community and find many options like SQL but I am not sure about it). Thanks for any clue Hedva

yael · ‎06-13-2017

Hello, I run the following code: PROC reg data=sasuser.yael215017; model divassets = Lnsalesgro lnassets LTSTassets Lnage year2004 year2005 year2006 year2007 year2008 year2009 year2010 year2011 year2012 year2013; run; The answer I got in log is: ERROR: File SASUSER.YAEL215017.DATA does not exist. First, The file is exist in as "Yael210517" BUT why the file is called now: YAEL215017.DATA??? Thanks for any clue...

yael · ‎05-21-2017

Hello It looks easy and i still do not know what is my mistake. I want to create a new variable named FFOM. This variable will get value if founder (dummy variable 1/0) or secthird (dummy variable 1/0) is 1 and FOWNFF (countinous variable) >0. This is my code: data Y210517; set sasuser.y2; ffom = if founder eq 1 or secthird eq 1 and fownff gt 0 then fownff; run; The log I got is: Thanks for any clue...

yael · ‎05-18-2017

Hello I am tring to add a new variable with the following code: data new; set sasuser.hed1; lncapax = ln(capaxass); run; The log I got is: NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0 observations and 183 variables. NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format. I believe the reason is that there is observation with 0 value and the ln of it is an error. How can I fix it? Thanks a lot!

yael · ‎05-17-2017

Ignore it, this is my mistake 🙂

yael · ‎05-17-2017

Hello I am using PROC GLM and got 3 tables, type I and type III include all the variables in the code while standard table includes only part of it. Any reason? Thanks a lot!

yael · ‎05-14-2017

Hello I will be glad to get your help I am trying to import an excel file and got the following warning: During read data truncated column table_name Thanks for any help!

yael · ‎05-11-2017

Hello I am trying to import excel file to SAS (did it many times in the past). Now I got the following two Computer Screens which I really do not understand. There is not any Excel icon any more but white note close the excel name file. Can I do something to improve it? Thanks a lot!

yael · ‎05-04-2017

Hello, I am asking for your advice, I have two independent variables with correlation of 0.5. The variables are as follows: (1) Family ownership, which refers to the family % in ownership (2) Founder, dummy variable with 1/0 if the manager is the founder The correlation is 0.5 as in some firms this is the same person. If I want to check the "PURE" impact of each variable on the dependent variable, what you suggest me to do? (PURE means, for example, the real impact of being founder w/o the ownership too). My first idea (that also checked) was to run the regression of founder impact only between similar ownship groups, but in this way I am loosing a lot of data that is not used and might help. Can you please give any clue how to handle with it? Thanks a lot!

yael · ‎05-01-2017

Hello I have the following results and I'm not sure about the conclusions. I am checking the impact of CEO in three stages. Stage 1,2 and 3. The results are as follows: Stage 1 - 0.073 (p=0.05) Stage 2 - 0.02 (p=0.01) Stage 3 - 0.058 (p<0.0001) All are positive impact, but I am trying to understand the difference between stage 1 and 3. Stage 1 is 0.073 but p=0.05 and stage 3 is with less impact but with higher significent. Can I say that the CEO impact is higher in stage 1 even if it is in p=0.05? Thanks a lot!

Online Status	Offline
Date Last Visited	‎02-12-2019 09:09 AM

Re: Difference between data columns

Re: Difference between data columns

Difference between data columns

Re: Different characters definition throughout the years

Different characters definition throughout the years

Add a column to sas file

ERROR: File SASUSER.YAEL215017.DATA does not exist.

If condition

Adding new variable

Re: Proc GLM - OUTPUT

Re: Add a column to sas file

Re: Add a column to sas file

Re: Add a column to sas file

Re: If condition

Re: ERROR: File SASUSER.YAEL215017.DATA does not exist.

Controlling for variable

Re: Difference between data columns

Re: Difference between data columns

Difference between data columns

Re: Different characters definition throughout the years

Different characters definition throughout the years

Add a column to sas file

ERROR: File SASUSER.YAEL215017.DATA does not exist.

If condition

Adding new variable

Re: Proc GLM - OUTPUT

Proc GLM - OUTPUT

Warning: During read data truncated column table_name

Can not read excel files

Correlation between variables

Meaning of significent