topic Re: How do I use "set" to create a temporary dataset in SAS Programming

How do I use "set" to create a temporary dataset

EricB40 — Sun, 01 Oct 2023 21:06:32 GMT

Hi everyone

I used this code to create a dataset called HOSP

data hosp;

do j = 1 to 1000;

AdmitDate = int(ranuni(1234)*1200 + 15500);

quarter = intck('qtr','01jan2002'd,AdmitDate);

do i = 1 to quarter;

if ranuni(0) lt .1 and weekday(AdmitDate) eq 1 then

AdmitDate = AdmitDate + 1;

if ranuni(0) lt .1 and weekday(AdmitDate) eq 7 then

AdmitDate = AdmitDate - int(3*ranuni(0) + 1);

DOB = int(25000*Ranuni(0) + '01jan1920'd);

DischrDate = AdmitDate + abs(10*rannor(0) + 1);

Subject + 1;

output;

end;

drop i j;

format AdmitDate DOB DischrDate mmddyy10.;

run;

How do I create a temporary dataset called HOSP2 using "set"? I tried this:

data hosp;
set hosp2;
do j = 1 to 1000;
AdmitDate = int(ranuni(1234)*1200 + 15500);
quarter = intck('qtr','01jan2002'd,AdmitDate);
do i = 1 to quarter;
if ranuni(0) lt .1 and weekday(AdmitDate) eq 1 then
AdmitDate = AdmitDate + 1;
if ranuni(0) lt .1 and weekday(AdmitDate) eq 7 then
AdmitDate = AdmitDate - int(3*ranuni(0) + 1);
DOB = int(25000*Ranuni(0) + '01jan1920'd);
DischrDate = AdmitDate + abs(10*rannor(0) + 1);
Subject + 1;
output;
end;
end;
drop i j;
format AdmitDate DOB DischrDate mmddyy10.;
run;

proc print data=hosp2;
run;

But it did not work. Does anyone know how to fix this?

Re: How do I use "set" to create a temporary dataset

malorygraybush — Sun, 01 Oct 2023 21:25:34 GMT

Documentation for the SET statement (https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsref/p00hxg3x8lwivcn1f0e9axziw57y.htm) describes that SET is used to read observations, not to create a data set.

What is your definition of a "temporary data set?" A common working definition is a "data set not saved when the SAS session terminates," and these "temporary data sets" can be created in the WORK library, as its contents are not saved across (or after) SAS sessions. Whenever a data set is created (or otherwise referenced), and no SAS library is explicitly denoted (in dot notation like LIBRARY.DATASET), then the WORK library is applied by default (i.e., WORK.DATASET).

For example, your Hosp data set is temporary because no library is specified when Hosp is created, so the data set you have created is WORK.Hosp.

Thus, to create a temporary data set Hosp2, you need to only need to reference Hosp2 in the DATA statement:

data Hosp2;

Re: How do I use "set" to create a temporary dataset

EricB40 — Sun, 01 Oct 2023 21:26:34 GMT

You are a saint. Thank you.