Recently in the SAS Community Library: Your often contains the information you need, but not sequenced in the order required for processing. @SASJedi shows you how to properly sequence data so you can compare the data in one table to the data in another, conduct merges or joins and more.
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 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
How do I export a missing string variable to a json file as null rather than ""? SAS Code: data mydata;
INFILE DATALINES DLM='|';
Length CODE 3 Name $ 50;
Input CODE Name;
datalines;
11|Bob
12|Joe
13|Larry
;
run;
data newdata;
length status $2.;
format status $2.;
informat status $2.;
set mydata;
if name = "Joe" then
do;
status=.;
code=.;
end;
else status='Y';
run;
proc json out="P:\newdata.json" pretty NOSASTAGS;
export newdata;
run; Here's what the exported json looks like: [
{
"status": "Y",
"CODE": 11,
"Name": "Bob"
},
{
"status": "",
"CODE": null,
"Name": "Joe"
},
{
"status": "Y",
"CODE": 13,
"Name": "Larry"
}
] Here's what I want (i.e. status for Joe should be null rather than "": [
{
"status": "Y",
"CODE": 11,
"Name": "Bob"
},
{
"status": null,
"CODE": null,
"Name": "Joe"
},
{
"status": "Y",
"CODE": 13,
"Name": "Larry"
}
]
... View more