Good morning,   I have a file of individuals names and their change in ownership %'s between 1%-100%. There are approximately 500 records.    It looks like this: Smith         5% Jones        10% Mary           7%.   I want to create a field that assigns each of the records to a higher level grouping if they are in the top 75th percentile of % change (labeled TOP), another group if they are in the 20th-75th (labeled middle), and a 3rd group if they are in 0-19th (labeled bottom).    I tried proc means but that puts the stats into a table, it also doesn't help me with the middle groupings.    Thank you! ... View more

Hello all.   I have a file that lists out individual holdings by 2 managers. I successfully created a summarized report of total holding by each manager using the code below: However, I actually need the summarized figure from this report in other calculations. Because it is a "report", I wasn't sure how I can call on the summarized field within.    What I am trying to do is say "this manager currently holds $10,000 in apple, and divide that $10,000 by the summarized total from the report to get a % of total column".      proc report data=temp.tsndata1; columns mgrno fdate shareprice; define mgrno/group; define fdate/group; define shareprice/analysis sum; run; ... View more

Evening all.   I have a data file called "hartland". There are 135 records, but I noticed that 33 of them have a "." in my PERMNO column. How do I remove these items and get my file down to 102 records? ... View more

Hi All,   I have a SAS table with 8 columns, the last 2 of which are Permno and Eventdat. I am looking to add a 9th column that takes the data within the Permno Column and concatenates it with the data in the Eventdat Column with a "-" in between. I found another post on the topic that was older but it didn't appear to work for me. Here is the code I currently have. If possible I would also like to strip out any leading and trailing blanks.    I've also tried putting "permno" and "eventdat" in quotes but then it just shows up as words. My other variables disappear too!   data temp.biotechControlsFinal; var1 = Permno; var2 = Eventdat; length var3 $ 15; var3 = catx('-', var1, var2); put _all_; run; ... View more