BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
cdubs
Quartz | Level 8

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;
		; 
1 ACCEPTED SOLUTION

Accepted Solutions
collinelliot
Barite | Level 11

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

View solution in original post

4 REPLIES 4
collinelliot
Barite | Level 11

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

cdubs
Quartz | Level 8

I see -- thank you! 

 

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

collinelliot
Barite | Level 11

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.

cdubs
Quartz | Level 8

Makes sense-- thanks! 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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