cant really get how can i make SAS code node read what it receives from previous node. A simple  PROC print data=source; run;   Any help on this will be highly appreciated. We have a client demo next week and I need to resolve this ASAP. I am quite new to sas.     ... View more

But this link says "You can use the SAS Data Set Connection dialog to connect to a folder that contains one or more SAS data sets" I dont have sas datasets. Infact i m trying to convert my Azure SQL DB tables into SAS datasets. How to do that. I tried using worktables but i cant see my sas codes finding them. Where can i see work library. Either i convert all my Azure table into SAS dataset though Libname or dataflux handles . But neither of the option works. LIBNAME Azure ODBC DSN=pocsqldbdhs user=CCCCCC pw=XXXX schema=ABC; ERROR: The ODBC engine cannot be found. ERROR: Error in the LIBNAME statement. the value in the DSN is the windows connection to the server on our local machine. Even the work table writers and readers are working . Reader is reading only one record at a time while i want it to publish the whole table output to SAS code node. Kindly suggest. ... View more

Thanks for you reply SASKiwi. Can you please also share the documentation page regarding this connection setup as i fail to find much information on the setup ... View more

Hi RonAgresta, Thanks for reverting. I checked the mentioned business rule functionality but i failed to understand how SAS pattern outcomes can be compared to the patterns i have. Like if i have a table with fields name and the pattern they should follow. Example: Fieldname,format Address Australian postcode,{NNNN} where N is a number   Now i fail to understand how to do the profiling referening this table. I want to highlight those records in the incoming csv files which do not follow the above pattern. Now the roadblocks are: 1)SAS profiling patterns analysis gives outcomes in A and 9 which will not follow the rules which i will create on the business rule manager 2) if in data job i can run some sas codes to bring these pattern annotations in one version , i can do some comparisons and create flags. 3) I could not find how to profile date fields to understand whether its DDMMYY or MMDDYY etc format. I have to give everything in string to get the pattern analysis outcomes. But then it give 99/99/99 . How does it help if i need to parse and create more rules to identify the data format?   Appreciate more help in these please.   Regards, Shikha   ... View more