Hello, I'm new to SASPy. I previously used R extensively but am currently migrating for performance reasons. I'm first creating a table that provides a list of members. Next, I want to create a proc sql data request using that list of members. I tried creating a string that looks like this: ('55555', '64646', '97979', ...) and feeding that into my proc sql statement. However, there seems to be a character limit. I'd prefer not to chunk the list up, do a for loop, and then union the data. How can I add this list to my proc sql statement to make it work? Example of method that doesn't work because my string is too long (but works when I have a short string of members): %%SAS
libname csf "path";
PROC SQL;
CONNECT TO TERADATA(&TD);
CREATE TABLE csf.data_table as
Select * FROM CONNECTION TO TERADATA
(
select
a.member,
a.clm_nbr,
a.aud_nbr,
from
db.a a
where
a.member in &mbr_str.
);
DISCONNECT FROM TERADATA;
QUIT;
... View more
