Data work;
author = 'agatha christie' ;
first = substr(scan(author,1, ' , ' ),1,1);
run;
i find this question in a mock test, question is what would be the length of the variable first in output data set , Answer given in mock test for this is 200 but when i run this program in sas i got 15 as length for the variable first . can you help me out in this case though i know length of scan function is 200 .
Hi Sanyam,
From what I remember, if the destination variable does not have a specified length, SAS will set it to the length of the source.
Small test:
data toto;
length a $200.;
a = 'Hello World!';
b = 'Hello World!';
c = scan(a, 1, ' ');
d = scan(b, 1, ' ');
run;
c has length 200 and d has length 15.
I hope that helps.
I assume in the question the was something indicating the length of author.
Thanks.
Hi Sanyam,
From what I remember, if the destination variable does not have a specified length, SAS will set it to the length of the source.
Small test:
data toto;
length a $200.;
a = 'Hello World!';
b = 'Hello World!';
c = scan(a, 1, ' ');
d = scan(b, 1, ' ');
run;
c has length 200 and d has length 15.
I hope that helps.
I assume in the question the was something indicating the length of author.
Thanks.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.