topic Re: Create a datapoint in one dataset for the number of observations in another dataset in New SAS User

Create a datapoint in one dataset for the number of observations in another dataset

texasmfp — Sat, 28 Dec 2019 00:14:15 GMT

Is there an easy way to create a dataset with one observation and one variable, where the value is the number of obs in another dataset?

Thanks

Re: Create a datapoint in one dataset for the number of observations in another dataset

Kurt_Bremser — Sat, 28 Dec 2019 00:20:20 GMT

select nobs from dictionary.tables
where libname = "XXXXXXX" and memname = "YYYYYY";

Re: Create a datapoint in one dataset for the number of observations in another dataset

texasmfp — Sat, 28 Dec 2019 00:33:28 GMT

Thanks Kurt, but I got an error

56 data want
57 select nobs from dictionary.tables
ERROR: Libref 'dictionary' exceeds 8 characters.
58 where libname = "COMPANY" and memname = "MATCHES";
- -
22 22
200 200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.

ERROR 200-322: The symbol is not recognized and will be ignored.

59 run;

Re: Create a datapoint in one dataset for the number of observations in another dataset

SASKiwi — Sat, 28 Dec 2019 00:43:43 GMT

@Kurt_Bremser wrote an SQL query not a DATA step statement:

proc sql;
create table want as 
select nobs 
from dictionary.tables
where libname = "XXXXXXX" and memname = "YYYYYY";
quit;

Re: Create a datapoint in one dataset for the number of observations in another dataset

texasmfp — Sat, 28 Dec 2019 00:48:13 GMT

I can work with that. Much thanks.

Re: Create a datapoint in one dataset for the number of observations in another dataset

novinosrin — Sat, 28 Dec 2019 01:52:30 GMT

Hi @texasmfp If you are comfortable using Datastep, you could use SASHELP views that basically executes the SQL query demonstrated by @SASKiwi

So the query would look something like

data want;
set sashelp.vtable;
where libname = "XXXXXXX" and memname = "YYYYYY";
run;

SASHELP.VTABLE is a view of DICTIONARY.TABLES