Month() kicking back error

[nelsondn]

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.

[Reeza]

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.

---

[nelsondn]

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.

[Reeza · Accepted solution]

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?...

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;

[nelsondn]

Worked perfectly, thank you!