topic Re: rename ERROR 79-322: Expecting a =. in SAS Enterprise Guide

rename ERROR 79-322: Expecting a =.

sasowiczka123 — Mon, 18 May 2020 15:24:41 GMT

I exported dataset from csv but some columns have " " in it som I'm trying to rename columns. I wrote this code:

data dane;
set dane3 ( rename=
(Region with High_Risk ( 0 = no, 1=yes)=. Region_High_Risk) );
run;

This is the error I get:

ERROR 79-322: Expecting a =.

Please help

Re: rename ERROR 79-322: Expecting a =.

Kurt_Bremser — Mon, 18 May 2020 15:29:45 GMT

For non-valid names, use "name literals":

'Region with High_Risk ( 0 = no, 1=yes)'n=Region_High_Risk

Re: rename ERROR 79-322: Expecting a =.

sasowiczka123 — Mon, 18 May 2020 15:32:59 GMT

I tried this and this is the error:

ERROR 214-322: Variable name "Region with High_Risk ( 0 = no, 1=yes)" is not valid.

ERROR 23-7: Invalid value for the RENAME option.

Re: rename ERROR 79-322: Expecting a =.

sasowiczka123 — Mon, 18 May 2020 15:37:00 GMT

Oka, I found a better option:

use this before importing csv file

options validvarname=v7;

Re: rename ERROR 79-322: Expecting a =.

Kurt_Bremser — Mon, 18 May 2020 15:38:28 GMT

Run a proc contents on your dataset to determine your real column names.