Dataset – Ryslander.com

Making an empty dataset in SAS

The code below shows you how to make an empty dataset in SAS.
If you omit the if-sentence and below, then you will get an empty row in the dataset.

data StatusTable;
 length Dataset $100 Message $150 Status $10;
 call missing(Dataset, Message, Status);
 if _N_ = 0 then output;
 stop;
run;

This can also be done a bit easier in SQL.

proc sql noprint;
create table Dataset
(
Dataset char 100,
Message char 150,
Status char 10
);
quit;

The code below will makes it possible to truncate (empty) an existing SAS-dataset.

data SASDataset;
  if (0=1);
run

The code below will give you a random sample of a large dataset. The random sample will contain 25% randomly selected rows from the large dataset.

data Libname.RandomDataset;
set Libname.LargeDataset;
if ranuni(123456789) <= .25;
run;