First and Last Variables

[marianhabesland]

Using this code, I have understood that automatic variables FIRST.SubjID and LAST.SubjID are supposed to appear in the PDV. I am supposed to fill out the variables for FIRST.SubjID and LAST.SubjID, but am confused as to how to actually display these variables.

data    WORK.AEs;

    infile  datalines;

    input   SubjID

            AEDesc  $;

    datalines;

109 Nausea

109 Dyspnea

109 Headache

122 Dyspnea

146 Rash

146 Flushing

; 

data    WORK.Analysis;

    set WORK.AEs;

    by  SubjID;

    run;

[novinosrin · Accepted solution]

Using this code, I have understood that automatic variables FIRST.SubjID and LAST.SubjID are supposed to appear in the PDV. I am supposed to fill out the variables for FIRST.SubjID and LAST.SubjID????,

Do you want to assign the values of first and last to another variable?

but am confused as to how to actually display these variables.

data    WORK.AEs;

    infile  datalines;

    input   SubjID

            AEDesc  $;

    datalines;

109 Nausea

109 Dyspnea

109 Headache

122 Dyspnea

146 Rash

146 Flushing

; 

data    WORK.Analysis;

    set WORK.AEs;

    by  SubjID;

first=first.subjid;

last=last.subjid;

    run;

---

[Ksharp]

data    WORK.Analysis;
    set WORK.AEs;
    by  SubjID;
	put _all_;
    run;