hi I have a variable with values containing numeric as well as alphabetic characters.(eg. 1675ag157). I want to put the observations that contains alphas in a seperate dataset. Is there a formula that i can use to identify these records other than a lengthy if statement? ... View more

Hi I have a list of 4 users and a list of 20 000 accounts and want to randomly distribute the accounts amongst the users evenly. Is there a proc that i can use for this? ... View more

i have a tabulate with below output. i want the numbers to be represented as a percentage of "All". is there an easier way to do this apart from a proc summary and merge? | Broken | Kept | | | |------------------------------------+-----------------------------------| | | | No_Pmt | Part_Pmt | Full_Pmt | Over_Pmt | All | | |-----------------+----------------+----------------+-----------------+------------| | | N | N | N | N | N | |-----------------------------+----------------+---------------+----------------+-----------------+-------------| |Agent | | | | | | |-----------------------------| | | | | | |1401 | 1.00| .| .| .| 1.00| |-----------------------------+----------------+---------------+----------------+-----------------+-------------| |1423 | 2.00| .| .| .| 2.00| ---------------------------------------------------------------------------------------------------------------------- ... View more

i am writing a proc report into ods and want my titles and footnotes to be on the left hand side. what syntax can i use? ... View more

i have a date in my data which is only day and month (eg. 25/03) when doing an infile, it imports as a text value. i am trying to add a year to this value, but with no joy. i am trying to use the following: data may_3010; set may_3010; format year $4.; format newdate date9.; year= '2010'; newdate= input(Prom_D_1||year,mmddyy10.); run; ... View more

hi would like to export a file to a certain sheet in excel, but instead of replacing the data, i would like to append. how do i do this? ... View more

I would like to sort more than one dataset with a common by variable in one proc sort. is this possible? if so, please assist with syntax. ... View more

i have created a tabulate with two dfferent dates' data as values (example below): sumary data: DPD Date _freq_ 1 20/05/2010 500 30 20/05/2010 500 60 20/05/2010 500 1 21/05/2010 400 30 21/05/2010 400 60 21/05/2010 400 tabulate result DPD 20/05/2010 21/05/2010 1 500 400 30 500 400 60 500 400 code PROC TABULATE DATA= jackie.oview_201 format=comma13.; CLASS DPD DATE ; VAR _freq_; TABLE DPD,Date*_freq_; TITLE 'Late Stage Overview Number'; label _freq_ =Number; RUN; how do i get a variance between the two figures if it is a result of the tabulate? Desired Result: DPD 20/05/2010 21/05/2010 Variance 1 500 400 100 30 500 400 100 60 500 400 100 also, i want my ods output in excel to reflect the data with a white background (i already have the headings under control). ... View more

i want to export files to excel with certain color formats on the headings. how can i do this? ... View more

I want to compare the variable names as well as the vaiable formats of two datasets within SAS without doing a PROC CONTENT on each as there are over 500 variables in each table. I can also do a PROC APPEND, but that is not the proper way. please help... ... View more