topic How to modify a data set by deleting observations in SAS Programming

How to modify a data set by deleting observations

Stacy — Mon, 14 Jan 2019 18:22:12 GMT

How can I modify a data set by deleting the ith observation for every patient i.

Also,how can I build the model and output the estimated values, and save the predicted values of a variable belonging to an ith patient.

The question says dont use macro.

I have no idea on how to approach this.

It also says using cross validation method.

I attached an image of my data set

Re: How to modify a data set by deleting observations

Reeza — Mon, 14 Jan 2019 18:26:02 GMT

https://video.sas.com/detail/video/4573016761001/filtering-a-sas-table-in-a-data-step?autoStart=true&q=filter

https://video.sas.com/detail/video/4414728579001/filter-and-sort-data?autoStart=true&q=filter

https://video.sas.com/detail/video/4664331677001/using-the-filter-data-task-in-sas-studio?autoStart=true&q=filter

For simulations I highly recommend reading the paper,

http://www.sascommunity.org/wiki/Don%27t_Be_Loopy:_Re-Sampling_and_Simulation_the_SAS%C2%AE_Way

And here is some instructions for turning a program into a macro:

https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

This is homework, so I strongly suggest you make an attempt first at all of this, do you have the 'base case' built, ie your regression code? If not, the statistics e-course is free or UCLA has many tutorials on their page.

@Stacy wrote:

How can I modify a data set by deleting the ith observation for every patient i.

Also,how can I build the model and output the estimated values, and save the predicted values of a variable belonging to an ith patient.

The question says dont use macro.

I have no idea on how to approach this.

It also says using cross validation method.

I attached an image of my data set

Re: How to modify a data set by deleting observations

Stacy — Mon, 14 Jan 2019 18:31:29 GMT

Here is my regression code

proc reg data=epilepsy;
   model rate = Age Treatment Period/ p MSE;
   output out = predicted p = yhat r = yresid;
run;

Re: How to modify a data set by deleting observations

Reeza — Mon, 14 Jan 2019 18:34:11 GMT

I don't think you're intended to use that data set. You need to use the data that's been filtered and set out to once a week - ie the data from a previous step in your assignment.