topic Re: How to expand a SAS dataset in SAS Programming

How to expand a SAS dataset

UdayGuntupalli — Wed, 25 Jul 2018 21:40:43 GMT

All,
I am looking to understand how to expand a SAS dataset ? So, let us look at the following example

Data Test; 
	set Sashelp.timedata(obs = 3); 
Run;

The above would yield the following :

Now, let us say i would like to define the values over the next 3 time intervals and I want something like this:

In this example, volume has the relation of being 1.5 times of the previous rows and the the datetime is just uniform with 30 minute interval.

Re: How to expand a SAS dataset

PaigeMiller — Wed, 25 Jul 2018 21:44:49 GMT

Well, I don't think your math is right regarding multiplying by 1.5 ... however in general this should work ... by adding 30*60 to the datatime, that's 30 minutes converted to seconds (by multiplying by 60).

data test.
    set sashelp.timedata(obs=3) end=eof;
    output;
    if eof then do 1 = 1 to 3;
         volume=volume*1.5;
         datetime=datetime+30*60;
         output;
    end;
run;

Re: How to expand a SAS dataset

UdayGuntupalli — Wed, 25 Jul 2018 21:50:22 GMT

@PaigeMiller,
Thank you. When I dragged the formula over in Excel for the screenshot, I believe it got incremented. However, I get the idea of what you are proposing. I noticed a few errors in the code you provided:

data test; * This i believe is not a period and a semicolon; 
    set sashelp.timedata(obs=3) end=eof;
    output;
    if eof then do i = 1 to 3;   *I don't think this is 1 = 1 to 3 but i = 1 to 3; 
         volume=volume*1.5;
         datetime=datetime+30*60;
         output;
    end;
run;

Assuming this is what you were recommending, it works.

Re: How to expand a SAS dataset

PaigeMiller — Wed, 25 Jul 2018 21:56:28 GMT

That's it!