topic Re: sas proc sql in SAS Programming

sas proc sql

HeatherNewton — Thu, 03 Mar 2022 10:18:07 GMT

is distinct in proc sql same usage as distinct of SQL?

in SQL,

eg select distinct apple orange banana from fruits

mean each row consist of apple orange banana is distinct..

in SAS,

proc sql distinct apple orange banana from fruits...

is the meaning of distinct the same in both cases?

Re: sas proc sql

AMSAS — Thu, 03 Mar 2022 12:26:02 GMT

I'm not sure your definition of DISTINCT is the same as my definition, based on your example

Here's the link to the documentation
Select Clause, DISTINCT Argument

Re: sas proc sql

ballardw — Thu, 03 Mar 2022 14:29:03 GMT

@HeatherNewton wrote:

is distinct in proc sql same usage as distinct of SQL?

in SQL,

eg select distinct apple orange banana from fruits

mean each row consist of apple orange banana is distinct..

in SAS,

proc sql distinct apple orange banana from fruits...

is the meaning of distinct the same in both cases?

Whose "SQL" in the first example. Some implementations of SQL may do things differently based on the rest of the query such as Where, Having or Group by clause and the exact options used in those as well.

Many flavors of SQL have extensions to the 'standard' behavior and may be controlled by user settings in addition to the code shown.

Better would be to provide some example data AND complete query examples. Best would be create data in the two, or more systems, that is identical and actually run the query and observe the result.