ERROR: Variable GROUPING not found.

[Cykelops]

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 

[jins]

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

[PaigeMiller]

@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.

[Patrick]

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.

[ballardw]

---

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

[Patrick]

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