BookmarkSubscribeRSS Feed
Prateek1
Obsidian | Level 7

hi,

 

The data set WORK.CAR_SALES2 may be incomplete. When this step was stopped there were 0
observations and 1 variables.

i am geeting this error in log window ?

what should i do ?

this is my code :

DATA car_sales2;
set=Prateek.car_sales;
if_4_year_resale value is missing or Price_in_thousands is missing then delete;
run;

 

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

This line is invalid SAS syntax:

if_4_year_resale value is missing or Price_in_thousands is missing then delete;

 

You are missing a space after the if, the word value appears incorrectly.  You have not used the missng function correctly. Maybe something like:

if missing(_4_year_resale_value) or missing(price_in_thousands) then delete;

Astounding
PROC Star

One more item you need to correct, even if it did not generate an error message:  the SET statement does not use an equal sign.  The correct version:

 

set Prateek.car_sales;

 

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1227 views
  • 0 likes
  • 3 in conversation