topic Re: Error: Attribute Not Found in SAS Programming

Error: Attribute Not Found

kajal_30 — Wed, 03 Aug 2022 02:45:16 GMT

Good Evening Team,

I am assigning value to one macro variable but while using that macro variable value I am getting error below. Can you please help.

ERROR: Attribute '202206' not found

%put yearmonth --> &yrmonth;

yearmonth --> 202206

Regards

Kajal

proc sql;
	select max(yearmonth) into :  yrmonth from source_data;
quit;

proc sql;
	delete * from target_data
		where yearmonth= &yrmonth.;
quit;

Error: Attribute Not Found

kajal_30 — Wed, 03 Aug 2022 02:23:02 GMT

Good Evening Team,

I am assigning value to one macro variable but while using that macro variable value I am getting error below. Can you please help.

Regards

Kajal

proc sql;
	select max(yearmonth) into :  yrmonth from source_data;
quit;

proc sql;
	delete * from target_data
		where yearmonth= &yrmonth.;
quit;

ERROR: Attribute '202206' not found

%put yearmonth --> &yrmonth;

yearmonth --> 202206

Re: Error: Attribute Not Found

SASKiwi — Wed, 03 Aug 2022 03:50:36 GMT

There's no asterisk in the SQL DELETE statement:

proc sql;
  delete from target_data
  where yearmonth= &yrmonth.;
quit;

Re: Error: Attribute Not Found

kajal_30 — Wed, 03 Aug 2022 03:59:52 GMT

Thank you for your kind response I was able to resolve the issue.

Regards

Kajal

Re: Error: Attribute Not Found

Dianahemes — Thu, 22 Dec 2022 06:37:45 GMT

To resolve the issue, you can modify your data selection to include data that uses that attribute, or you can remove the data attribute from your template.

Regards,
Will