Please attach data using a data step and datalines. Also, try to visualize your requirement as an output data set. What have yo tried so far?
... View more
From user perspective: there are no formatting options in quick reply. Also, after you have replied you can back out directly to the previous screen. The normal reply will back you back only to the post.
... View more
Please share the full log, with options fullstimer msglevel=i; If you have the possibility, monitor you server while your export is running (CPU, MEM, I/O).
... View more
I think you are comparing apples and pears.
Snowflake is basically a database, SAS is an analytics tool with data management capabilities.
Sure, there are some overlap.
What is your use case ad requirements?
... View more
If I remember correctly, CA should be able to collect data from all tiers.
The need to move & merge data occur if you want to assess more than one environment, e.g., dev, test, prod.
... View more
Troubleshooting 101, print the values of your operations to the LOG.
ICD10Code_1 = substr(ICD10Code,1,1);
put ICD10Code_1=;
Alignment issues can be solved using LEFT() function.
... View more
Once your prio logic is in place, you can use SQL, something like:
proc sql;
select id, pdl1, priority
from have
group by id
having max(priority) = priority
;
quit;
... View more
We have also three separate accounts.
And we have implemented AllowToDelegateTo:
mid tier SPN:
it's own host
compute host
compute SPN:
it's own host
http to mid-tier
Any external databases you wish to sso to
... View more
This will get you started. Use the macro variable in your query.
proc sql;
select name into: offer_col separated by ','
from dictionary.columns
where libname = 'WORK'
and upcase(memname) = 'HAVE'
and upcase(name) contains 'OFFER';
quit;
%put &offer_col;
... View more
You didn't read my example properly: connect using CNTPMDU; Nothing else. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0rn6hhsizv3trn1cl3e0ofosawi.htm
... View more
