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:
![Screenshot 2022-06-10 at 12.14.20 PM.png Screenshot 2022-06-10 at 12.14.20 PM.png](https://communities.sas.com/t5/image/serverpage/image-id/72141iB632C7F18F0E1900/image-size/medium?v=v2&px=400)
![Screenshot 2022-06-10 at 12.14.31 PM.png Screenshot 2022-06-10 at 12.14.31 PM.png](https://communities.sas.com/t5/image/serverpage/image-id/72142i52F8DD1984089AC8/image-size/medium?v=v2&px=400)