Hi i wonder if sas can do the same as excel.
is there something like: count(var1, var2,......var29) in SAS that spits out 29, for example??
data yourdata;
set yourdata;
array arrayname1 _character_ ;
array arrayname2 _numeric_;
varcount=dim(arrayname1)+dim(arrayname2);
run;
you can also use out=contents options in proc contents, dictionary tables, sashelp library vtable, vcolumn and so on
data yourdata;
set yourdata;
array arrayname1 _character_ ;
array arrayname2 _numeric_;
varcount=dim(arrayname1)+dim(arrayname2);
run;
you can also use out=contents options in proc contents, dictionary tables, sashelp library vtable, vcolumn and so on
you are a big help naveen. thank you!
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.