topic PROC CORR on subset of data in Statistical Procedures

PROC CORR on subset of data

yael — Mon, 20 Jun 2016 12:36:21 GMT

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!

Re: PROC CORR

Reeza — Mon, 20 Jun 2016 05:32:40 GMT

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

Re: PROC CORR

yael — Mon, 20 Jun 2016 05:50:39 GMT

Thanks for your reply.