How to add discontinued numbers between the gap?

ybz12003 — Thu, 18 Apr 2024 14:42:50 GMT

Hello,

I would like to insert additional numbers between the values in my sample dataset with a 1-unit interval. Please help, thanks.

data HAVE;  
	Format Weekcode 4.0 Test 3.0 Pos 3.0 Lab 4.0; 
	infile datalines delimiter='/'; 
	input Weekcode Test Pos Lab;  
	datalines;                     
2102/ 8/ 3/ 256/
2103/ 3/ 1/ 619/
2106/ 5/ 2/ 2066/
2107/ 3/ 0/ 256/
2110/ 7/ 6/ 619/
;  

data WANT;  
	Format Weekcode 4.0 Test 3.0 Pos 3.0 Lab 4.0; 
	infile datalines delimiter='/'; 
	input Weekcode Test Pos Lab;  
	datalines;                     
2101/ 0/ 0/ 0/
2102/ 8/ 3/ 256/
2103/ 3/ 1/ 619/
2104/ 0/ 0/ 0/
2105/ 0/ 0/ 0/
2106/ 5/ 2/ 2066/
2107/ 3/ 0/ 256/
2108/ 0/ 0/ 0/
2109/ 0/ 0/ 0/
2110/ 7/ 6/ 619/
2111/ 0/ 0/ 0/
2112/ 0/ 0/ 0/
2113/ 0/ 0/ 0/
2114/ 0/ 0/ 0/
2115/ 0/ 0/ 0/
;

Re: How to add discontinued numbers between the gap?

Astounding — Thu, 18 Apr 2024 14:58:36 GMT

Create a data set with all zeros:

data zero ;
Test = 0;
Pos = 0;
Lab = 0;
do weekcode = 2101 to 2115;
output;
end ;
run;

Then merge, making sure to mention the zeros data set first:

data want;
merge zero have;
by weekcode;
run;

topic Re: How to add discontinued numbers between the gap? in SAS Programming

How to add discontinued numbers between the gap?

Re: How to add discontinued numbers between the gap?