DATA Step, Macro, Functions and more

Month() kicking back error

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Month() kicking back error

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.
 

Accepted Solutions
Solution
‎03-02-2018 12:06 AM
Super User
Posts: 24,026

Re: Month() kicking back error

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;

View solution in original post


All Replies
Super User
Posts: 24,026

Re: Month() kicking back error

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.
 

 

New Contributor
Posts: 4

Re: Month() kicking back error

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.
 
Solution
‎03-02-2018 12:06 AM
Super User
Posts: 24,026

Re: Month() kicking back error

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;
New Contributor
Posts: 4

Re: Month() kicking back error

Worked perfectly, thank you!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 129 views
  • 0 likes
  • 2 in conversation