topic Re: scan function in SAS Programming

scan function

sanyam13 — Mon, 11 Jun 2018 17:17:11 GMT

Data test;

title = ' A tale of two cities , charles J. dickens' ;

word = scan( title, 3 , ',');

run;

what will be the value of the variable word in output data set , my answer is missing char. value but in mock test answer is ' of ' we have a comma after cities and in syntax i have mentioned that take ' , ' comma as delimiter so in that case 3rd word should be missing . can u plz explain this question .

Re: scan function

PaigeMiller — Mon, 11 Jun 2018 17:27:52 GMT

You are correct. (Of course this assumes you have not made a typing error, and the scan function really have ',' as the third argument and not ' ,' which has a space in it).

This is not something that needs to be posted in the SAS communities, as you can run the code yourself and see what the result is. This is a question you need to ask whomever created this test in the first place.

Re: scan function

ybolduc — Mon, 11 Jun 2018 17:28:58 GMT

Hi Sanyam,

Where are you taking those mock questions from? This is the second thread you start about those mock question pointing out that they appear to have wrong answers. Are you taking these from a recongnized source?

Thanks.

Re: scan function

Reeza — Mon, 11 Jun 2018 20:19:26 GMT

You get what you pay for. If you have to verify your course materials, its not really a good use of your time.