About Badshaah

Badshaah · ‎12-13-2016

It's just sample data .. If 28nov2016 is max then max -1 months 30oct2016 is also needed but we have to convert date9. To monyy7. Format which only extract month and year.

Badshaah · ‎12-13-2016

We have two calculate only last month which max of month and .. Second last month

Badshaah · ‎12-13-2016

employee_ Obs id jobcat transmonth wage rating 1 1254 one 29AUG1998 $11000.00 2 2 9936 two 17OCT1998 $5,000.00 0 3 7529 two 04NOV1998 $9,000.00 1 4 9154 one 25NOV1998 $10000.00 2 5 7741 two 18NOV1998 $9,500.00 3 6 8896 two 11OCT1998 $9,600.00 4 7 6658 one 01MAY1999 $12000.00 4 8 7854 two 27OCT1998 $9,600.00 3 9 9458 two 13NOV1998 $8,999.00 1 10 7887 two 19OCT1998 $9,050.00 0

Badshaah · ‎12-13-2016

It's form base table having variable in date9 format

Badshaah · ‎12-13-2016

We have single data table in which we only required last month data , So i can calculate last date by max date but ..need logic for second last month.

Badshaah · ‎12-13-2016

Grand salute gamotte.

Badshaah · ‎12-13-2016

If we have past all month file and , new file with current month then how we calculate the that current month from one file and last month from all month file Percent difference

Badshaah · ‎12-03-2016

Thanks for kind support, u nailed it

Badshaah · ‎12-02-2016

Well thanks for support.

Badshaah · ‎12-02-2016

Thanks for support,.. Can we simplify this code..

Badshaah · ‎12-02-2016

Great... Whatever the thing...i manage.. But i was really curious and wondering that was even possible and how ?

Badshaah · ‎12-02-2016

Excel is a requirement to my client ...so how automate the code ? So we don't need to think about size(no. Of obs) . Automatically record's get divide and store in different sheets of same excel.

Badshaah · ‎12-02-2016

Record are to high sas must divide data according to record size (observation) and produces export excel.

Badshaah · ‎12-02-2016

Thanks KurtBremser , Sir Really appreciated

Badshaah · ‎12-02-2016

For example if date is 21feb2016 then Output is like : 21feb2016 22feb2016 23feb2016 _ _ _ _ _ _ _ _ 02dec2016(today)

Online Status	Offline
Date Last Visited	‎03-31-2017 05:47 AM

Re: Above value getting repeated when blank values shown.

Re: Above value getting repeated when blank values shown.

Above value getting repeated when blank values shown.

How take data according to date less than 3 months

Re: How make condition macro to run dataset

How make condition macro to run dataset

Re: How find first date of month whenever i run that code .

How find first date of month whenever i run that code .

Sas export title and footnote is showing properly

Re: How export multipe file in same excel with different sheet

Re: How take data according to date less than 3 months

Re: How make condition macro to run dataset

Macro function to output yesterday's date

Re: How find first date of month whenever i run that code .

Re: Sas export title and footnote is showing properly

Re: How filter last month and previous month data from date column

Re: How filter last month and previous month data from date column

Re: How filter last month and previous month data from date column

Re: How filter last month and previous month data from date column

How filter last month and previous month data from date column

Re: How to trend the last two months (difference in percent)

How to trend the last two months (difference in percent)

Re: How divide dataset into multiple sheet on same excle

Re: How divide dataset into multiple sheet on same excle

Re: How divide dataset into multiple sheet on same excle

Re: How divide dataset into multiple sheet on same excle

Re: How divide dataset into multiple sheet on same excle

How divide dataset into multiple sheet on same excle

Re: How take all dates from curtain date to current date

How take all dates from curtain date to current date