Sorry. I need one more info. Cas we have CAST kind of functionality outside pass through query. To use CAST function in later step . I have to load the dataset in PG schema and then I am using CAST . Can we remove the LOADING overhead and use CAST like functional in PROC SQL itself . Thank You! ... View more

Thank for the info. Getting UUIDS from a different macro variable . ... View more

Thanks. Yes my bad .let me add some more . I have source name as InventoryFulfillment though it is throwing error for libname but other operation worked fine. I am not getting what is actual issue. normal: SYMBOLGEN: Macro variable MP_SOURCENAME resolves to InventoryFulfillment normal: SYMBOLGEN: Macro variable VF_LIB resolves to InventoryFulfillment normal: SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. error: ERROR: InventoryFulfillment is not a valid SAS name. error: ERROR: Error in the LIBNAME statement. normal: MPRINT(X): proc casutil; note: NOTE: The UUID '227b59b2-fcf9-e64a-aa96-e6abec55e82e' is connected using session CASAUTO. normal: SYMBOLGEN: Macro variable PLAN_LIB resolves to planning normal: SYMBOLGEN: Macro variable INPUTTABLE resolves to OUTFOR_102 normal: SYMBOLGEN: Macro variable INPUTTABLE resolves to OUTFOR_102 normal: SYMBOLGEN: Macro variable VF_LIB resolves to InventoryFulfillment normal: SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. normal: MPRINT(X): load data =planning.ed_OUTFOR_102 CASOUT="ed_OUTFOR_102" OUTCASLIB="InventoryFulfillment" replace; note: NOTE: PLANNING.ED_OUTFOR_102 was successfully added to the "InventoryFulfillment" caslib as "ED_OUTFOR_102". normal: MPRINT(X): create table InventoryFulfillment.tmp_OUTFOR_102 as select a.* ,b.time_id as start_dt_sk from normal: InventoryFulfillment.OUTFOR_102 a, InventoryFulfillment.ed_OUTFOR_102 b where a.start_date between b.start_date and b.end_date; note: NOTE: CASDAL driver. Creation of a DATE column has been requested, but is not supported by the CASDAL driver. A DOUBLE PRECISION note: column will be created instead. A DATE format will be associated with the column. note: NOTE: Table TMP_OUTFOR_102 was created in caslib InventoryFulfillment with 779282 rows returned. normal: MPRINT(X): quit; ... View more

Thank you for your response. Just wanted to add here that The X macro variable can have other values Like Public and other CAS libs This macro is not working when I pass the X value as Public ... View more

Thank you. This worked. Just have doubt about limitation of number of observation can be stored in X macro variable using %let . here in example I have mentioned only 3 observation. I need to store around 2000 to 3000 observation in this. will this work ? ... View more

Thank you. Also I have one doubt. will this &x will this be able to store around 2000 observation values , like here we have 3 observation only separated by comma %let x =%nrstr(f588c556-15c4-4d59-b9df-88b2c655a950,06d54597-fc35-459b-bc5e- 1075e9643a1d,06d54597-fc35-459b-bc5e-2137e9643a1d); ... View more

Thank you all for your response. I can not post my log here, due to privacy issue. I can't copy those datasets in my local .   Coming to the solution part, As I didn't get any solution, I am trying to replace the complete macro step with a table cretion  e.g  proc sql; select xyz into  : abc separated by ',' from large_data; quit;     is replaced with proc sql; create table temp as  select distinct xyz from large_data quit;   Thanks! ... View more

Thanks for your response. The issue is the distinct value , I need to use all in later steps. This distinct table won't be used later. I need to use list of values all together in later steps ... View more

Hi @Erik , I have tried this, but issue is I need list of distinct values to be used in later step. I can't use those steps in loopmylist ... View more

Thank you. Distinct value is around 6 thousand, and each value is of length 30 char ... View more

Thank you! I will give it a try. Also good to know that is problem is known. We can find some solution.  ... View more