topic Why isn't my if then statement working? in SAS Procedures

Why isn't my if then statement working?

aliyahh — Sat, 09 Sep 2017 00:38:24 GMT

I'm just getting started and it's very simple code in SAS University. What am I doing wrong?? I get the following message when I run my if-then statement: ERROR 180-322: Statement is not valid or it is used out of proper order.

*libnames point to the folder that contains the datasets, not the individual datasets;
libname malawi '/folders/myfolders/'; 
*malawi is the name of the folders and mwfemale_pubuse is the name of the dataset;
proc contents data=malawi.mwfemale_pubuse;

*Age groups 13-17 and 18-24;
if 13 <= q2 <= 18 then agegroup= 1;
if 18 <= q2 <=24 then agegroup= 2;

Re: Why isn't my if then statement working?

SASKiwi — Sat, 09 Sep 2017 01:27:36 GMT

Try this:

data want;
  set malawi.mwfemale_pubuse;
if 13 <= q2 <= 18 then agegroup= 1;
if 18 <= q2 <=24 then agegroup= 2;
run;

Re: Why isn't my if then statement working?

MINX — Sat, 09 Sep 2017 02:28:56 GMT

@aliyahh IF statement can not be used in CONTENTS procedure. The CONTENTS procedure shows the contents of a SAS data set and prints the directory of the SAS library. If you want to do conditional derivation for agegroup, @SASKiwi gave you the best approach in DATA step.

Re: Why isn't my if then statement working?

Reeza — Sat, 09 Sep 2017 03:19:19 GMT

Always end your PROC/DATA STEP with a RUN (or quit).

When creating new variables you need to explicitly tell SAS both what data set you're working with and what you're trying to create. This occurs within a DATA STEP.

DATA <New>;

SET <source>;

code to do stuff goes here - like if/then;

run;

I believe theres a free ecourse available as well as numerous videos here

http://video.sas.com/#category/videos/how-to-tutorials

Re: Why isn't my if then statement working?

PGStats — Sat, 09 Sep 2017 04:38:09 GMT

Note: avoid making ambiguous age group definitions (as it is in your example for q2=18)

*Age groups 13-17 and 18-24;
if 13 <= q2 < 18 then agegroup= 1;
if 18 <= q2 <= 24 then agegroup= 2;

Re: Why isn't my if then statement working?

aliyahh — Sat, 09 Sep 2017 21:04:35 GMT

Thanks everyone!