topic Re: What am I lacking in understanding? simple Data Step problem.. in New SAS User

What am I lacking in understanding? simple Data Step problem..

TimmySauce — Wed, 20 Mar 2019 17:07:25 GMT

Here is my code:

data school;
input age quiz : $1. midterm final;
datalines;
12 A 92 95
12 B 88 88
13 C 78 75
13 A 92 93
12 F 55 62
12 B 88 82
;
RUN;

data newschool;
infile school;
input age quiz : $1 midterm final;
if age = 12 then grade = 6;
else if age =13 then grade = 8;
run;

The error I get is:

ERROR: No logical assign for filename SCHOOL.

I don't really understand the difference between 'set' and 'infile'. It seems I have a fundamental misunderstanding of what is going on, so I'd like to clear it up.

Re: What am I lacking in understanding? simple Data Step problem..

PaigeMiller — Wed, 20 Mar 2019 17:13:53 GMT

Once you have created the data set named SCHOOL, to use it in another data step, you use SET.

If you want to read data from a text (or csv or similar) file, then you use INFILE.

Re: What am I lacking in understanding? simple Data Step problem..

TimmySauce — Wed, 20 Mar 2019 17:41:27 GMT

So, I changed 'infile' to 'set' and got this error:

No DATALINES or INFILE statement

data school;
input age quiz : $1. midterm final;
if age = 12 then grade = 6;
else if age =13 then grade = 8;
datalines;
12 A 92 95
12 B 88 88
13 C 78 75
13 A 92 93
12 F 55 62
12 B 88 82
;
RUN;

data newschool;
set school;
input age quiz : $1 midterm final;
if age = 12 then grade = 6;
else if age =13 then grade = 8;
run;

Re: What am I lacking in understanding? simple Data Step problem..

Astounding — Wed, 20 Mar 2019 17:47:13 GMT

This isn't what you asked, but it's something you need to know. You don't need two DATA steps. You can move the IF THEN logic to just before the DATALINES statement in your first DATA step.

Re: What am I lacking in understanding? simple Data Step problem..

Cynthia_sas — Wed, 20 Mar 2019 17:47:41 GMT

Hi, When you use a SET Statement, the INPUT statement is not required. All the variables you created in the first program are all available to you in the second program just based on the SET statement. This is one of the benefits of using a SET statement -- you do not have to "redefine" or "re-read" the variables.
Cynthia

Re: What am I lacking in understanding? simple Data Step problem..

PaigeMiller — Wed, 20 Mar 2019 18:04:32 GMT

When you use SET, you usually won't also do an INPUT. You already did the INPUT for data set SCHOOL when it was created, so you don't need another INPUT to use data set SCHOOL.

Re: What am I lacking in understanding? simple Data Step problem..

ballardw — Wed, 20 Mar 2019 21:09:32 GMT

@Astounding wrote:
This isn't what you asked, but it's something you need to know. You don't need two DATA steps. You can move the IF THEN logic to just before the DATALINES statement in your first DATA step.

Having seen code where people created a dozen or so data sets each adding a single variable (and then getting lost later as to which set to use) I heartily agree with this.