topic Re: Checking for the sting in IF condition in SAS Programming

Checking for the sting in IF condition

David_Billa — Tue, 15 Oct 2019 07:45:43 GMT

Could you please help me to overcome the below NOTE in the log? Objective is to check for the string "BASECASE" in the variable SCENARIO_ID . If it not matches, then Output that record in the output

44         	FLT_ID=7;
45         	if SCENARIO_ID ne “BASECASE” then
46         		output;
47         run;

NOTE: Variable '“BASECASE”'n is uninitialized

Re: Checking for the sting in IF condition

PeterClemmensen — Tue, 15 Oct 2019 07:51:37 GMT

As @Tom pointed out in this thread, you should make sure to use the proper quotation marks and not the Windows Smart Quotes.

See below

data have;
SCENARIO_ID="BASECASE";
run;

data want;
    set have;
    *if SCENARIO_ID ne “BASECASE” then output;
    if SCENARIO_ID ne "BASECASE" then output;
run;

Re: Checking for the sting in IF condition

Kurt_Bremser — Tue, 15 Oct 2019 07:53:02 GMT

You committed the mistake of routing code through a word processor (somewhere in your development process) that replaced the correct double quotes with invalid "curly" ones.

This should work:

FLT_ID=7;
	if SCENARIO_ID ne "BASECASE" then
		output;
run;

Re: Checking for the sting in IF condition

AkilanR — Tue, 15 Oct 2019 07:59:54 GMT

If you share full code will be helpful but some time if your dataset is not having set statement then your original dataset is destroyed and start over.