sql vs proc freq

[kindbe17]

hello, could you please help me to create tables with SQL?

[Patrick]

Also your subject indicates that you're actually after for something different here the docu link that should answer your question: Creating and Updating Tables and Views

Going forward please spend a bit more time to explain what you've got and what you need. Putting in the time to provide all information from start is highly appreciated in this forum.

[PaigeMiller]

---

@kindbe17 wrote:

hello, could you please help me to create tables with SQL?

---

Vague and un-detailed questions like this get vague and un-detailed answers. Specific and detailed questions get specific and detailed answers. Please be specific and detailed about what you want.

Also, what does your question have to do with your title? Seems to me they are talking about different things.

[kindbe17]

I got it, thank you for explaining, i will be more careful

need to calculate how many car types are in TYPE variable

i tried to do this

proc sql;
create table cars_2 as
select Make, Type
from sashelp.cars
Group by make
quit;

[Patrick]

Here you go.

proc sql;
  create table cars_2 as
    select Make, count(distinct Type) as n_types
      from sashelp.cars
        Group by make
  ;
quit;