Hi,   When I am trying to move across a large dataset into python using SAS.sd2pd(''), i get an error where it says the socket connection failed - this only happens with the large dataset i have so i want to know if there is anyway around it?   Thanks ... View more

Hi all,   I am currently having an issue with disk space in SAS when using CAS, unfortunately there is no option to increase the disk space. So wanted to know what I could do to reduce the file size in CAS and if there are any process that will help, so basically small overview of what I am trying to do - i am loading 4 datasets into the CAS area and then joining them using a proc fedsql. This process did work with only three datasets, but now I have added the fourth it is problematic.    Thanks in advance. ... View more

Hi all,   I am trying to leverage some of the benefits of proc fedsql and cas, however I am facing some issues with the syntax in comparison, previously when i tried to filter rows using proc sql I just used a where clause, however when i do the same using proc fedsql, I get a error saying the column name exist for the filter value I am trying to apply:   WHERE VAR = "PROD";   It will return an error saying the column "PROD" does not exist or cannot be accessed, so I just want to understand the syntax difference that is more than likely causing this. ... View more

Hi,   I am running some code on Viya, but the second that I run one data step with an %include statement which scores data according to a logistic regression code file created above, I am no longer able to view any columns from that dataset and any datasets created after that. I have also made some changes to the code and had it where it is saying no items are available despite being created in the log, and when you go to look at the data the column names are completely different to what is being calculated and are from an earlier data step - when you click on the actual column to filter you can see the correct column names but outside of that it doesnt work.  ... View more

Is there any way of replicating proc surveyselect in CAS for bootstrapping datasets - I have found sampling.srs action but can't seem to get the code working and as a second point proc surveyselect returns the number of times a row has been selected can we do the same with sampling.srs  ?  ... View more