Error: Attribute Not Found

[kajal_30]

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;

[kajal_30]

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

[SASKiwi]

There's no asterisk in the SQL DELETE statement:

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

[kajal_30 · Accepted solution]

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

Regards

Kajal

[Dianahemes]

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