I have data in this format, datalines sriram bhayagari gsr4455 naveen gsr5566 allapuram gsr6677 srinath thatipathri need output like Emp Name ID Sriram bhayagari 4455 Naveen allapuram 5566 srinath thatiparthi 6677
... View more
I have 10datasets of monthly wise data, table names are like IND_UA_012018, IND_UA_022018, IND_UA_032018, IND_UA_042018,....IND_UA_102018. I want macro code to append all the 10 datasets into one table using a macro
... View more
I want to segregate the data into 5 datasets in following way. dataset1- All the data where type variable is numeric dataset2 - All the data where type variable is capital letter dataset3- All the data where type variable is small letter dataset4- All the data where type variable is both capital and small but starts with capital letter. dataset5- All the data where type variable is both capital and small but starts with small letter.
... View more
I just dint get your question.. can you just give the data and let me know what you want to filter, i will try to help you @CharlesFowler72
... View more
We are close to the output but not exact... when we change the bdate=24OCT1990 and edate=10AUG2017 we are getting wrong calculation as per the code.. can you fix it.
... View more
@Kurt_Bremser Thankyou for your reply... I just want to know... Is there any fuction which can convert no of days to to yearsmothsdays format directly without writing that entire code..
... View more
data Diff; BDATE='10SEP2008'D; EDATE='14SEP2010'DD; ACTDATE=INTCK('DAYS', BDATE, EDATE); RUN; OUTPUT IS BDATE EDATE ACTDATE 17785 18519 734 I want to convert the above ACTDATE(734days) to 2years0months4days. What is the code?
... View more
In a dataset containing sales data with three different products on daily basis. I want to calculate sales subtotal for each of the product grand total. Looking for SAS code.
... View more
I have 5 names in table1 and 5 names in table2.. Table1 Table2 Table A F A B G F C H B D I G E J C H D I E J want to create a table with output picking values alternatively from two tables
... View more
