topic Re: Retain or lag the values as desired in SAS Programming

Retain or lag the values as desired

RAVI2000 — Tue, 28 Jun 2022 18:00:45 GMT

Hi all,
Looking to manage my data.

HAVE:

want:

Re: Retain or lag the values as desired

PaigeMiller — Tue, 28 Jun 2022 18:18:40 GMT

Please explain:

What happened to trt 1 subject 1 in your output?
Why are some cells in the output blank and others have a dash?

Other than those issues, this is really just a PROC TRANSPOSE with BY statement — although depending on what analysis you will do next, you might want to leave the data un-transposed. So what analysis are you going to do next?

UNTESTED CODE

proc transpose data=have out=want;
    by trt subject;
    var grade;
    id test;
run;

Then you can turn the zeros into spaces or dashes as desired.

If you want tested code, and for all questions you might ask in the future, we cannot use data in a screen capture. Provide data as SAS data step code, which you can type yourself, or you can follow these instructions. Consider this mandatory in the future, data only as SAS data step code, not screen captures, not Excel files.

Re: Retain or lag the values as desired

RAVI2000 — Tue, 28 Jun 2022 18:20:12 GMT

Thank you @PaigeMiller for the input.
I would only like to populate values who have grades. For the trt 1, there are no grades.
I have used the above code and It is giving me like below:

Re: Retain or lag the values as desired

PaigeMiller — Tue, 28 Jun 2022 18:21:40 GMT

Please provide the data as SAS data step code, as I requested.

Also, please show the exact code you used.

Re: Retain or lag the values as desired

RAVI2000 — Tue, 28 Jun 2022 18:25:18 GMT

data have;
input trt subject test 3$ grade;
cards;
1 1  ALT  0
1 1  AST  0
1 1  BILI 0
1 1  GGT  0
1 3  ALT  0
1 3  AST  0
1 3  BILI 1
1 3  GGT  2
2 4  ALT  1
2 4  AST  0
2 4  BILI 0
2 4  GGT  0
2 5  ALT  0
2 5  AST  2
2 5  BILI 0
2 5  GGT  3
3 6  ALT  0
3 6  AST  0
3 6  BILI 0
3 6  GGT  1
3 10 ALT  0
3 10 AST  4
3 10 BILI 1
3 10 GGT  0
;
run;

Re: Retain or lag the values as desired

RAVI2000 — Tue, 28 Jun 2022 18:30:09 GMT

proc transpose data = have out=want prefix=_;
by trt subject test descending grade;
var grade;
id test;
run;

Re: Retain or lag the values as desired

PaigeMiller — Tue, 28 Jun 2022 19:07:35 GMT

@RAVI2000 wrote:

proc transpose data = have out=want prefix=_;
by trt subject test descending grade;
var grade;
id test;
run;

That's not the code I provided. In fact the code I provided seems to work perfectly on your data.