topic Re: functions in SAS Programming

functions

sonuvarsha — Fri, 22 Jan 2016 12:49:16 GMT

program to disply sentance with n words as below in dataset variable ?

this
this is
this is sas
this is sas class.................n

Re: functions

Kurt_Bremser — Fri, 22 Jan 2016 10:12:39 GMT

Could you PLEASE be a little more elaborate about what you want to achieve?

Re: functions

sonuvarsha — Fri, 22 Jan 2016 10:23:54 GMT

this is the sentance r else you dont know the length of the sentance ...the words should display as 1st ,1st 2nd,1st 2nd 3rd ...........n

in a dataset with new variable

example

x='this is sas class'

the output should be like below

new

______

this

this is

this is sas

this is sas class

Re: functions

mohamed_zaki — Fri, 22 Jan 2016 10:32:39 GMT

One way for that

data null;
length x $20;
retain x " ";
str="this is sas class";
do i = 1 to COUNTW(str) by 1;
   	x= strip(x) || " "||scan(str,i,' ') ;
   	output;
end;
run;

Re: functions

sonuvarsha — Fri, 22 Jan 2016 10:52:11 GMT

can we write the same program using other functions like anyspace , substr, compress,find functions ?n length shuld be the default length of the string to the new variable

Re: functions

Kurt_Bremser — Fri, 22 Jan 2016 11:34:09 GMT

Maybe we could, but why would we want to?

Mohamed's solution is looking fine, mine would have been almost identical.

Re: functions

sonuvarsha — Fri, 22 Jan 2016 12:42:47 GMT

because everytime we have to write length statement before if we increase that string word count......if string length is unkown then ??? that is my question

Re: functions

Kurt_Bremser — Fri, 22 Jan 2016 12:59:08 GMT

Setting the length is necessary. If you need to automate that, you can read the length of the input variable beforehand from sashelp.vcolumn and use that to set the length in the final data step.

Re: functions

FreelanceReinh — Fri, 22 Jan 2016 15:06:41 GMT

How do you like this?

data test(drop=str);
str="We do not need to specify the length of a character variable if we are happy with the length it is given automatically";
do _n_=1 by 1 until(new=str);
  new=catx(' ',new,scan(str,_n_));
  output;
end;
run;

Interestingly, variable NEW seems to inherit the type and length of STR because of the UNTIL condition. Without that, it would be created as a numeric variable because of its uninitialized occurrence in the second argument of CATX. If it didn't occur there either, it would get a default length of $200 (see documentation of the CATX function).

Re: functions

mohamed_zaki — Fri, 22 Jan 2016 16:17:00 GMT

This would work too

data have;;
str="this is sas class";
x=str;
do i = 1 to COUNTW(str) by 1;
	if i=1 then x="";
   	x= strip(x) || " "||scan(str,i,' ') ;
   	output;
end;
run;