topic Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found in SAS Programming

ERROR: Variable DATACOLLECTION_FINISHTIME not found

nupedoc79 — Tue, 24 May 2022 20:14:55 GMT

I hear this a lot from people and I've said it a few times myself and find myself saying it today, "I written SAS code like this a thousand times without issue".... Any way the below code issues the ERROR: Variable DATACOLLECTION_FINISHTIME not found

proc tabulate data=&CMTH&YR._MAS_IIS_MOB_SF_NEW missing;
var DATACOLLECTION_FINISHTIME;
table DATACOLLECTION_FINISHTIME, n nmiss (min max median)*f=mmddyy10. range;
run;

A second pair of eyes would help. Thanks....

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

pink_poodle — Tue, 24 May 2022 20:20:40 GMT

Does PROC CONTENTS show that the variable exists?

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

nupedoc79 — Tue, 24 May 2022 20:24:00 GMT

Yes

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

nupedoc79 — Tue, 24 May 2022 20:25:35 GMT

I verified the variable opening up and reviewing the SAS work dataset and the variable is present.

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

Reeza — Tue, 24 May 2022 20:28:19 GMT

Run the proc contents, the variable name and label may be the issue.
Show the proc contents please.

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

sbxkoenk — Tue, 24 May 2022 20:29:17 GMT

Hello @nupedoc79 ,

Have a look to the output of this little program :

%PUT &=CMTH.;
%PUT &=YR.; 
proc contents data=&CMTH&YR._MAS_IIS_MOB_SF_NEW /* directory */ details;
title 'Contents Using the DETAILS Option';
run;

Are you sure you want to resolve both macro variables simultaneously? Maybe you want one of these to be resolved first such that a new macro variable name is constructed. The new macro variable name is then resolved in a "second round" by the macro processor.

Koen

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

SASKiwi — Tue, 24 May 2022 20:31:31 GMT

This is a guess without seeing your SAS log. You might need an extra dot for your SAS dataset macro variables name to resolve correctly:

proc tabulate data=&CMTH&YR.._MAS_IIS_MOB_SF_NEW

It depends on where the LIBREF and DATASET boundary is.

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

nupedoc79 — Tue, 24 May 2022 20:32:18 GMT

You point is well taken. The two SAS macro variables resolve successfully in prior code in the program. I will however try your suggestion. Thanks

Re: ERROR: Variable DATACOLLECTION_FINISHTIME not found

nupedoc79 — Thu, 26 May 2022 05:50:09 GMT

I resolved the issue. Thanks everyone