{"id":5617,"date":"2018-07-24T09:27:53","date_gmt":"2018-07-24T14:27:53","guid":{"rendered":"http:\/\/www.thejuliagroup.com\/blog\/?p=5617"},"modified":"2018-07-24T09:27:53","modified_gmt":"2018-07-24T14:27:53","slug":"sas-tip-of-the-day-the-_character_-array-and-fixing-all-character-variables","status":"publish","type":"post","link":"https:\/\/www.thejuliagroup.com\/blog\/sas-tip-of-the-day-the-_character_-array-and-fixing-all-character-variables\/","title":{"rendered":"SAS Tip of the Day: The _character_ array and fixing all character variables"},"content":{"rendered":"

Contrary to appearances, this is not an abandoned blog. I’ve been super-busy with 7 Generation Games, where we released two new games <\/a>and a customized app for a client this month! At the same time, I’m in Santiago, Chile piloting games for our Spanish language brand, Strong Mind Studios, you can read some of my blog in Spanish here<\/a>.<\/p>\n

\"Santa<\/a>
Santa Lucia, next door<\/figcaption><\/figure>\n

I decided to get back to blogging with a SAS tip of the day. Today’s tip is about the _character_ array.<\/p>\n

If you didn’t know, now you know: All character variables are in the _character_ array<\/h3>\n

Often, I want to do something to every character variable in a data set, for example, set all of the values to upper case, so “diabetes”, “Diabetes” and “DIABETES” are not counted as three, different disabilities. Because I hate to expend unnecessary effort, I don’t want to list the names of every character variable and I don’t want to count how many there are because I’ll probably count wrong and then end up with errors.<\/p>\n

Here is an example using the _character_ array.<\/p>\n

data fixdata ;
\nset fix1;
\narray fixchars {*} _character_ ;
\n** Change all character values to upper case ;
\ndo i = 1 to dim(fixchars);
\nfixchars{i} = upcase(fixchars{i}) ;
\nend ;<\/code><\/p>\n

Just use an ARRAY statement, give your array a name and in the {} instead of the number of elements put a *\u00a0 which SAS interprets as “the number of variables in the array are however many character variables there happen to be.<\/p>\n

You might think you’d have to use the $ to specify that the _character_ array consists of character variables, but that’s kind of overkill and you actually don’t. It will work either way.<\/p>\n

In my DO statement, I use the DIM function which will return the dimension of the array. That is, DO I = 1 to DIM(array_name) will do the statements from the first variable to however many happen to be in the array.<\/p>\n

As you might guess, the UPCASE function returns the value in all upper case.<\/p>\n

\n

Have a kid? Like kids? Feel like a kid yourself? Check out our new game, Making Camp Premium, because maturity is over-rated.<\/a><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Contrary to appearances, this is not an abandoned blog. I’ve been super-busy with 7 Generation Games, where we released two new games and a customized app for a client this month! At the same time, I’m in Santiago, Chile piloting games for our Spanish language brand, Strong Mind Studios, you can read some of my…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,8],"tags":[],"class_list":["post-5617","post","type-post","status-publish","format-standard","hentry","category-software","category-technology"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/5617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/comments?post=5617"}],"version-history":[{"count":1,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/5617\/revisions"}],"predecessor-version":[{"id":5621,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/5617\/revisions\/5621"}],"wp:attachment":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/media?parent=5617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/categories?post=5617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/tags?post=5617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}