topic Re: Creating a new variable in a datalines step in SAS Programming

Creating a new variable in a datalines step

aditya10 — Mon, 13 May 2019 16:29:38 GMT

This works :

data xy;
input a  b ;
z=a/b;
datalines ;
123 123
123 456
123 234
;
run;

but this does not :

data xy;
input a  b ;
datalines ;
123 123
123 456
123 234
;
z=a/b;
run;

Can someone tell me why ? What's going on in the back-end ?

Re: Creating a new variable in a datalines step

Reeza — Mon, 13 May 2019 16:34:16 GMT

The last semicolon after a datalines/cards statement indicates the end of the data step (you don't need the RUN) and since the data step is terminated, the calculation doesn't make sense because you're now in 'open code' with no data reference. This behaviour is noted in the documentation.

Re: Creating a new variable in a datalines step

Tom — Mon, 13 May 2019 16:38:54 GMT

You cannot calculate a new variable after the data step has already been compiled and run.

What is confusing you is the spurious RUN: statement in your first example. That is NOT part of the data step.

Another reason to not add that spurious RUN; statement after the end of a data step that is reading in-line data when posting example code. Besides wasting a line in your program file It will confuse novice programmers.

Re: Creating a new variable in a datalines step

Kurt_Bremser — Tue, 14 May 2019 12:22:00 GMT

From the documentation of the DATALINES Statement:

Using the DATALINES Statement

The DATALINES statement is the last statement in the DATA step and immediately precedes the first data line. Use a null statement (a single semicolon) to indicate the end of the input data.

(emphasis by me)

That's why Maxim 1 is Maxim ONE.