topic Re: How to add extra row in SAS Programming

How to add extra row

sasuser123123 — Tue, 31 Aug 2021 16:12:18 GMT

Hi Everyone.

I have a data like..

Data new;
Input visit $ stats$ ;
cards;
baseline n
baseline mean
baseline sd
baseline min
visit1 n
visit1 mean
visit1 sd
visit1 min
visit2 n
visit2 mean
visit2 sd
visit2 min
;
run;
I want to add one extra row and want some changes like visit and stats should comes under a single variable as shown in below .
My output should like..
new visit stats
Baseline analysis
n baseline n
mean baseline mean

sd baseline sd
min baseline min
Analysis at visit1
n visit1 n
mean visit1 mean
sd visit1 sd
min visit1 min
Analysis at visit2
n visit2 n
mean visit2 mean
sd visit2 sd
min visit2 min

Could anyone help me out how to get it.. Please ignore any spelling mistakes and alignment. I typed in mobile
Thank you

Re: How to add extra row

ballardw — Tue, 31 Aug 2021 15:59:19 GMT

What content in the data set tells us where to insert rows? Rules for the content of the "row".

What specific variable is to contain that text? How long is that variable defined to be? If you try to stick more than 8 letters into a variable defined as length 8 it just won't fit.

And lastly, how do you expect to use this data set? Inserting random text often is not the way to work in SAS and combining multiple values into a single variable is quite often very much harder to do anything with.

Re: How to add extra row

sasuser123123 — Tue, 31 Aug 2021 16:04:11 GMT

I just updated my query please recheck once.

Re: How to add extra row

Reeza — Tue, 31 Aug 2021 16:16:16 GMT

Do you actually need this as a data set or as an output for a report? ie would the output in Word/Excel/PDF be fine?

If so, you need PROC REPORT.

Re: How to add extra row

sasuser123123 — Tue, 31 Aug 2021 16:27:21 GMT

We need a final dataset looks my output for proc report right?

Re: How to add extra row

Reeza — Tue, 31 Aug 2021 16:29:14 GMT

No, your input data set is set up fine for PROC REPORT, however if you want more help beyond just use PROC REPORT I would suggest posting actual data.

Re: How to add extra row

sasuser123123 — Tue, 31 Aug 2021 16:30:51 GMT

Usually I used that scenario..I didn't try in proc report...any inputs

Re: How to add extra row

Reeza — Tue, 31 Aug 2021 16:45:17 GMT

COMPUTE BEFORE most likely.