topic Re: I am new to SAS and unable to find a solution for this error. Please help. in SAS Software for Learning Community

I am new to SAS and unable to find a solution for this error. Please help.

Sharath19 — Fri, 10 Jun 2022 17:50:02 GMT

Re: I am new to SAS and unable to find a solution for this error. Please help.

Reeza — Fri, 10 Jun 2022 18:06:24 GMT

Post your code as text really helps.

Your order of statements in the code:

Create a file reference to your Excel file - note this does not import file, just creates a pointer to the file
INFILE statement - not in data step, does nothing
INPUT statement - not in data step, does nothing
PRINT data - no data read in
Plot data - but no data has been read in
Import Excel file and save it as IMPORT1
Display contents of Import1 data set
Opens Import1 table to view it.

FYI - adding comments to your code as to what you think each line does (as above helps you avoid these errors.

Excel files are imported using PROC IMPORT.

To resolve:

Remove steps 2/3

Move steps 6/7/8 to after step 1.

In the future please post your code as text not images.

@Sharath19 wrote:

Re: I am new to SAS and unable to find a solution for this error. Please help.

Reeza — Fri, 10 Jun 2022 18:07:24 GMT

And whatever tutorial you're using is old, I'd highly recommend finding a newer one. GPLOT is not recommended these days. SAS offers free introductory training classes on it's official training page.

Re: I am new to SAS and unable to find a solution for this error. Please help.

tom_grant — Fri, 10 Jun 2022 18:13:47 GMT

Delete lines 10 & 11
Move lines 12-15 after line 26

This should get your program to run & produce a listing of data & a scatterplot of minutes vs num_mach