topic Re: base sas question in SAS Enterprise Guide

base sas question

u59166072 — Fri, 26 Jul 2024 11:59:52 GMT

Data ds;
Infill datalines;
Input id name$;
Cards;
1 aa
2 bb
3 cc
Run;

required

Output:
1 aa
1 aa
2 bb
2 bb
2 bb
3 cc
3 cc
3 cc
3 cc

could you please help this .

Re: base sas question

PaigeMiller — Fri, 26 Jul 2024 12:07:01 GMT

data want;
    set ds;
    if name='aa' then do;
        output; output;
    end;
    else if name='bb' then do;
        output; output; output;
    end;
    else if name='cc' then do;
        output; output; output; output;
    end;
run;

PS: in the future, and for this problem as well, it would help if you actually described the problem in words and also described in words the logic that leads to the solution desired.

Re: base sas question

u59166072 — Fri, 26 Jul 2024 12:35:55 GMT

Hi @PaigeMiller , thaks for providing answer and is there any other ways to make automate by using macro orelse program in base sas.

Re: base sas question

PaigeMiller — Fri, 26 Jul 2024 12:50:24 GMT

As I said, please explain in words the problem, and please explain in words the logic you want to use to get the final answer. Do not make us guess what logic you want.

Re: base sas question

u59166072 — Fri, 26 Jul 2024 13:14:54 GMT

ya thank you Paige.

Re: base sas question

PaigeMiller — Fri, 26 Jul 2024 13:41:12 GMT

It would be much more helpful if you explained the logic here. We could give you more useful answers then. Specifically, what is the reason aa appears twice and bb appears three times and cc appears 4 times?

Re: base sas question

ballardw — Fri, 26 Jul 2024 14:46:47 GMT

@u59166072 wrote:

Hi @PaigeMiller , thaks for providing answer and is there any other ways to make automate by using macro orelse program in base sas.

SAS macros generate program code.

Programs implement rules.

Without knowing the actual rules examples are insufficient.

Consider these two other possible "solutions".

This one implements a rule of "create one more observation in the output than the numeric value of Id".

/* one more output observation than the value of id*/
data example1;
   set ds;
   output;
   do i= 1 to id;
      output;
   end;
   drop i;
run;

Looks the same. But is that actually the "rule"? Since many things that use numeric ids could have relatively large numeric values that seems unlikely to be generating 123,456,789 copies of one observation.

So how about this:

The rule implemented here is "use the observation (row) number in the source data set and create one more duplicate than number".

/*based on observation number in the data set*/
data example2;
  set ds;
  do i=1 to _n_+1;
     output;
  end;
  drop i ;
run;

That seems like an unlikely need if there are very many observations. That would create a total of (n *(n+1)/2) + n observations where n is the original number of obs in the source data set

@PaigeMiller 's solution implements the rule "if the specific value of name is aa then one additional observation, if bb then two additional observations and if cc three additional observations". Nothing else. No other values of Name would result in any output observations. Is that the actual rule?

Without clear rules then a solution based on a small example may very well not even come close to providing the desired result for a larger data set.

Re: base sas question

PaigeMiller — Fri, 26 Jul 2024 14:56:00 GMT

I could envision even more rules than what @ballardw explained. This is clearly not a real-world example, it is so contrived that we can't guess what the real-world usage of this code would be. So we ask questions to help us give better answers.

Re: base sas question

Astounding — Fri, 26 Jul 2024 15:29:23 GMT

Since you're not sure what the problem is, here's my guess. The intent is to output the original observation, then look at ID and output it that many additional times. So the program could be:

data want;
   set ds;
   output;
   do _n_ = 1 to id;
      output;
   end;
run;