topic Re: First and Last Variables in SAS Studio

First and Last Variables

marianhabesland — Sat, 07 Oct 2017 17:31:25 GMT

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;

Re: First and Last Variables

novinosrin — Sat, 07 Oct 2017 17:38:43 GMT

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;

Re: First and Last Variables

Ksharp — Sun, 08 Oct 2017 06:23:07 GMT

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