I understand that I can use if first.city then lag_income=.; to get the results I want. SAS lag function can't do that itself? is there better way to do it? data want; set have; by city; lag_income = lag(income); if first.city then lag_income=.; run; ... View more

I just ran the above code, and got the lag not by city, but just by the whole data. why? The 3rd observation should have missing as the value of lag_income since it's another city, tokyo, but the result got from the income from miami. Why can't I get the lag by group?    City date income lag_income monthly_income_dif miami 20150225 50000000 . 0 miami 20150312 60000000 50000000 10000000 tokyo 20150324 10000000 60000000 0 tokyo 20150412 75000000 10000000 65000000 tokyo 20150522 65000000 75000000 -10000000 ... View more

Yes. The weight variable includes negative. What shall I do if the weight variable is the one I really need to use since negative is valid values? ... View more

proc glm data=new; class cat_3lvl; model pct_num=cat_3lvl; weight weight_num; means cat_3lvl; run; Log: NOTE: PROCEDURE GLM used (Total process time): real time 0.04 seconds cpu time 0.05 seconds ... View more

SAS Output The FREQ Procedure pct_num Frequency Percent CumulativeFrequency CumulativePercentNot Missing 1393 100.00 1393 100.00   cat_3lvl Frequency Percent CumulativeFrequency CumulativePercentNot Missing 1393 100.00 1393 100.00   weight_num Frequency Percent CumulativeFrequency CumulativePercentNot Missing 1393 100.00 1393 100.00   The GLM Procedure Class Level InformationClass Levels Valuescat_3lvl 3 grp1 grp2 grp3   Number of Observations ReadNumber of Observations Used 1393 1350       The GLM Procedure   Dependent Variable: pct_num   Weight: weight_num Source DF Sum of Squares Mean Square F Value Pr > FModelErrorCorrected Total 2 536.8515 268.4258 1.11 0.3287 1347 324685.3574 241.0433     1349 325222.2089         R-Square Coeff Var Root MSE pct_num Mean 0.001651 -17716.39 15.52557 -0.087634   Source DF Type I SS Mean Square F Value Pr > Fcat_3lvl 2 536.8515293 268.4257646 1.11 0.3287   Source DF Type III SS Mean Square F Value Pr > Fcat_3lvl 2 536.8515293 268.4257646 1.11 0.3287       The GLM Procedure Level ofcat_3lvl N Sum ofWeights pct_numMean Std Devgrp1 664 367834grp2 97 260940grp3 589 306783 -0.08937308 13.9091106 -0.05322111 22.1748667 -0.11481910 15.9299903 ... View more