topic Month() kicking back error in SAS Programming

Month() kicking back error

nelsondn — Fri, 02 Mar 2018 04:41:44 GMT

I am attempting to use the month() function to extract the month from a date variable formatted as MONYY7 read from an xlsx file. It is returning the following error:

num_mon = month(date);

_______

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: Month() kicking back error

Reeza — Fri, 02 Mar 2018 04:52:29 GMT

Where's the rest of the code?

Post the log and error as well please.

@nelsondn wrote:

I am attempting to use the month() function to extract the month from a date variable formatted as MONYY7 read from an xlsx file. It is returning the following error:

num_mon = month(date);

_______

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: Month() kicking back error

nelsondn — Fri, 02 Mar 2018 04:57:13 GMT

The code:

options ls=78 formdlim='*';
ods listing;
proc import OUT= work.one
DATAFILE= "/home/nelsondn0/sasuser.v94/Gasoline.xlsx" DBMS=XLSX REPLACE; GETNAMES=YES;
run;

num_mon = month(date);

Log and error:

num_mon = month(date);

_______

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: Month() kicking back error

Reeza — Fri, 02 Mar 2018 05:01:18 GMT

Ok, that's not how you create a new variable.

If you want to calculate a month you need to create a new variable within a data step.

See a tutorial here or the code below:

http://video.sas.com/detail/videos/sas-analytics-u/video/4573023399001/creating-a-new-column-in-sas?autoStart=true

data calculate_month; *create a new data set called calculate_month;
set one; *data set imported in previous step;

month_num = month(date); *calculate month;

run;

Re: Month() kicking back error

nelsondn — Fri, 02 Mar 2018 05:07:03 GMT

Worked perfectly, thank you!