How many missing values are available? When might you use them?
Answer Posted / ankit
Two types of missing values are there we come across in SAS:
1. Dot(.)
2. Blank
Dot will be used for as the numerical type of missing value.
and
Blank will be treated as the character type of missing value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how many display types available in sas bi dashboard? : Sas-bi
How do you delete duplicate observations in sas?
What is the basic syntax of a sas program?
what is treatment emergent events and treatment emregent adverse event
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
what are sas/access and sas/connect? : Sas programming
how many types of prompts are there? : Sas-bi
what are some differences between proc summary and proc means? : Sas programming
What are the prime responsibilities of data integration administrator? : Sas-di
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What are the automatic variables for macro? : sas-macro
what are the benefits of data integration? : Sas-di
How long can a macro variable be? A token? : sas-macro
why is a stop statement needed for the point=option on a set statement? : Sas programming
What is the basic structure of the SAS base program?