Answer Posted / akhil

If I am having a data set c
data test;
input c $ 20.;

cards;
123 456
217 236
456235
225 5665
55
77 85
46556
4588 56
;
run;
proc print;
run;

Now I am going to fetch observation having space in between,

data e(drop=e t);
set test;
e=length(c);
t=find(c,'');
if e>t;
run;
proc print data=e;
run;

How do you test for missing values?

1593

---

How will you generate test data with no input data?

1139

---

What are the functions used for character handling?

1212

---

is data integration and etl programming is same? : Sas-di

1041

---

what is sas metadata server? : Sas-di

1074

---

Mention what is SAS data set?

1111

---

do you need to know if there are any missing values? : Sas programming

1015

---

Can you execute a macro within a macro? Describe. : sas-macro

1083

---

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4546

---

Which date function advances a date, time or datetime value by a given interval?

1113

---

What is the difference between SAS functions and procedures?

1120

---

how does sas handle missing values in procs? : Sas programming

1194

---

what is sas and what are the functions? : Sas-administrator

951

---

How do you use the do loop if you don’t know how many times you should execute the do loop?

1239

---

What are the five ways to do a table lookup in sas? : sas-grid-administration

1023

---