BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ksharp
Super User

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

  • _character_;
  • 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;

    anitapamu2
    Calcite | Level 5

    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

    Ksharp
    Super User

    Sure .

    %let want = ram is "very disposition",now we want ,to eat you,right"way is not collected" ;

    %put &want ;

    pallis
    Fluorite | Level 6

    %let want = 'ram is "very disposition",now we want ,to eat you,right"way is not collected" ';

    %put &want. ;

    hackathon24-white-horiz.png

    2025 SAS Hackathon: There is still time!

    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!

    Register Now

    How to Concatenate Values

    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.

    SAS Training: Just a Click Away

     Ready to level-up your skills? Choose your own adventure.

    Browse our catalog!

    Discussion stats
    • 18 replies
    • 3224 views
    • 5 likes
    • 4 in conversation