topic Re: Understanding set statement error in SAS Procedures

Understanding set statement error

SASstudent2013 — Fri, 22 Mar 2013 14:56:06 GMT

Hi. I am trying to create a new variable ('vari2) based on responses to another variable. To do this, I was going to use the set statement and keep getting the same error. Code and error are below. Any help is appreciated!

data test;

set test1;

IF vari1=. THEN vari2=.;

ELSE IF vari1=(1 OR 0) THEN vari2=1;

run;

19 data test;

20 set test1;

ERROR: File WORK.test1.DATA does not exist.

Re: Understanding set statement error

Reeza — Fri, 22 Mar 2013 14:59:01 GMT

Its saying you don't have a test1 dataset created. You may have the names backwards or another error somewhere else in your code.

data test1;

set test;

IF vari1=. THEN vari2=.;

ELSE IF vari1=(1 OR 0) THEN vari2=1;

run;

Re: Understanding set statement error

ballardw — Fri, 22 Mar 2013 15:11:23 GMT

If vari1 ever has values other than ., 0, or 1 you may want:

ELSE If vari1 in (1,0) then vari2=1;

The vari1=(1 or 0) will always be true as it will compare the portion 1 or 0 first and since SAS treats 1 as True and 0 as False then (true or false) will always resolve to true.

If vari1 doesn't take on any other values then you only need:

Else Vari2=1;

Re: Understanding set statement error

SASstudent2013 — Fri, 22 Mar 2013 15:29:08 GMT

Thanks. I think there's an issue with my libname statement. I have a dataset named 'test' in the folder 'Data1' and want to first create a permanent library, then create a new variable via above code. Do you know what I'm doing wrong with the below?

Code:

libname anaysis 'X:\Proj Mgmt FOLDER\FINAL DATASET\My Data\SAS data\Data1';

data test;

set analysis.test1;

104 libname anaysis 'X:\Proj Mgmt FOLDER\FINAL DATASET\My Data\SAS

104! data\Data1';

NOTE: Libref ANAYSIS was successfully assigned as follows:

Engine: V9

Physical Name:

X:\Proj Mgmt FOLDER\FINAL DATASET\My Data\SAS

104! data\Data1

105 data test;

106 set analysis.test1;

ERROR: Libname ANALYSIS is not assigned.

ERROR: File WORK.analysis.test1.DATA does not exist.

Re: Understanding set statement error

Astounding — Fri, 22 Mar 2013 16:08:15 GMT

You changed your spelling. You started with ANAYSIS, then switched to ANALYSIS.

Re: Understanding set statement error

Reeza — Fri, 22 Mar 2013 17:32:02 GMT

Additionally, you say the data is called test, but you refer to it as Test1

Re: Understanding set statement error

SASstudent2013 — Fri, 22 Mar 2013 20:20:17 GMT

Thanks for catching that. I'm not writing the real names of these datasets because of confidentiality, so I mistyped when I wrote dummy names in the forum.

Is it correct that when using the set statement, set must be the name of the existing dataset and the data step is the name of the new set?

I updated code to reflect this and am not getting any error from the set statement. However, I am getting an error for the new variable.

Code:

data analysis2; /*create new dataset called "analysis2*/

set final322; /*from existing dataset called final322*/

IF vari1=. THEN vari2=.; /*create new variable called "vari2" that has either . or 1*/

ELSE IF vari1=(1 OR 0) THEN vari2=1;

run;

Log:

185 data analysis2;

186 set final322;

188 IF vari1=. THEN vari2=.;

180

189 ELSE IF vari1=(1 OR 0) THEN vari2=1;

180

ERROR 180-322: Statement is not valid or it is used out of proper order. (vari2 is underlined in the log referencing this error)

Re: Understanding set statement error

Reeza — Fri, 22 Mar 2013 23:57:33 GMT

You are correct about your data and set questions.

The following isn't valid SAS code, as @Ballardw mentioned earlier.

189 ELSE IF vari1=(1 OR 0) THEN vari2=1;

You can use the following instead:

else if vari IN (0,1) then vari2=1;

Re: Understanding set statement error

SASstudent2013 — Sat, 23 Mar 2013 14:27:09 GMT

Thank you!