data task;
input id date date9. visit;
cards;
101 01jan2015 1
101 02jan2015 2
101 06jan2015 3
102 04jan2015 1
102 07jan2015 2
102 12jan2015 3
103 06jan2015 1
103 13jan2015 2
;
run;
write a program to find out missing dates between visits by each subject.
data task;
input id date date9. visit ;
cards;
101 01jan2015 1
101 02jan2015 2
101 06jan2015 3
102 04jan2015 1
102 07jan2015 2
102 12jan2015 3
103 06jan2015 1
103 13jan2015 2
;
run;
Answer
data task1;
set task;
by id;
date1=lag(date);
if first.id ne 1 then x=date-date1;
run;
proc print; run;
proc transpose data = task out = b;
var date;
by id;
run;
data new;
set b;
x=col2-col1;
y=col3-col2;
run;
proc print; run;
Is This Answer Correct ? | 0 Yes | 0 No |
what is the function of catx syntax? : Sas-administrator
Describe the ways in which you can create macro variables?
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
how will you locate the sas platform applications? : Sas-bi
Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.
what are input dataset and output dataset options? : Sas programming
what is sas and what are the functions? : Sas-administrator
How do you connect the desktop application to metadata server? : sas-grid-administration
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
Explain the difference between using drop = data set option in set and data statement?
How would you remove a format that has been permanently associated with a variables?