topic Re: sas in SAS Programming

Create a blank observation

Ram999 — Tue, 14 Mar 2017 06:06:46 GMT

How to insert a blank observation alternatively or every two observations or specified?

Re: sas

Shmuel — Tue, 14 Mar 2017 05:43:43 GMT

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 ?

Re: Create a blank observation

Reeza — Tue, 14 Mar 2017 06:08:25 GMT

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.

Re: sas

Ram999 — Tue, 14 Mar 2017 07:11:52 GMT

insert a blank observations alternatively or every 2 observations for existed dataset

Re: sas

Shmuel — Tue, 14 Mar 2017 07:19:19 GMT

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.

Re: sas

Ram999 — Tue, 14 Mar 2017 07:21:00 GMT

Thank U very mucH...

Re: sas

RW9 — Tue, 14 Mar 2017 09:28:55 GMT

Please mark @Shmuel's answer as correct.

Re: Create a blank observation

ballardw — Tue, 14 Mar 2017 14:16:33 GMT

Any takers that we will next see a request from OP on how to insert values from another data source into those blank rows?