Hello gays,
need help , as new sas programmer , i am in phase to finish my project so, i need to create a variable accally a binary variable from my date, this is a type of date who i dealing with
ANM_id lact_no start_date service_date NNR
111 1 2013-01-06 2013-03-15
111 1 2013-01-06 2013-04-04
111 2 2014-01-10 2014-04-21
111 2 2014-01-10 2014-05-10
222 1 2015-10-01 2015-11-15
222 2 2016-01-01 2016-02-06
222 2 2016-01-01 2016-02-26
i need to assign 1 if within a specific period (56 days) from start date there will be one or more service date less than 56 days , otherwise NRR = 0 if there are a service after 56 days.
Thank all
Regards
You should show some worked examples.
I am having a hard time following which values are compared for this: "i need to assign 1 if within a specific period (56 days) from start date there will be one or more service date less than 56 days , otherwise NRR = 0 if there are a service after 56 days."
Are you intending to use only the service_date for each observation or compare other dates?
IF your start_date and service_date are actual SAS date values you can get the number of days by either subtraction or the Intck function and the interval of days:
Days_between = service_date - start_date;
or
Days_between= intck('day',start_date,service_date);
nnr = (0 <= (service_date - start_date) <= 56);
Assuming that your date values are stored as SAS date values.
For complete, tested code supply example data in a data step with datalines, so we can create an exact replica of your dataset with a simple copy/paste and submit.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.