About DMIN

DMIN · ‎08-01-2019

data master; retain name fname lname drug date; input fname $ lname $ drug: $9. date: mmddyy8.; format date mmddyy8.; name=cat(fname,lname,' '); cards; John smith adderall 12/28/17 John smith adderall 12/21/17 John smith oxycodone 11/14/17 jane doe adderall 2/14/18 jane doe oxycodone 1/10/18 jane doe adderall 12/21/17 ; run; proc sort data=master; by name drug descending date; run; data master_result; set master; by name drug descending date; if first.drug then output; run;

DMIN · ‎05-03-2019

Dataset names are either in work library or in permanent libraries, so their names should be identified by following work or other library names when creating shellscripts. Unfortunately, i don't have the scripts at hand. Hopefully other guys can help.

DMIN · ‎05-03-2019

It seems you'd better write shell scripting codes to capture these file names.

DMIN · ‎05-03-2019

C is correct for sure. The answers given are not always correct sometimes, i know this when preparing for the SAS certification exams.

DMIN · ‎05-02-2019

try this below to see if it's what you need. Proc sql; create table test2.withinyear AS select * from test2.alldata where year(event_time_timestamp) = 2018 group by case_purchasing_document quit;

Online Status	Offline
Date Last Visited	‎02-28-2024 10:27 PM

Re: Proc sql selecting most recent date depending on a second variable

Re: Finding datasets name in log directory

Re: Finding datasets name in log directory

Re: Question on in-line views?

Re: how do i delete caseIDs with timestamps on events outside of a giv...

Re: Question on in-line views?

Re: Finding datasets name in log directory

Re: Proc sql selecting most recent date depending on a second variable

Re: Finding datasets name in log directory

Re: Finding datasets name in log directory

Re: Question on in-line views?

Re: how do i delete caseIDs with timestamps on events outside of a giv...

SAS Analytics Explorers