topic Re: How to change the observation/row order in SAS dataset containing blanks in SAS Programming

How to change the observation/row order in SAS dataset containing blanks

Jannet — Tue, 27 Oct 2020 10:17:49 GMT

Dataset : Have (It contains two blanks observation)

A B C D

1 A 1 1 1

2 B 2 2 2

3 C 2 2 2

4 D 4 5 5

5 E 8 8 8

6 F 8 8 8

8 J 8 8 8

10 K 7 7 7

Dataset, Want

4 D 4 5 5

5 E 8 8 8

6 F 8 8 8

10 K 7 7 7

8 J 8 8 8

1 A 1 1 1

3 C 2 2 2

2 B 2 2 2

Can you please help me in output

Re: How to change the observation/row order in SAS dataset containing blanks

Kurt_Bremser — Tue, 27 Oct 2020 10:28:46 GMT

So what is the rule that guides the re-ordering?

Re: How to change the observation/row order in SAS dataset containing blanks

PeterClemmensen — Tue, 27 Oct 2020 10:31:30 GMT

What is the logic here? Seems like just a random shuffle of the data?

Re: How to change the observation/row order in SAS dataset containing blanks

Jannet — Tue, 27 Oct 2020 10:31:54 GMT

@Kurt_Bremser, there s no such rule...i want to break or give space between few observations. So i added two extra rows with blanks to the dataset but now i am struggling to rearrange as per my requirement

Re: How to change the observation/row order in SAS dataset containing blanks

Jannet — Tue, 27 Oct 2020 10:34:56 GMT

@PeterClemmensen yes...actually this is dummy dataset which i created...i want to give blank line between few observation

Re: How to change the observation/row order in SAS dataset containing blanks

Kurt_Bremser — Tue, 27 Oct 2020 10:37:02 GMT

Then what is the "requirement"?

Keep in mind that coding means algorithm, which is defined as a sequence of clearly defined instructions. Without knowing such instructions, no code can be made.

Re: How to change the observation/row order in SAS dataset containing blanks

PeterClemmensen — Tue, 27 Oct 2020 10:40:48 GMT

I see very little reason to do this. However, see if this helps you...

data want;
   set sashelp.class;
   if _N_ in (5, 10) then do;
      output;
      call missing(of _ALL_);
      output;
   end;
   else output;
run;

Re: How to change the observation/row order in SAS dataset containing blanks

Kurt_Bremser — Tue, 27 Oct 2020 10:41:16 GMT

If you just want a random shuffle, create a random variable, and sort by it:

data have;
infile datalines truncover;
input A $ B C D;
datalines;
A 1 1 1
B 2 2 2 
C 2 2 2
D 4 5 5
E 8 8 8
F 8 8 8
        
J 8 8 8

K 7 7 7
;

data rand;
setbhave;
x = rand('uniform');
run;

proc sort
  data=rand
  out=want (drop=x)
;
by x;
run;

Re: How to change the observation/row order in SAS dataset containing blanks

Jannet — Tue, 27 Oct 2020 10:44:21 GMT

Actually, i am creating demographic table for the first time and got the following output.

so now, i want to rearrange the order of the rows as per the below and give the break between the observations

Thank you

Re: How to change the observation/row order in SAS dataset containing blanks

Kurt_Bremser — Tue, 27 Oct 2020 10:53:43 GMT

Please supply the dataset in your picture in usable form (data step with datalines, do not skip this!), so we can exactly see what is in the data and provide code for that.

Basically, I would create a new group variable that selects the three sub-reports and use a break in PROC REPORT to create the empty space.

In fact, one might be able to do that from the original raw data, so you should include an example for that also.

Re: How to change the observation/row order in SAS dataset containing blanks

ballardw — Tue, 27 Oct 2020 15:41:24 GMT

@Jannet wrote:
@Kurt_Bremser, there s no such rule...i want to break or give space between few observations. So i added two extra rows with blanks to the dataset but now i am struggling to rearrange as per my requirement

Generally not a good idea to create data that way. Such "rows" can seriously affect the results of statistical computations and become very "fragile" when other data manipulation must be done when you get into "do this except for ... rows".

Report procedure can do things like insert blank lines between groups of values IF there can be a rule applied to create the group. Computer code works on rules, not "because I say so". You have to express the rule in terms a computer understands.