DATA Step, Macro, Functions and more

How was this data stored?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

How was this data stored?

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;
		; 

Accepted Solutions
Solution
3 weeks ago
PROC Star
Posts: 307

Re: How was this data stored?

The "set" statement in the code would indicate that this is a list of SAS datasets.

View solution in original post


All Replies
Solution
3 weeks ago
PROC Star
Posts: 307

Re: How was this data stored?

The "set" statement in the code would indicate that this is a list of SAS datasets.

Occasional Contributor
Posts: 13

Re: How was this data stored?

Posted in reply to collinelliot

I see -- thank you! 

 

I know this was a commercial claims source. Are claims data usually stored as SAS datasets?

PROC Star
Posts: 307

Re: How was this data stored?

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.

Occasional Contributor
Posts: 13

Re: How was this data stored?

Posted in reply to collinelliot

Makes sense-- thanks! 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 97 views
  • 1 like
  • 2 in conversation