SAS Visual Analytics Tips & Tricks Series: Working with URL links
Recent Library Articles
Recently in the SAS Community Library: In a video tutorial, SAS' @KalleM share three use cases that reveal how URL links can be used and created in SAS Visual Analytics.
Is there a test to determine whether a column of individual student ratings (Likert 1-5) is significantly different from another column by the same rater of the same students at a later time?
... View more
Dear SAS Community, I am working with a dataset (please see below) and attempting to run a model with one AR and two MA terms. However, I’ve noticed a significant discrepancy between the results generated by PROC ARIMA and PROC AUTOREG. Below are the codes I used: proc autoreg data=a;
model consump = consumplag / method=ml nlag=2;
run; vs proc arima data=a;
identify var=consump;
estimate p=1 q=2 method=ml;
run; Any insights into why these two procedures are producing different results would be greatly appreciated. The data are shown below: yr consump consumplag 1920 39.8 1921 41.9 39.8 1922 45 41.9 1923 49.2 45 1924 50.6 49.2 1925 52.6 50.6 1926 55.1 52.6 1927 56.2 55.1 1928 57.3 56.2 1929 57.8 57.3 1930 55 57.8 1931 50.9 55 1932 45.6 50.9 1933 46.5 45.6 1934 48.7 46.5 1935 51.3 48.7 1936 57.7 51.3 1937 58.7 57.7 1938 57.5 58.7 1939 61.6 57.5 1940 65 61.6 1941 69.7 65
... View more
Hi All, I have a dataset which looks something like the example provided below. In this example, my desired output would keep only the first observation for each ParticipantID. However, I need the values for Nurse and Team to be put into this first observation (which is currently blank). So, for this example, the output for ParticipantID=1 should have StartDate=8/1/2024, EndDate=8/16/2024, EndReason=Unknown, Nurse = A, Team=1. Any suggestions?
... View more
Hi Community, I have a requirement to summarize a table with dates. Any help is appreciated. Raw data: SubjectName QueryID ParentQueryID OpenDate 0001-S002 818930 818929 21-Nov-22 0001-S002 818929 782251 21-Nov-22 0001-S002 782251 24-Oct-22 01659-S031 962154 7-May-24 01659-S031 962200 962154 8-May-24 01659-S031 962462 962200 17-May-24 Each Query has a unique ID and any Re-query has a new Query ID with the parent Query ID in a second column. I am trying to summarize the information based on the master Query ID and Query Start and Query Stop dates. Expected output: SubjectName Master QueryID Query Start QueryEnd 0001-S002 782251 24-Oct-22 21-Nov-22 0001-S031 962154 7-May-24 17-May-24 Please advise with any approach/logic. Any help is appreaciated. Thank you for your time.
... View more
Could anyone tell me why this sometimes happens if I do not explicitly include an else statement? I was expecting b321 to only equal 1 for nAtBat=321. Most of the time I have no problems with this, but once in awhile I spend half the day troubleshooting and am usually so fed up that I just add all the else statements and say good riddance. But I would like to understand why this happens. To be clear, nAtBat is the 2nd field. I appreciate any input! data bb;
retain b321 nAtBat;
set sashelp.baseball;
if nAtBat=321 then b321=1;
run;
... View more