sas proc sql

[HeatherNewton]

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? 

[AMSAS]

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 

[ballardw]

---

@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.