topic Re: sql vs proc freq in SAS Programming

sql vs proc freq

kindbe17 — Wed, 03 May 2023 08:18:48 GMT

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

Re: sql vs proc freq

Patrick — Wed, 03 May 2023 09:53:38 GMT

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.

Re: sql vs proc freq

PaigeMiller — Wed, 03 May 2023 09:53:35 GMT

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

Re: sql vs proc freq

kindbe17 — Wed, 03 May 2023 10:32:24 GMT

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;

Re: sql vs proc freq

Patrick — Wed, 03 May 2023 10:39:49 GMT

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;