topic Re: What is the advantage of the ID statement in SAS? in New SAS User

What is the advantage of the ID statement in SAS?

cosmid — Fri, 15 Mar 2019 16:19:35 GMT

It seems, in a way, that the ID statement just replaces the NOOBS option.

proc print data=sample noobs;

var IDNUM LastName;

proc print data=sample;

ID IDNUM;

var LastName;

run;

Or it can uses more than 1 variable to be the OBS column. I guess my question is when should I use ID instead of NOOBS?

Re: What is the advantage of the ID statement in SAS?

ballardw — Fri, 15 Mar 2019 16:46:27 GMT

You might also try:

Proc sort data=sample;
   by idnum;
run;

proc print data=sample;
  by idnum;
  ID IDNUM;
  var LastName;

run;

which will create a somewhat different appearance for the by group output than a simple by statement. The BY variable then appears as a row spanning value in the first column of the output for each BY value instead of having the "BYVAR=Value" appear before a table. Which can significantly reduce the number of vertical lines in the output, especially with 2 or more by variables.

ID behaves differently in many of the procedures that have the option so it is worth investigating when offered as an option. For instance it is possible to get the value of a variable associated with the 3 largest values of another in Proc Means/ Summary using ID plus some additional code.

Re: What is the advantage of the ID statement in SAS?

cosmid — Fri, 15 Mar 2019 17:33:33 GMT

Thanks again ballardw!