hi have 900 variables in a dataset. for each of them i want to do data j2; set j1; If missing(var1)> 0 or var1 in ('NO', 'N', 'NA', ' ', '$$"ER", 9903') then newvar1= 0; Else newvar1= 1; run; what is the b est way to do this in 900 variables? thank you! ... View more

Just had a quick question regarding SAS. When I run firm/year fixed regression, I get: ERROR: The SAS System stopped processing this step because of insufficient memory. I do have 1800+ firms, but is this because my computer’s memory is not big enough? ... View more

when i merge 2 files i get: WARNING: Multiple lengths were specified for the BY variable cusip by input data sets. This          might cause unexpected results. i noticed that the fyear for two files are different. file1: best12. file2: 4. how do i change one of the following, for ex: file2's 4. to best12.? ... View more

hi, i have 2 datasets. h1111: 11960 obs h82: 13307 obs. data h111; set h11; keep gvkey pfoyr cusip mainseg; run; proc sql; create table h1111 as select distinct * from h111; quit; *11960; data h81; set h8; keep pfoyr cusip; run; *13307; proc sql; create table h82 as select distinct * from h81; quit; proc sort data=h1111; by cusip pfoyr; run; proc sort data=h82; by cusip pfoyr; run; data j1; merge h82(in=fromh82x) h1111 (in=fromh1111x); by cusip pfoyr; fromh1111=fromh1111x; fromh82=fromh82x; run; I should be getting 13307 obs but i get 15839 obs. could u please help???? thank you!!!! ... View more

hi i ran a regressiona s below proc reg data=m10; by year; model index1 = size ptb leverage roa fe1-fe3/adjrsq; output out=o1 p=p1 r=rindex1; run; quit;  the output window shows me the below by year (1991-2012):                                    Parameter       Standard               Variable     DF       Estimate          Error    t Value    Pr > |t|               Intercept     1        0.74        0.36171       2.19      0.0299               size          1       -0.146        0.04714      -3.14      0.0020               ptb           1        0.213        0.16899       1.20      0.2308               leverage      1        0.736        0.41730       2.33      0.0208               ROA           1        2.150        1.11145       1.96      0.0514               fe1           1        0.173        0.16625       0.25      0.8021               fe2           1       -0.831        0.21504      -1.30      0.1939               fe3           1       -0.886        0.16088      -5.09      <.0001 how do i output this table for each year? thank you so so much ... View more