BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Sathya3
Obsidian | Level 7
%let source = other_rfb; /* Example value for the macro variable */

data glow;
input id $ source $ class $ country $;
datalines;
11e other mid au
23 other_rfb large eu
123ab other small other in
;
run;

data glow2;
set glow;
length id $200;
if "&source" in ("other", "other_rfb") then do;
id = class || "_under_250k" || country;
end;
else do;
id = class || "_under_250k";
end;

run;

Concatenation is not happening for id coulmn .id just has class values in glow2 dataset. Can you please help with correct code. Tried with cats as well

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26

Please read the log, it tells you what the problem is.

 

45    data glow2;
46    set glow;
47    length id $200;
WARNING: Length of character variable id has already been set.
         Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable.
48    if "&source" in ("other", "other_rfb") then do;
49    id = class || "_under_250k" || country;
50    end;
51    else do;
52    id = class || "_under_250k";
53    end;
54
55    run;

 

Your LENGTH statement didn't do anything where it is located. The LOG even tells you how to fix it.

--
Paige Miller

View solution in original post

1 REPLY 1
PaigeMiller
Diamond | Level 26

Please read the log, it tells you what the problem is.

 

45    data glow2;
46    set glow;
47    length id $200;
WARNING: Length of character variable id has already been set.
         Use the LENGTH statement as the very first statement in the DATA STEP to declare the length of a character variable.
48    if "&source" in ("other", "other_rfb") then do;
49    id = class || "_under_250k" || country;
50    end;
51    else do;
52    id = class || "_under_250k";
53    end;
54
55    run;

 

Your LENGTH statement didn't do anything where it is located. The LOG even tells you how to fix it.

--
Paige Miller

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
  • 1 reply
  • 826 views
  • 2 likes
  • 2 in conversation