topic Getting this error message: Statement is not valid or it is used out of proper order. in SAS Programming

Getting this error message: Statement is not valid or it is used out of proper order.

khalillx — Fri, 22 Feb 2019 22:21:32 GMT

Anyone know what's wrong with my code that I'm getting this error message in my log?:

15 PCE0 = PCE/6712.166667;
----
180

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

116 RGAS = Price/PCE0;
----
180

So I have to find the real price of gas and I found the average price of my deflator in my excel file of the year 2000 which is my base year which turned out to be 6712.166667. I was given this code to use to create my new variable of the real price of gas but it's not working. I have never done this before so I'm not sure what to do. Here is my code getting the error message:

PCE0 = PCE/6712.166667;
RGAS = Price/PCE0;

This is my full code:

ODS LISTING;
libname session1 "x";

PROC IMPORT OUT= WORK.one
DATAFILE="x"
DBMS=csv REPLACE;
RUN;

proc print data= WORK.one;
run;

proc contents;
run;

PCE0 = PCE/6712.166667;
RGAS = Price/PCE0;

I hid my pathway.

Re: Getting this error message: Statement is not valid or it is used out of proper order.

Reeza — Fri, 22 Feb 2019 22:18:26 GMT

You have to post the full code and log, not just the error. That being said, I'll bet the error is actually before that line, and is a missing semicolon again.

Re: Getting this error message: Statement is not valid or it is used out of proper order.

khalillx — Fri, 22 Feb 2019 22:20:06 GMT

You want my full log? That's a lot of information. I copied my code exactly from my professor so I doubt it's that.

Re: Getting this error message: Statement is not valid or it is used out of proper order.

VDD — Fri, 22 Feb 2019 22:30:16 GMT

Maxims of Maximally Efficient SAS Programmers
https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers/ta-p/352068

How to convert datasets to data steps
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

The macro for direct download
https://gist.githubusercontent.com/statgeek/bcc55940dd825a13b9c8ca40a904cba9/raw/865d2cf18f5150b8e887218dde0fc3951d0ff15b/data2datastep.sas

How to post code
https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Re: Getting this error message: Statement is not valid or it is used out of proper order.

Reeza — Fri, 22 Feb 2019 22:37:24 GMT

You can't access variables like that. To create a new variable it needs to be within a data step.

You're essentially creating new variables.

Here's a video tutorial that covers the topic:

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

And yes, you need to provide enough code and the log for us to help you. Posting partial code hides the issues, especially when it's something as big as not using a data step.

@khalillx wrote:

Anyone know what's wrong with my code that I'm getting this error message in my log?:

15 PCE0 = PCE/6712.166667;
----
180

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

116 RGAS = Price/PCE0;
----
180

So I have to find the real price of gas and I found the average price of my deflator in my excel file of the year 2000 which is my base year which turned out to be 6712.166667. I was given this code to use to create my new variable of the real price of gas but it's not working. I have never done this before so I'm not sure what to do. Here is my code getting the error message:

PCE0 = PCE/6712.166667;
RGAS = Price/PCE0;

This is my full code:

ODS LISTING;
libname session1 "x";

PROC IMPORT OUT= WORK.one
DATAFILE="x"
DBMS=csv REPLACE;
RUN;

proc print data= WORK.one;
run;

proc contents;
run;

PCE0 = PCE/6712.166667;
RGAS = Price/PCE0;

I hid my pathway.