topic Re: Missing Function in New SAS User

Missing Function

BrahmanandaRao — Sat, 01 Jun 2019 08:57:30 GMT

Hi Experts Good Morning

Here my dataset using Missing function both numeric and character flag variable like slno missing course_name missing

data miss_var;
input slno course_name$ 12.;
if missing(course_name) then do ;
put 'course_name  is missing.' ;
end;
else if missing(id) then do;
put 'slno  is missing.'; 
end;
datalines;
001 java
002 c++
003 javascript
    node js
005 
    pandas
;

run;

Re: Missing Function

BrahmanandaRao — Sat, 01 Jun 2019 13:45:47 GMT

Please give solution

Re: Missing Function

VDD — Sat, 01 Jun 2019 14:07:37 GMT

@BrahmanandaRao are you sure that this line of code works"

input slno course_name$ 12.;

Re: Missing Function

Astounding — Sat, 01 Jun 2019 14:09:12 GMT

You are reading in your data incorrectly. If you run a PROC PRINT, you will see that. This INPUT statement would come closer to the mark:

input slno 1-3 coursename $ 5-16;

You might want to consider making SLNO number character, if you want to keep those leading zeros.

Re: Missing Function

anushreebiotech — Sat, 01 Jun 2019 15:43:33 GMT

Hi,

data miss_var;
input slno $ course_name $;
if missing(course_name) then do ;
check= 'course_name is missing.' ;
end;
else if missing(slno) then do;
check= 'slno is missing.';
end;
datalines;
001 java
002 c++
003 javascript
. node js
005 .
. pandas
;
run;