character variable

[VISHNU239]

The following SAS program is submitted:

data work.staff; 

JobCategory = ‘FA’;

JobLevel = ‘1’; 

Jobcategory = Jobcategory || JobLevel; run;

Which one of the following is the value of the variable JOBCATEGORY in the output data set?

1. FA
2. FA1
3. FA 1
4. ‘‘(missing character value)

Answer: A

how is it option A?

[art297 · Accepted solution]

Because the length of JobCategory is set as 2.

Now, just as interesting, try to figure out the results of:

data work.staff; 
  JobCategory = 'FA';
  JobLevel = '1'; 
  Jobcategory2 = Jobcategory || JobLevel;
  Jobcategory = Jobcategory || JobLevel;
  output;
  JobCategory = 'FAA';
  JobLevel = '2'; 
  Jobcategory2 = Jobcategory || JobLevel;
  Jobcategory = Jobcategory || JobLevel;
  output;
run;

Art, CEO, AnalystFinder.com

[VISHNU239]

yeah got it sir. examples helped me in understanding. what does the symbol || mean and what is its function?

[art297]

|| is similar to the catt function, i.e., it combines strings without trimming spaces from the right or removing any leading spaces.

Art, CEO, AnalystFinder.com