I want to add continuous dates in the column 'Date' for each of unique value in the column 'V1'. And below explains what I am doing and what error i am getting (unable to impute dates).
I have a table as shown below:
V1 Date
MS000328 04JAN16
MS000328 08JAN16
MS000328 12JAN16
MS000328 08FEB16
MS000328 09FEB16
MS000328 12MAR16
MS000328 15MAR16
MS000328 16APR16
MS000328 17APR16
MS000329 02JAN16
MS000329 16JAN16
MS000329 29JAN16
MS000329 03FEB16
MS000329 19FEB16
MS000329 21MAR16
MS000329 31MAR16
MS000329 11APR16
MS000329 19APR16
What I want something like this:
V1 Date
MS000328 01JAN16
MS000328 02JAN16
MS000328 03JAN16
MS000328 04JAN16
MS000328 05JAN16
MS000328 06JAN16
MS000328 07JAN16
MS000328 08JAN16
.
.
.
.
.
MS000329 01JAN16
MS000329 02JAN16
MS000329 03MAR16
.
.
MS000329 01APR16
MS000329 02APR16
.
.
MS000329 01MAR16
MS000329 02MAR16
.
.
MS000329 01APR16
MS000329 02APR16
.
.
.
I am using the follwing code....
data want1 (keep = V1 Date);
set have;
by V1;
run;
data want;
set want1;
format Date date.;
Date = "1JAN2016"d;
do i = 0 to 365;
Date+1;
output;
end;
run;
The result log shows an error... 'Insufficient space in file'
What I did as wrong?