topic Re: input record count from another table in New SAS User

input record count from another table

laiguanyu001 — Tue, 09 Jul 2019 18:27:22 GMT

Hi,

I want to create a dataset that looks like this

data out;

input id description $ num_of_errors error $;

datalines;

1001 some_string &count_of_record some_error

;

data table1;

input test;

datalines;

;

here I want &count_of_record to be the number of rows from table1. so when I print the data out,

the result will look like this

id description num_of_error error

1001 some_string 3 some_error

I'm wondering if there's a programming way to do this instead of manually type in. Thanks!

Re: input record count from another table

PaigeMiller — Tue, 09 Jul 2019 18:44:58 GMT

No macro needed. Basic manipulation of data rarely requires macros.

proc summary data=table1;
    var test;
    output out=ntable n=num_of_errors;
run;

data out;
    if _n_=1 then set ntable(drop=_:);
    input id description $ error $;
    datalines;
...
;
run;

Also, you can't have macro variables inside DATALINES

Re: input record count from another table

laiguanyu001 — Tue, 09 Jul 2019 19:14:54 GMT

thanks!! But what if my table1 also has some character values? I don't think proc summary works in that case.

Re: input record count from another table

PaigeMiller — Tue, 09 Jul 2019 19:23:24 GMT

@laiguanyu001 wrote:

But what if my table1 also has some character values?

Llittle known fact, if you omit the VAR command, PROC SUMMARY will count the number of observations, even if there are only character variables.

proc summary data=have;
	output out=_stats_ ;
run;