I have one pdf file , I want to split that pages based on title page content and also need to merge multiple files in to single PDF . How to do in SAS
... View more
I have data like this data have; infile datalines; input policynumber$8.; datalines; m2227eqw,wy3747387,hsdahah schaxnbbxc 847e7w87 47ew7837 ds6778989 fg848484,rt222222,y72378w ; run; how to find out count policy number ? actual count is 10 but it count came 6.; thanks in advanc
... View more
I try like this data have; infile datalines ; input date MMDDYY10.; format date MMDDYY10.; datalines; 01/06/2015 01/07/2015 01/29/2015 02/06/2015 02/07/2015 ; run; i want to apply proc format above dataset. sas takes sunday is 1 but my requirement like this PROC FORMAT; VALUE $WEEK 'Saturday'=1 'Sunday'=2 'Monday'=3 'Tuesday'=4 'Wednesday'=5 'Thursday'=6 'Friday'=7 QUIT; data have1; set have; FORMAT DATE1 MMDDYY10.; FORMAT DATE1 WEEKDATE9.; RUN;
... View more
iam reading excel sheet in sas using libname variables names came in f1 f2 f3 ............. my requirment is 1st obs values come in to variable name, for example ; i have data like this: obs f1 f2 f3 f4 history jan feb mar apr saves 400 300 200 100 expences 500 300 100 700 i want like this: history jan feb mar apr saves 400 300 200 100 expences 500 300 100 700 help me , thanks in advance
... View more
comparison for only max month of present year&last year I HAVE DATA LIKE THIS DATA DS1; INPUT DATE : DDMMYY10. AMOUNT COMMAMT INSENTIVAMT BONUSAMOUNT; FORMAT DATE DDMMYY10.; CARDS; 31/01/2014 5000 6000 2345 4567 28/02/2014 6000 7000 5775 4587 30/03/2014 7000 8000 5464 4323 31/12/2013 3400 9000 2456 8970 30/11/2013 5000 6000 3456 7865 28/10/2013 6000 5000 4456 6758 28/05/2013 6000 7000 4563 7890 30/04/2013 7000 3400 6754 7856 31/03/2013 3400 5000 4567 2532 28/02/2013 5000 6000 7890 1324 31/01/2013 6000 3400 3456 3456 ; RUN; MY REQUIREMENT IS ONLY MAX(MONTH) OF MAX YEAR AND COMPARISON PURPOSE BEFORE YEAR SAME MONTH LIKE MARCH DATA ONLY IN PRESENT&PREVIOUS YEAR 30/03/2014 7000 8000 5464 4323 AND 31/03/2013 3400 5000 4567 2532. I TRIED IN PROC SQL CAME PRESENT YEAR ONLY, HELP ME THANKS IN ADVANCE
... View more
For example I Have two SAS datasets like data ds; infile datalines; input id; datalines; 101 102 103; run; data ds_1; infile datalines; input id Amount$ ; datalines 101 10000 103 50000 104 70000; run; one Excel file is there ,some information already in excel like Amt 70000 50000 20000 30000 70000 20000 and how to mapping the id values......
... View more