Hi all,   I'm trying to create a dataset with parameter estimates to use as a source for the different program... I would like to export the estimates for parameters 49.9999 & 25 as a dataset... but I'm having problems.   Thank you in advance for help.   proc nlin data=sample; parameters x1=0 x2=0; model product= x1 * exp (x2*month) ; run; proc model data=sample; parms x1=0 x2=0; product=x1 * exp (x2*month) ; fit product; run; ... View more

Trying to get a rolling count of logins for last 3 months based on reporting month end date.   Data have: EndOfMonth_Reporting USERID LoginMDY90 31OCT2017 976 23OCT2017 30NOV2017 976 01NOV2017 30NOV2017 976 05NOV2017 30NOV2017 976 08NOV2017 30NOV2017 976 10NOV2017 30NOV2017 976 12NOV2017 30NOV2017 976 16NOV2017 30NOV2017 976 17NOV2017 30NOV2017 976 19NOV2017 30NOV2017 976 21NOV2017 30NOV2017 976 29NOV2017 30NOV2017 976 30NOV2017 31DEC2017 976 04DEC2017 31DEC2017 976 07DEC2017 31DEC2017 976 09DEC2017 31DEC2017 976 11DEC2017 31DEC2017 976 15DEC2017 31DEC2017 976 19DEC2017 31DEC2017 976 21DEC2017 31DEC2017 976 22DEC2017 31JAN2018 976 01JAN2018 31JAN2018 976 02JAN2018 31JAN2018 976 04JAN2018 31JAN2018 976 09JAN2018 31JAN2018 976 10JAN2018 31JAN2018 976 16JAN2018 31JAN2018 976 19JAN2018 31JAN2018 976 23JAN2018 31JAN2018 976 25JAN2018 31JAN2018 976 29JAN2018 28FEB2018 976 01FEB2018 28FEB2018 976 02FEB2018 28FEB2018 976 05FEB2018 28FEB2018 976 12FEB2018 28FEB2018 976 15FEB2018   Data Need:   EndOfMonth_Reporting Count LoginMD Count LoginMDY90 31OCT2017 1 1 30NOV2017 11 12 31DEC2017 8 20 31JAN2018 10 29 28FEB2018 5 23   I've been trying unsuccessfully count(EndOfMonth_Reporting) as count loginmd, sum(EndOfMonth_Reporting and EndOfMonth_Reporting-90) as Count LoginMDY90 ... View more

Hello SAS group… I need help with sas macro to create a single line for a client record depending on one column variable… There is a different number of elements each day per each client that is changing from day to day based on client’s activity.     There could be a different number of client types and elements per client each day, and I need to summarize the data based on the client number per day per client type.     Example data: Client Number Client type Element Name Element Value Element Date 0001 A Months 12 20180801 0001 A Count 500 20180801 0001 A Records 10 20180802 0001 B Months 6 20180801 0001 B Count 600 20180801 0001 B Records 1 20180801 0001 B Cycle 2 20180801 0001 B Code N 20180801 0002 A Months 2 20180801 0002 B Code E 20180802   Data I want to look like: Client Number Client type Months Count Records Cycle Code Element Date 0001 A 12 500       20180801 0001 A     10     20180802 0001 B 6 600 1 2 N 20180801 0002 A 2         20180801 0002 B         E 20180802   Thanks in advance ... View more