topic Re: case statement in SAS Programming

case statement

BrahmanandaRao — Fri, 25 Jun 2021 07:16:30 GMT

proc sql;
select * case when sex='F' then  'Female'
else   'Male'  end as newvar from sashelp.class;
quit;

Re: case statement

Kurt_Bremser — Fri, 25 Jun 2021 08:43:23 GMT

And your question is ...

@BrahmanandaRao wrote:

proc sql;
select * case when sex='F' then  'Female'
else   'Male'  end as newvar from sashelp.class;
quit;

Re: case statement

Amir — Fri, 25 Jun 2021 08:32:11 GMT

Well, the OP has already posted a query...

Re: case statement

Kurt_Bremser — Fri, 25 Jun 2021 08:43:07 GMT

Well, the syntax error is obvious (at least it must be for a poster with 400+ posts here), so it can't be that.

Re: case statement

tarheel13 — Fri, 25 Jun 2021 14:11:57 GMT

You need to put a comma after the *.

Re: case statement

jimbarbour — Fri, 25 Jun 2021 15:24:56 GMT

It just needs a comma after the asterisk. Like this:

     proc sql;
         select *, case when sex='F' then  'Female'
         else   'Male'  end as newvar from sashelp.class;
     quit;

NOTE: PROCEDURE SQL used (Total process time):
      real time           0:00:00.04
      cpu time            0:00:00.03
      Timestamp           June 25, 2021 10:22:46

@tarheel13 is quite correct in his assessment.

Jim

Re: case statement

ballardw — Fri, 25 Jun 2021 16:13:02 GMT

@BrahmanandaRao wrote:

proc sql;
select * case when sex='F' then  'Female'
else   'Male'  end as newvar from sashelp.class;
quit;

You did read the log that clearly points out the error didn't you?

215  proc sql;
216  select * case when sex='F' then  'Female'
              ----
              22
              76
ERROR 22-322: Syntax error, expecting one of the following: ',', FROM, INTO.

ERROR 76-322: Syntax error, statement will be ignored.

217  else   'Male'  end as newvar from sashelp.class;
218  quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

The underscores under CASE show where the problem is and the error text says you are missing something like a comma.