The decision to retain the current record is based on the value of a variable (Age) in the next record. If the next record has Age>30, then the current whole record should be kept. Is there any statement to deal with this? Policy Location Year Age 142 12 1978 32 143 05 1980 31 144 17 1990 20 So in the output, the first record should be kept, and the second one deleted. ... View more

I have a data like the one below. For each person (with ID), he went to either cinema (1,2) at different time. Just ignore the variable date. I want to know how a program can be developed in the DATA step to resolve the following question: Get a summary for each person (ID) in terms of their frequency of visit to the two cinemas, using only the DATA step? I want to program to get the results Cinema ID Date 1 1 11/02/2007 1 2 11/02/2007 1 2 15/04/2007 1 2 20/06/2007 1 3 14/11/2007 2 1 05/01/2007 2 1 12/05/2007 2 2 08/08/2007 The result should look like this: Cinema ID Freq 1 1 1 1 2 3 1 3 1 2 1 2 2 2 1 ... View more

I am trying to merge two datasets. Simply, data1 has variables of school, group, and sex1, and data2 has variables of school, group and sex2. Afer the following DATA step, the values for sex2 become 'O' if they are missing, not the 'Other' I want to get. DATA work.data; MERGE work.data1 work.data2; BY school group; LENGTH sex2 $5.; FORMAT sex2 $5.; IF MISSING(sex2) THEN sex2='Other'; RUN; ... View more

I have a data set which has a few variables. One variable is called sex, which has a fixed length of 1, and formatted as $1. (i.e. M, or Female). This variable also has missing values. Now the question is to set the missing values as 'Other'. The following is what I did: DATA work.test; SET user.birth; LENGTH sex $5.; FORMAT sex $5.; IF age=' ' THEN age='Other'; Unfortunately, the missing values are set to be 'O'. How can I correct this without using any new variable names? ... View more

I have a data with the format as: Type PH SEQ A Y 1 A N 2 A N 3 A N 4 B Y 2 B N 1 B N 3 B N 5 The data can be easily sorted based on Type, PH and SEQ as shown above. Now the question is to pick up: 1) all the records with PH=Y, and 2) the first two records in the sorted data where PH=N. So the results should be like: Type PH SEQ A Y 1 A N 2 A N 3 B Y 2 B N 1 B N 3 How can I do that? ... View more

Hi folks, I used DATA step to manipulate data. The first method lead to 0 observations, while the second one works fine. Why in this case the 'IS MISSING' statement is wrong? DATA work.driver; SET user.driver; IF sex='X' or sex is missing THEN sex='M'; RUN; DATA work.driver; SET user.driver; IF sex='X' or MISSING(sex) THEN sex='M'; RUN; ... View more