Here is macro solution .Copy all the table from SASHELP into WORK.
%macro UPCASE_Var(_a_infile_,_a_outfile_);
data &_a_outfile_.;
set &_a_infile_.;
array Chars
do i = 1 to dim(Chars);
Chars = upcase(Chars);
end;
drop i;
run;
%mend;
data _null_;
set sashelp.vmember(keep=libname memname memtype where=(libname='SASHELP' and memtype='DATA')) ;
call execute(cats('%UPCASE_Var(',libname,'.',memname,',',memname,')'));
run;
Can we create a macro variable for following text (ram is "very disposition",now we want ,to eat you,right"way is not collected")
%let want = 'ram is "very disposition",now we want ,to eat you,right"way is not collected" ';
%put want ;
ITS NOT WORKING CAN ANYONE HELP ME
Sure .
%let want = ram is "very disposition",now we want ,to eat you,right"way is not collected" ;
%put &want ;
%let want = 'ram is "very disposition",now we want ,to eat you,right"way is not collected" ';
%put &want. ;
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.