Manipulating Data in Base SAS® Part 3 – Deduplicate
Recent Library Articles
Recently in the SAS Community Library: Duplicates in data can badly skew the results of an analysis. @SASJedi demonstrates data deduplication using PROC SORT with the NODUPKEY, OUT=, and DUPOUT= options and PROC SQL and PROC FedSQL
Hello, I am trying to calculate the difference between the data observed in 2023 and 2024 by month. I have a total of 84 observations and need to calculate the difference between all 12 months. Below is a sample of how the data is formatted. data Have;
input id 23Jan 23Feb 23Mar 24Jan 24Feb 24Mar;
datalines;
1 0.54 0.54 0.52 0.62 0.61 0.60
2 0.48 0.45 0.48 0.71 0.68 0.67
3 0.59 0.61 0.59 0.57 0.54 0.58
4 0.61 0.62 0.59 0.62 0.61 0.54
; I want a dataset that contains the difference for each month for all 84 observations. Data Want;
ID JanDiff FebDiff MarDiff
1
2
3
4 I know I can write out all 12 calculations but is their a more efficient coding strategy to calculate the differences? Thanks in advance
... View more
Hi I was wondering if there are sas help pages or any documentation around SAS Viya 4 support for Oracle Linux OS & containerization. I want to know if Linux Oracle supported and what versions? I had a look through the following , but found nothing on Linux Oracle OS Support : https://go.documentation.sas.com/doc/en/itopscdc/v_052/itopssr/titlepage.htm https://go.documentation.sas.com/doc/en/itopscdc/v_052/itopscon/n12fgslcw9swbsn10rva4bp0mr2w.htm
... View more
Hi SAS Communities,
We'll be soon migrating to SAS VIYA 4 any tips regarding logging?
Where can we see the logs for the services now is it still on the default location /opt/sas/viya/config/var/logs?
... View more
Hi guys,
suppose to have the following dataset DB. Is there a way to get DB1? In other words where there are repeated (identical) dates the Index should be 1. NB: all IDs have only one record (row) where Index = 1.
Thank you in advance
data DB;
input ID :$20. Admission :date09. Discharge :date09. Index;
format Admission date9. Discharge date9.;
cards;
0001 13JAN2017 25JAN2017 0
0001 13JAN2017 25JAN2017 1
0001 22FEB2018 03MAR2018 0
0001 30JAN2019 04MAR2019 0
0002 01DEC2018 14DEC2018 1
0002 01DEC2018 14DEC2018 0
0003 09JAN2016 25JAN2016 1
0003 29JAN2018 12FEB2018 0;
run;
data DB1;
input ID :$20. Admission :date09. Discharge :date09. Index;
format Admission date9. Discharge date9.;
cards;
0001 13JAN2017 25JAN2017 1
0001 13JAN2017 25JAN2017 1
0001 22FEB2018 03MAR2018 0
0001 30JAN2019 04MAR2019 0
0002 01DEC2018 14DEC2018 1
0002 01DEC2018 14DEC2018 1
0003 09JAN2016 25JAN2016 1
0003 29JAN2018 12FEB2018 0;
run;
... View more