topic Re: ERROR: Variable GROUPING not found. in New SAS User

ERROR: Variable GROUPING not found.

Cykelops — Tue, 19 Nov 2024 17:11:00 GMT

Super beginner here. Got error and hoping for your assistance in fixing the problem. Here is the code.

proc freq data = CARI_ICDW_PB  ; tables RUN_YR_MO  OWNED_SERVICED  REO_ASSIGNED_STATUS  PRE_POST_FCL_SALE   portfolio    GL_PRINCIPAL_FIRST    NODE2_DESC  
NODE1_DESC   SERVICING_SYSTEM    CALL_CODE     OWNERSHIP_PERCENTAGE     MTG_IVSTR_SBCAT_TYPE_CD   INVESTOR_ID
grouping  
 ;run;

Thanks and hoping to hear from anyone.

Cykelops

Re: ERROR: Variable GROUPING not found.

jins — Tue, 19 Nov 2024 17:23:31 GMT

Please check if the variable grouping exists in the data set.

Re: ERROR: Variable GROUPING not found.

PaigeMiller — Tue, 19 Nov 2024 17:48:34 GMT

@Cykelops

You have posted at least two other threads regarding "Variable XXXXX not found", one of which you marked correct. Please see if any of the suggestions there are helpful. If not, please provide the output from PROC CONTENTS for your data set, as explained to you in those other threads.

Re: ERROR: Variable GROUPING not found.

Patrick — Tue, 19 Nov 2024 21:49:16 GMT

Besides of using Proc Contents to ensure that the variable actually exists there is also a semicolon missing in the code you shared after variable grouping.

Re: ERROR: Variable GROUPING not found.

ballardw — Tue, 19 Nov 2024 22:16:58 GMT

@Patrick wrote:

Besides of using Proc Contents to ensure that the variable actually exists there is also a semicolon missing in the code you shared after variable grouping.

The semicolon for the Tables statement that ends with Grouping is on the next line before the Run;

Re: ERROR: Variable GROUPING not found.

Patrick — Tue, 19 Nov 2024 22:42:56 GMT

@Cykelops As others already stated variable grouping doesn't exist in your source data.

From the looks of it you just want to create a frequency table for every single variable in your data source. You can use keyword _all_ to address all existing variables.

proc freq data = CARI_ICDW_PB  ; 
  tables _all_;  
run;