If reading a variable length file with fixed input, how
would you prevent SAS from reading the next record if the
last variable didn?t have a value?
- 6 Answers
- 15354 Views
- I also Faced
- E-Mail Answers
Answer Posted / ade
Use the MISSOVER keyword; it forces SAS to put either a
blank or a period for the missing variable before continuing
to the next record.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are the different operating system platforms in which we can use sas? : sas-grid-administration
is data integration and etl programming is same? : Sas-di
what is broad cast agent? : Sas-bi
how sas deals with business intelligence? : Sas-bi
What is the function of Stop statement in a SAS Program?
Name validation tools used in SAS
what are all the reports you generated in your recent project?
What are the statements in proc sql?
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 is the use of %include statement?
What is the role of unrestrictive users? : sas-grid-administration
Have you used macros? For what purpose you have used? : sas-macro
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
explain what is factor analysis? : Sas-administrator
How do dates work in sas?
