I've learnt about the nodupkey function and it's very useful in removing duplicated observations. But, is there any way I could overwrite or remove duplicates within the column? I'm unsure if I have phrased my question correctly, so please see the example below.  Any help would be greatly appreciated.    <ORIGINAL> ID Pattern 1 AABCCA -> ABCA  2 ABBCC -> ABC 3 ABBBCDC -> ABCDC 4 DDCBA -> DCBA 5 CCC -> C   <WANT> ID Pattern 1 ABCA 2 ABC 3 ABCDC 4 DCBA 5 C ... View more

I need help with combining data into one row. I would like the <ORIGINAL> data to be displayed as <NEW>. I believe that if I TRANSPOSE , it will result into multiple column.  Like <NEW> I would like multiple products to be displayed in a single column.  Thank you for your help in advance.    <ORIGINAL> ID Product Days 100 A 1 101 B 2 102 A 1 102 B 1 102 C 1 103 A 5 103 A 5   <NEW> ID Product Days 100 A 1 101 B 2 102 ABC 1 103 AA 5 ... View more

I have a large data that includes multiple observations for each ID.  If I only wanted to select the first entry of each ID, then the below code works.  If I wanted to select the first 5 entries of each ID, then what coding could I use? Thanks for your help in advance.    data want; set have; by id; if first.id; run;   ... View more

I am using a very simple programming code to draw a histogram. The following code did work to produce a histogram on SAS output screen.    PROC UNIVARIATE DATA = data_new1; histogram age/midpoints=(0 to 20 by 1); run;   But for some reasons, when I repeated the same code for a similar dataset, it produced a series of statistics (sample moments, basic measures of location and variability etc.) for all the variables in data_new1, when I only chose one variable 'age' in the above code.    How do I stop it from producing a series of statistics as I ONLY NEED A HISTOGRAM to be produced on SAS output screen?   Thank you for your help in advance.    ... View more

PROC CONTENTs data=demo varnum; run; I have just used the above code VARNUM for programming for the first time. I used this because I thought that I could use it to assess if the data was imported accurately.  For this reason, I checked the Number of observations, variables, and also confirmed that value is 0 for both "Deleted Observations" & "Number of Data Set Repairs".    Q1. Any other tips for using this varnum code? for any other purposes?   Q2. I am having a bit of difficulty understanding some keywords in this output, especially  - indexes, observation length, number of data set pages, Max Obs per Page, Obs in First Data Page  (I don't quite get which "page" it is) Could someone please tell me or suggests a webpage explaining these keywords?    Thank you for your help in advance.     ... View more