An Idea Exchange for SAS software and services

by Esteemed Advisor
on ‎10-24-2017 11:03 PM

Yes! Call them CATXF, CATSF, CATQF, CATTF. "F" for formatted.

by Super User
on ‎10-25-2017 01:14 PM

Of course as soon as you have one of these functions you find out that you don't want your current default format but actually want to use another one but NOT change the default for the variable(s) [which would be easy]...

by Regular Contributor
on ‎01-05-2018 06:42 PM

This would be nice.  This code does what we want-- hopefully the reader cringes at it and votes this up.


data have;

    format date1-date20 date9.;
    format datec1-datec20 $10.;
    length datec1-datec20 $10. x_string y_string $256.;
    length want_string $200;
    array _date(*) date1-date20;
    array _datec(*) $  datec1-datec20;

    do i=1 to dim(_date);
    have_string=catx(", ", of _date(*));

    do i=1 to dim(_date);
        _datec(I)=trim(put(_date(I), date9.))||',';


by Super User
on ‎01-05-2018 06:47 PM

@PhilC That's one way to get change Smiley Wink 

Idea Statuses
Top Liked Authors