Cynthia, Sorry, I could not share my code and sample data for you to understand my problem. Let me explain you what I am doing and how I got rid of this issue. Below are my answers to your questions: 2)I have used COMPUTE blocks to skip a row in the report. 3)I have used ODS to get my output in PDF. Description: Similar SAS dataset is constructed to make standard template Data test; infile cards DSD DLM=","; input Catg $20. Rank Order; cards; Blue, 1, 1, Red,1, 2, Tiger,2,1 Lion,2,2 ; run; I will then LEFT JOIN my real time data with TEST dataset with catg as my Key. I got the right results with all categories in right format except one category where I see 2 more extra rows inserted. In first look, I though it might be some extra row blank data. But I did not find any duplicate errors. Next thing I want to test is rearranging the categories. I did rearrange the categories in my TEST dataset  and this issue was resolved. I still dont understand why. Data test; infile cards DSD DLM=","; input Catg $20. Rank Order; cards; Tiger,1,1 Lion,1,2 Blue,2, 1, Red,2, 2, ; run; Thanks for your valuable inputs. ... View more

Based on my understanding, I think following steps will get the solution. 1) Give number rating 2) Order in Descending or ( Ascending) order 3) Create a new variable which number is higher and filter those 4) Use FIRST. to get most important if you have multiple records for each person I think this is what Art is suggesting.. ... View more

Thanks Art.. ... View more

I got it .. Below are my original dates : EFdt PEDt 20100101 201006 20000612 200009 I used this equation to get the difference.. AGE = intck('month',MDY(mod(int(EFDT/100),100),mod(EFDT,100),int(EFDT/10000)), MDY(mod(PEDT,100),1,int(PEDT/100))); ... View more

I normally use PROC Datasets in SAS enhance editor .. I dont know if this is useful to you .. Thanks ... View more

Delete " , " (comma) after grade in the select statement. That should work.. ... View more

Thank you !! ... View more

Put some dummy dates and then use if statements to make them as null or period. eg: fill the empty cells with dymmy date which is unique.. like : 01011968 then use if date1="01011968.d" then date1=.; I think best option is to sort it as suggested by Reeza. That is the safe option. ... View more

If you could provide the first few lines in the excel file, that would be helpful to find the problem. I think date2 is correct as it shows the number, if you can format that to date format (yyddmm.10) you might be able to see the desired date. Thanks. ... View more

Example 1: It shows default length of the char data name; input subject$; cards; Social Physics Chemistry nuclearphysics ; run; OUTPUT: This is default output: Social Physics Chemistr nuclearp Example 2: Length of the first variables value data name1; set name; if subject ='Social' then Class ='H'; else if subject ='Physics' then Class ='H plus'; run; output: Class H H ( But the second row in the output should be H Plus instead of H because it takes the length of the first assigment variable) and as you know you can use length subject $ 15. ; for the final option. So, all three are possible hence D is correct. ... View more

Perfect !! Thanks SPR. ... View more