Hello,   I have the following code: proc means data=sasuser.sasfile010916 mean median std min max; where firmdefi=1 and firmdefi=2; var equity TAssets Sales; class firmdefi; run;   The log indicate NOTE: No observations were selected from data set SASUSER.SASFILE010916.   There is data that relate to firmdefi 1 or 2 and I do not understand what is my mistake?   Thanks for any help!!! ... View more

Hello,   My data is as follow:   I intend to use proc means in order to calculate number of variables that relate to this table. If I want to calculate the Number of observations that I use function N in proc means. Which function should I use to calculate the number of firms?   Thanks for any help   Yael ... View more

Hello Forum,   After long time I here again to ask for your help, which is great always...   I want to run regression that the dependent variable is ROA4 while the Lnsalesgro, lnsales, RDAssets, LTSTassets are the independent variables. The procedure is as follow:   proc reg data=sasuser.sasfile010916; model roa4 = Lnsalesgro lnsales RDAssets LTSTassets; run;   How should I write it if I want that ROA4 will be always from t-1 (the year before). It means, for example, that the ROA4 will be taken from 2003 while the Lnsalesgro lnsales RDAssets LTSTassets from 2004?   Thanks for any help,   Yael     ... View more

Hello   I have an example and I am not sure how to handle with the data   Firm Sales Year Change A 120 2007 -8% A 130 2006 -7% A 140 2005   B 15 2006 25% B 12 2005 20% B 10 2004     Should I use Lines A-2005 and B-2004 in column "change" as 0 or missing data?   Thanks a lot! ... View more

Hello   I have a question regarding 0 (=zero) vs missing data.   If I have an observation that have many variables but one of the variable is not relevant to this observation (but relevant to other observations), should the value of this variable be 0 (=zero) or missing data (as I found there is a big difference between them in correlation matrix   Thanks a lot for any help! ... View more

Hello   I intend to use PROC MEANS in order to get details (average, median, std, max, min) on 3 seperate groups. Is there any possibility to check the difference between the groups using chi-square in this procedure? because I did not find it   Thanks a lot! ... View more

Hello,   I have a data of 4300 lines which now I want to take only part of data for regression. I have a continouse variables which called FOWNFF, FOWNFNF, DG while nf is 0,1 variable   I want that my population will be: FOWNFF>0.2 and FOWNFNF>0.2 and if nf=1 than take the variable while it is DG>0.2 where fownff>0.2 and fownfnf>0.2 if nf=1 and dg>0.2;   that is what I wrote and got an error. The log is: ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT, LE, LT, NE, NOT, OR, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored.   Any help will be acceptable   Thanks     ... View more

Hello I have the following code: proc glm data=sasuser.sasfile250716; where year>=0 year<=5; model ROA = salesGro rdsales LTassets LNAssets cAPAXASS DIVASSETS **bleep**efound BETA /solution; run;   I have a variable "year" which have the indicators 0-10. I want to run a regression that will limit the data to years of two groups: 0-5 and 6-10. I used the statement where but got an ERROR   534 proc glm data=sasuser.sasfile250716; 535 where year>=0 year<=5; ---- 22 76 ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT, LE, LT, NE, OR, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. 536 model ROA = salesGro rdsales LTassets LNAssets cAPAXASS DIVASSETS **bleep**efound BETA 537 /solution; 538 run;   I did not find where I can use where statement as a list   Can you help me?   Thanks a lot!   ... View more