topic Re: create single observation datasets using macro do loops in SAS Programming

create single observation datasets using macro do loops

BrahmanandaRao — Wed, 05 Apr 2023 06:58:59 GMT

/* create 19 datasets with number */
%macro creatdatasets(ds);
%do i=1 %to 19 ;
if _n_=i then do;
data _&i.;
output;
%end;
%mend;
%put createdataset(sashelp.class);

Here i want to create 19 datasets each dataset has to be single observations using do loops macro

Re: create single observation datasets using macro do loops

andreas_lds — Wed, 05 Apr 2023 07:12:26 GMT

And what exactly is your problem with the task?

Re: create single observation datasets using macro do loops

BrahmanandaRao — Wed, 05 Apr 2023 07:18:50 GMT

Here i am trying to create 19 datasets each dataset should be single observarion

ex ds_1 contains name sex age height weight

.............

ds_19

Re: create single observation datasets using macro do loops

Kurt_Bremser — Wed, 05 Apr 2023 08:02:12 GMT

Is this homework?

If yes, start by having working non-macro code which creates one dataset as wanted. Post this code.

If not, I seriously question the need for splitting.

Re: create single observation datasets using macro do loops

andreas_lds — Wed, 05 Apr 2023 08:02:21 GMT

Try to create one dataset with one obs without any macro-statement. Then identify the statements that need to be dynamic and start replacing.

Re: create single observation datasets using macro do loops

BrahmanandaRao — Wed, 05 Apr 2023 10:37:56 GMT

yes its homework could you please give solution

Re: create single observation datasets using macro do loops

PaigeMiller — Wed, 05 Apr 2023 11:08:16 GMT

Why would you (or anyone) want many different data sets each with one observation, rather than one large data set with all observations? Many data sets with one observation each will be a nightmare to work with, compared to everything in one large data set.

If this is homework, then shame on your instructor for asking you to do something that likely will never be needed.

Re: create single observation datasets using macro do loops

LinusH — Wed, 05 Apr 2023 11:12:38 GMT

First of all, you need a SET statement so you have something to create new data sets from.

Re: create single observation datasets using macro do loops

Kurt_Bremser — Wed, 05 Apr 2023 13:06:11 GMT

@BrahmanandaRao wrote:
yes its homework could you please give solution

Homework is intended to test your skills, not ours. It is really time now that you start using the most important tool you were given at birth. It sits between your ears and is called a brain.

And I have already given you the path to the solution: start with working code for one output file. If, after 4 years and 600 posts here, you still cannot get that extremely simple part done, you have to face the fact that you just haven't got what it takes to work with SAS. Find another endeavor which fits your capabilities.