How to insert a blank observation alternatively or every two observations or specified?
Try next code;
data want;
set have;
output;
if mod(_N_,2) = 0 then do;
call missing(_ALL_);
output;
end;
run;
change the MOD() 2nd argument to insert blank observation as desired.
The tool to enter a blank observation depends on your source and target -
is it a dataset or a report ? do you have ID (key) variables?
and - why do you want to insert the blank observation? what is the goal ?
insert a blank observations alternatively or every 2 observations for existed dataset
Try next code;
data want;
set have;
output;
if mod(_N_,2) = 0 then do;
call missing(_ALL_);
output;
end;
run;
change the MOD() 2nd argument to insert blank observation as desired.
Thank U very mucH...
Please mark @Shmuel's answer as correct.
Depends.
Using a do loop op with an explicit output statement and CALL MISSING() is easier option for a dataset. If it's a report there are other options. I suggest you expand upon what you're looking to accomplish.
Any takers that we will next see a request from OP on how to insert values from another data source into those blank rows?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.