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. ;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.