topic Re: How to run proc reg with a subsample without creating a subsample? in SAS Procedures

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

Phil_NZ — Sun, 02 May 2021 22:08:20 GMT

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.

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

PaigeMiller — Sun, 02 May 2021 22:27:09 GMT

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

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

Tom — Sun, 02 May 2021 22:33:02 GMT

@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";

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

Reeza — Mon, 03 May 2021 03:03:03 GMT

Data set option of WHERE
WHERE in the data step
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.