Hi everyone,
I have a time-series of residuals (along with company, date) obtained from the "Reg" procedure, I would like to resample the residual series by the company (each has different number of observations), and make the sample size of each company equal to the number of observations that company has.
I would like to use the following example. My question is how do I change that "19" in number of observations into something that changes based on each company.
%if &lib = sashelp and &data = class %then %let numobs = 19;
Any suggestion would be greatly appreciated.
Thank you very much.
Sysfunc simply allows to use SAS functions inside the macro language.
Here is full working code:
%macro t;
%local lib data dsid numobs rc;
%let lib= SASHELP;
%let data = CLASS;
%if &lib = SASHELP and &data = CLASS %then %do;
%let dsid = %sysfunc(open(&lib..&data));
%let numobs = %sysfunc(attrn(&dsid,nobs));
%let rc = %sysfunc(close(&dsid ));
%end;
%put &=numobs;
%mend;
%t
NUMOBS=19
So here we open a table, extract NOBS from its metadata and close the table.
Like this?
%if &lib = SASHELP and &data = CLASS %then %do;
%let dsid = %sysfunc(open(&lib..&data));
%let numobs = %sysfunc(attrn(&dsid,nobs));
%let rc = %sysfunc(close(&dsid ));
%end;
Sysfunc simply allows to use SAS functions inside the macro language.
Here is full working code:
%macro t;
%local lib data dsid numobs rc;
%let lib= SASHELP;
%let data = CLASS;
%if &lib = SASHELP and &data = CLASS %then %do;
%let dsid = %sysfunc(open(&lib..&data));
%let numobs = %sysfunc(attrn(&dsid,nobs));
%let rc = %sysfunc(close(&dsid ));
%end;
%put &=numobs;
%mend;
%t
NUMOBS=19
So here we open a table, extract NOBS from its metadata and close the table.
Unsure what you are asking, Like this?
%macro t;
%local lib data dsid numobs rc;
%let lib= SASHELP;
%let data = CLASS;
%if &lib = SASHELP and &data = CLASS %then %do;
%let dsid = %sysfunc(open(&lib..&data(where=(AGE=12))));
%let numobs = %sysfunc(attrn(&dsid,nlobsf));
%let rc = %sysfunc(close(&dsid ));
%end;
%put &=numobs;
%mend;
%t
NUMOBS=5
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.