Hi, I have a doubt regarding the length of variables during compilation/execution time. The code, 1 data one; 2 name='AAA'; 3 result=repeat(name,10); 4 length_var=length(result); 5 run; 6 7 proc contents data=one; 8 run; Here, the output of the proc contents shows the length of the variable "result" is 200. I remember the length of the resultant variable when using "repeat" function will be 200. But, when i open the dataset "one" to see the value of "length_var" which should have the length of the variable "result", is only 33. What may the reason behind this? The attribute length of the variable "result" is determined at compile time and the value of the variable "length_var" which is the output of the length function is determined only at execution time. Is this the reason? Won't the SAS consider the attributes of the variable "result" when scanning the the line 4 during compile time? Thanks ... View more

Hi All, I have got a requirement like this. I have to delete all observations which has missing values in all variables; irrespective of the datatype. This should be accomplished in a data step in a single statement, without using macro. I tried with _all_. But, i guess The SAS System never allows this to be assigned to a variable. I also tried with cmiss & nmiss, but these 2 functions are specific to datatype. I tried with sum function which will throw a "invalid numeric data" note when character variable is encountered. Help me if you know any logic. Thanks MSG ... View more

Hi all, I have a request to create variables in a dataset depends on the number of words a particular string has. I came with this code, but its not working. For. Ex. The string "name" has 5 words, so my dataset one should have 5 variables starting with word1 till word5 containing the corresponding words. %macro split (name=); data one; %let i=1; j='x'; %do %while (j ne ' '); word&i=%scan(&name,&i,' '); j=word&i.; output; %let i=%eval (&i. + 1); j=%scan(&name,&i,' '); %end; run; %mend split; %split (name='sas is an analytical language'); What may be the error in this code? ... View more