Proc glm performs simple and multiple regression, analysis of variance (ANOVA), analysis of covariance, multivariate analysis of variance and repeated measure analysis of variance. ... View more

The select statement is used when you are using one condition to compare with several conditions like. Data exam; Set exam; select (pass); when Physics gt 60; when math gt 100; when English eq 50; otherwise fail; run; ... View more

Both DROP and KEEP can be used to limit the variables in the dataset. The DROP=option tells SAS which variables you want to  If you place the DROP= option on the SET statement, SAS drops the specified variables when it reads the input data set and if you place the DROP= option on the DATA statement, SAS drops the specified variables when it writes to the output data set. The KEEP=option tells SAS which variables you want to  If you place the KEEP= option on the SET statement, SAS keeps the listed variables when it reads the input data set. On the other hand, if you place the KEEP= option on the DATA statement, SAS keeps the specified variables when it writes to the output data set.  ... View more

Data one two three; Merge DSN1 (in=A) DSN2 (in=B); By ID; If A and B then output one; If A and not B then output two; If not A and B then output three; Run; ... View more