How to run proc reg with a subsample without creating a subsample?

[Phil_NZ]

Hi all SAS Users,

Have a nice week,

Today I want to run PROC REG with a subsample, I know one way is to create a subsample and run PROC REG, but I wondering if there is any way to run directly in PROC REG procedure without another data step for creating a subsample.

My code of running for the WHOLE sample as below:

proc reg data=merge_treat_con_copy;
	model wINV_DAY= pt wFIRM_SIZE LNGDP UNEMPLOYMENT  INFLATION 
		wTANGIBILITY FCF wLOG_MVE wCAP_INT wGRO_MAR/ tol vif collin;
run;

Now I want to run where INDC3="RTLS".

Can you please hint me to sort it out?

Warmest regards and thanks,

Phil.

[PaigeMiller]

proc reg data=merge_treat_con_copy(where=(indc3='RTLS'));

[Tom · Accepted solution]

---

@Phil_NZ wrote:

Hi all SAS Users,

Have a nice week,

Today I want to run PROC REG with a subsample, I know one way is to create a subsample and run PROC REG, but I wondering if there is any way to run directly in PROC REG procedure without another data step for creating a subsample.

My code of running for the WHOLE sample as below:

proc reg data=merge_treat_con_copy;
	model wINV_DAY= pt wFIRM_SIZE LNGDP UNEMPLOYMENT  INFLATION 
		wTANGIBILITY FCF wLOG_MVE wCAP_INT wGRO_MAR/ tol vif collin;
run;

Now I want to run where INDC3="RTLS".

Can you please hint me to sort it out?

Warmest regards and thanks,

Phil.

---

Your question includes the answer.  Just use a WHERE statement.

where INDC3="RTLS";

[Reeza]

1. Data set option of WHERE
2. WHERE in the data step
3. Creation of a view, which doesn't create the view until you run it. 

1 & 2 are available in almost ALL process in SAS. 

You've seen examples of all in the past few months so I assume you know how to code them. 

---

@Phil_NZ wrote:

Hi all SAS Users,

Have a nice week,

Today I want to run PROC REG with a subsample, I know one way is to create a subsample and run PROC REG, but I wondering if there is any way to run directly in PROC REG procedure without another data step for creating a subsample.

My code of running for the WHOLE sample as below:

proc reg data=merge_treat_con_copy;
	model wINV_DAY= pt wFIRM_SIZE LNGDP UNEMPLOYMENT  INFLATION 
		wTANGIBILITY FCF wLOG_MVE wCAP_INT wGRO_MAR/ tol vif collin;
run;

Now I want to run where INDC3="RTLS".

Can you please hint me to sort it out?

Warmest regards and thanks,

Phil.

---