How do i fix this error?

[wheddingsjr]

Hi all

I ran this query but i get the following error message. Can anyone assist me in correcting this?

	, R.RACE01DSC as Race_Ethnicity LABEL= 'Race/Ethnicity'
	,CASE WHEN RACE01DSC = 'ASIAN' THEN 'Asian'
		  WHEN RACE01DSC = 'BLACK OR AFRICAN AMERICAN' THEN 'Black or African American'
		  WHEN RACE01DSC = 'Hispanic or Latino' THEN 'Hispanic or Latino'
		  WHEN RACE01DSC LIKE ('WHITE%') THEN 'White or Caucasian'
	      WHEN RACE01DSC IN ('Declined', 'Unavailable') THEN 'Unknown'
		  WHEN RACE01DSC IS NULL THEN 'Unknown'
		  ELSE 'Other' END AS 'RACE'

______
22
ERROR 22-322: Expecting a name.

[Kurt_Bremser]

ELSE 'Other' END AS RACE

no quotes around a variable name.

[Reeza]

Remove quotes around your variable name, RACE.

END AS RACE

Or add an N after it to tell SAS it's a valid variable name not a character string.

END as 'RACE'n

---

@wheddingsjr wrote:

Hi all

I ran this query but i get the following error message. Can anyone assist me in correcting this?

	, R.RACE01DSC as Race_Ethnicity LABEL= 'Race/Ethnicity'
	,CASE WHEN RACE01DSC = 'ASIAN' THEN 'Asian'
		  WHEN RACE01DSC = 'BLACK OR AFRICAN AMERICAN' THEN 'Black or African American'
		  WHEN RACE01DSC = 'Hispanic or Latino' THEN 'Hispanic or Latino'
		  WHEN RACE01DSC LIKE ('WHITE%') THEN 'White or Caucasian'
	      WHEN RACE01DSC IN ('Declined', 'Unavailable') THEN 'Unknown'
		  WHEN RACE01DSC IS NULL THEN 'Unknown'
		  ELSE 'Other' END AS 'RACE'

______
22
ERROR 22-322: Expecting a name.

---

[wheddingsjr]

Thanks Reeza and Kurt. That made the query run, however, the new column is populated with "Unknown" regardless what the Race_Ethnicty column is. How does that happen?

[wheddingsjr]

Sorry, its populated with "OTHER"

[Reeza · Accepted solution]

That's a logical error then.
Run a PROC FREQ on the original column, RACE01DSC, to show us the original values. If they don't match because of case differences is usually the first issue. Second could be invisible spaces.