I am unable to find the logic behind this.  How to find the begining and the end of the year when the week start on Saturday and end on Friday.   Does someone understand the logic of that.   /* Therefore, if the fist January 2025 is Weneday then the begining of the year will be Saturday 28, 2024 */ data demo; format date weekdatx. sat_start_of_week sat_end_of_week sat_start_of_year sat_end_of_year year_beg_date year_end_date date9.; do date='28dec2013'd to '02jan2026'd; sat_start_of_week=intnx('week.7',date,0,'b'); sat_end_of_week=intnx('week.7',date,0,'e'); year_beg_date=intnx('year',intnx('week.7',date,0,'b'),0,'beg'); year_end_date=intnx('year',intnx('week.7',date,0,'b'),0,'end'); /* sat_start_of_year=intnx('year', sat_start_of_week, 0, 'b');*/ /* sat_end_of_year=intnx('year', sat_start_of_week, 0, 'e');*/ output; end; run; proc print data=demo; run; /*create dataset*/ data original_data; format year_start_date year_end_date date9.; input year_start_date :date9. year_end_date :date9.; datalines; 28Dec2013 02Jan2015 03Jan2015 01Jan2016 02Jan2016 30Dec2016 31Dec2016 29Dec2017 30Dec2017 28Dec2018 29Dec2018 27Dec2019 28Dec2019 01Jan2021 02Jan2021 31Dec2021 01Jan2022 30Dec2022 31Dec2022 29Dec2023 30Dec2023 27Dec2024 28Dec2024 02Jan2026 ; run; /*view dataset*/ proc print data=original_data; ... View more

Hi All,   I am trying to convert the aggregate-level data into individual-level data. I would really appreciate the help.   I have the following data:   data temp; input clinic $ Agegrp$ TotalPatient TotalFemale FemaleMedReceived TotalMale MaleMedReceived; datalines; ABC 1-5 104 56 2 48 0 ABC 6-10 232 111 16 121 13 ABC 11-15 192 108 4 84 3; run;   Table I have: Clinic Age Group Total Patients Total Female Female Medication received Total Male Male Medication received ABC 1-5 104 56 2 48 0   6-10 232 111 16 121 13   11-15 192 108 4 84 3   I want to create individual-level data from the above numbers. For example, the table I want should have each row with clinic and age group (1-5), with 56 females - 2 of those should receive Medication (Yes), and 54 should not receive medication (No). The same is true for males 1-5 years old (48 males—0, medication (Yes) and 48 medication (No)).    The table I want has a total of 528 rows: Clinic Age Group Gender Medication Received ABC 1-5 F  Yes ABC 1-5 F Yes ....... .... .... .... ABC 1-5 M No ABC 1-5 M No ...... .... .... .... ABC 5-10 F Yes     Thanks, @sandyzman1 ... View more

I am using deployment manager to add certificates in truststore using the below command on linux which works fine. ./sasdm.sh -console   Now, I want to automate this process of adding latest certificates, so I'm trying to run it in quiet mode (with response file) which runs fine when I run the command manually on the server. However when I'm running the same command from a pipeline (ansible shell module), it gives error. Is there a way to run it without login to the terminal.   Command- /opt/sas/bin/SASDeploymentManager/9.4/sasdm.sh -lang en -loglevel 2 -quiet -responsefile '/opt/sas/bin/SASDeploymentManager/9.4/sasadm_add_cert_root_reponse.txt' -templocation '/opt/sas/saswork/temp' -console   The error is - Error: Your DISPLAY environmental variable has not been set. Please set it and run this application again.   ... View more

We are unable to start or check the status of services, and we are getting ‘killed’ as a response to every command query. Any suggestions on how we can fix these issues?       ... View more

I am analyzing data from a survey that was implemented in multiple countries. I am working with the assumption that the responses from subjects from the same country are more likely to be similar (within country correlation). How do I account for this in proc surveylogistic? Is it possible to account for this in proc surveylogistic? ... View more