topic Variable is not on file error, even though Proc Contents shows variable in dataset in SAS Programming

Variable is not on file error, even though Proc Contents shows variable in dataset

acemanhattan — Wed, 25 Sep 2019 15:52:24 GMT

Hi All. I'm trying to run the code below and getting an error saying ERROR: Variable srcLOB is not on file HCGOUT.OUTCLAIMS_xxxx.

I don't know why this would be the cases, because I've checked using Proc Contents and the variable does exist. Any idea why this is happening?


libname hcgout "/sasapps/HCG/HCG_PROD/Data_Sets/Output_NET";
%let list = linenum memberid memberctg incurd_yr_mo hcpcs;
%let hcpc = "E0431" "E1390" "E1392" "K0738";
%let loblist = "MCAD" "MCHM";


data hcgTables2014toPresent ;
	set hcgout.outclaims_2014 	 (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date))
		hcgout.outclaims_2015 	 (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date))
		hcgout.outclaims_prior 	 (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date))		
		hcgout.outclaims_current (where= (hcpcs in (&hcpc.) and srcLOB in (&loblist.)) keep=&list. rename=(incurd_yr_mo = date));
run;

Re: Variable is not on file error, even though Proc Contents shows variable in dataset

Reeza — Wed, 25 Sep 2019 15:58:15 GMT

It's not in your KEEP list though so you're not bringing it in, even if it is in your original data set.

I think your parenthesis are incorrect as well for your SET - it ends too early with the extra ) after the srcLOB?

Re: Variable is not on file error, even though Proc Contents shows variable in dataset

Kurt_Bremser — Wed, 25 Sep 2019 16:12:32 GMT

Make it a point to always write dataset options in this order:

keep/drop
rename
where

because that is the sequence in which they are applied by SAS, irrespective of the order in which you write them. That helps to make the code easier to understand and maintain.

Re: Variable is not on file error, even though Proc Contents shows variable in dataset

Tom — Wed, 25 Sep 2019 16:14:55 GMT

@Kurt_Bremser wrote:

Make it a point to always write dataset options in this order:

keep/drop

rename

where

because that is the sequence in which they are applied by SAS, irrespective of the order in which you write them. That helps to make the code easier to understand and maintain.

Note you can remember the order easily because it is alphabetical. Drop,Keep,Rename,Where.