There are many options for scheduling SAS jobs. Server-based scheduling is best - this link is a good place to start understanding this:   http://support.sas.com/documentation/cdl/en/scheduleug/68697/HTML/default/viewer.htm#n0oeos2qfpfs0yn1ijidyinl8tyo.htm   However you can also schedule on PCs using the Windows scheduler if you have Base SAS installed, or in Enterprise Guide on your PC which has a special way of scheduling EG projects. If you are just starting out trying to schedule then you could either do it on your PC or if you have a SAS administrator ask him/her to help you schedule your report on your SAS server. ... View more

Difference between lasthired and what? ... View more

Clearly you have a multipart homework assignment, and you have chosen to put each part is a separate topic.  But really - separating this "average tenure" request from the "average salary" request?  Yes, one of them (tenure) appears to require some preliminary calculation before getting the average.  But, just as in your "maximum attrition" question you chose not to provide enough information to make the question clear.   You want help (more than help actually).  You don't specify what you tried.  You don't inform us what you don't understand.   This is not enouraging to folks who want to help other learn sas.  It seems more like a subcontracting job at very low rates.   So tell us, restricting discussion to just this topic, let's just focus on the very first sub-problem:   What have you tried for calculating tenure?   Show us your program and the log it generated - essential for good diagnosis.           ... View more

Your sample data only has one record per ID, so there is nothing to do to find the record for each ID that has the maximum value of D_DATE2.   Did you mean something else?  Perhaps you can post other sample data. It would help to post what you want the output to look like. ... View more

Which means that flightdelays contains ALL, I repeat ALL variables you want in your query. If you don't come up with substantually new information, I'm out of here. I've got better things to do with my time. ... View more

Post your log and include your SAS version.  ... View more

##- Please type your reply above this line. Simple formatting, no attachments. -## Hi That's I've done it already. Now I'm wanted increase values by 25% and later I wanted find difference between both by using Arrays Regards Ravi ... View more

%macro your_macro_name(memname); *here comes your code; *example; where memname = "&memname"; *further code; %mend; ... View more

@Ravikumarpa4 wrote: Just I wanted to extract latest dataset in a library called common. I tried to use proc sql but it's display all the datasets, I need single dataset which id created recently and later I need to write macro for the same. Any idea how to do it? See this example: 16 proc sql noprint; 17 select name into :names from sashelp.class order by name descending; 18 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 19 %put "names=&names"; "names=William " Note that the macro variable contains only one entry, coming from the first line that the order by clause delivers. So proc sql noprint; select memname into :memname from dictionary.tables where libname = 'COMMON' order by memname descending; quit; should deliver the last dataset from library COMMON in macro variable &memname. ... View more

Whilst I agree with the above, if number convert is easiest, if the data contains non numerics that isn't going to work, so here is a text version: data want; input zip $; if lengthn(zip) < 6 then zip=cats(repeat("0",5-lengthn(zip)),zip); datalines; 12345 123456 12AE4 1 ; run; ... View more