PROC CORR on subset of data

[yael]

Hello

I have a simple code for proc corr:

proc corr data=sasuser.sasfile190616;

var TAssets Sales ROA Q SalesGro RDSales LTassets;

by FF;

run

I want that this procedure will run only for these lines that FF=1. Where I have to add this condition?

Thanks a lot!

[Reeza · Accepted solution]

You can filter your data with a WHERE clause.

This can be placed in your code, I generally recommend it goes right after the PROC CORR statement. 

WHERE FF=1;

The full code is below, but if you're running it for only one value of FF, then you don't need the BY statement. In general I find its best to include the BY as early as possible in the proc. 

proc corr data=sasuser.sasfile190616;
Where FF=1;
by FF;
var TAssets Sales ROA Q SalesGro RDSales LTassets;
run

[yael]

Thanks for your reply.