topic Re: count into in SAS Programming

count into

HeatherNewton — Fri, 11 Mar 2022 08:05:02 GMT

PROC SQL noprint;
SELECT DISTINCT
count(*) into :total_Dev
FROM &POrt._dev;
QUIT;

what does count(*) into :total_Dev means?

Re: count into

HeatherNewton — Fri, 11 Mar 2022 08:15:32 GMT

also is the output data set same as the source data set &Port._dev? here didnt start with data and dataset name so where are the data saved?

Re: count into

japelin — Fri, 11 Mar 2022 08:42:19 GMT

Look up the document and read it.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/sqlproc/n1tupenuhmu1j0n19d3curl9igt4.htm

Re: count into

japelin — Fri, 11 Mar 2022 08:45:37 GMT

There is no output dataset because there is no "create table". Only results are available.
It is necessary that learning basic sql syntax before using proc sql.

Re: count into

ballardw — Fri, 11 Mar 2022 11:35:22 GMT

INTO : , that colon is extremely important, means the results get placed into one or more macro variables whose names follow the colon depending on actual syntax.

Suggestion: From the level of understanding you show with your questions you should not be working with macro variables or code at all yet. The SAS macro language is used to create code elements. If you do not know our understand those elements use of the macro language will cause problems, confusion and very likely data corruption and/or unstable SAS sessions.

Macro language will involve lots of % functions and statements and macro variable names that start with &.

Re: count into

Kurt_Bremser — Fri, 11 Mar 2022 12:18:30 GMT

The SQL summary function counts the number of non-missing values in its argument. * denotes all columns/variables in the dataset, so you get a count of all observations where at least one column is not missing.

Re: count into

FreelanceReinh — Fri, 11 Mar 2022 14:43:53 GMT

Minor correction: COUNT(variable) returns the number of observations with non-missing values of variable, but COUNT(*) returns the number of observations regardless of missing values.

Re: count into

Sajid01 — Fri, 11 Mar 2022 14:59:06 GMT

Hello @HeatherNewton
"what does count(*) into :total_Dev means "
It means create a macro variable total_Dev that has the total number of rows in the table or dataset.

As you are using Select distinct, the macro variable total_Dev will have the count of distinct observations in the table.

Re: count into

FreelanceReinh — Fri, 11 Mar 2022 16:05:29 GMT

It's DISTINCT count(*) -- not count(distinct sql-expression). Since count(*) returns a single number in this case (as there is no GROUP BY clause), the DISTINCT keyword is redundant. The TRIMMED keyword (... into :total_Dev trimmed) would make more sense to avoid leading blanks in macro variable total_Dev.