I'm trying to see if I understand how the data was originally stored given how the code extracts it. I know this was Truven data, but unclear if this was csv or xpt or something else... ?
Is there a way to tell?
%let elig_list=ccaet144 ccaet114 ccaet124 ccaet134;
/*Collapse eligibility claims*/
data elig_1;
set %do i=1 %to %sysfunc(countw(&elig_list.));
%let filename = %scan(&elig_list., &i.);
raw.&filename.
%end;
;
The "set" statement in the code would indicate that this is a list of SAS datasets.
The "set" statement in the code would indicate that this is a list of SAS datasets.
I see -- thank you!
I know this was a commercial claims source. Are claims data usually stored as SAS datasets?
I'm guessing that's likely a company-specific convention. Probably a colleague of yours would be a better bet for that kind of information. Sorry.
Makes sense-- thanks!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.