topic Re: How do i fix this error? in New SAS User

How do i fix this error?

wheddingsjr — Fri, 09 Oct 2020 17:24:42 GMT

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.

Re: How do i fix this error?

Kurt_Bremser — Fri, 09 Oct 2020 17:37:39 GMT

ELSE 'Other' END AS RACE

no quotes around a variable name.

Re: How do i fix this error?

Reeza — Fri, 09 Oct 2020 17:38:18 GMT

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.

Re: How do i fix this error?

wheddingsjr — Fri, 09 Oct 2020 17:58:14 GMT

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?

Re: How do i fix this error?

wheddingsjr — Fri, 09 Oct 2020 18:00:12 GMT

Sorry, its populated with "OTHER"

Re: How do i fix this error?

Reeza — Fri, 09 Oct 2020 18:10:59 GMT

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.