topic Re: character variable in SAS Programming

character variable

VISHNU239 — Sat, 03 Feb 2018 00:32:06 GMT

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?

FA
FA1
FA 1
‘‘(missing character value)

Answer: A

how is it option A?

Re: character variable

art297 — Sat, 03 Feb 2018 01:09:13 GMT

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

Re: character variable

VISHNU239 — Sat, 03 Feb 2018 01:25:28 GMT

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

Re: character variable

art297 — Sat, 03 Feb 2018 02:16:16 GMT

|| 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