Hi all,   I have to read a Mainframe PDS which is having SAS Program members in it by passing the PDS using a JCL. I have to read one by one and have to get the creation date and user_id as highlighted in below snap. Please help me with the SAS Code logic for the same.   thanks in advance thalla ... View more

Hi Team,   I am reading a comma ( , ) delimited file using IMPORT DATA Task in SAS Enterprise guide 8.3. I am getting the data as expected while reading the file but when see the code generated by IMPORT DATA Task the delimiter value is showing in HEX converted value.   Ex: In my file comma is the delimiter and usually I have to see it as DLM=',' In the code but i am seeing as DLM='2c'x . Can anyone help me if there is any option to see the delimiter as comma ( , ) instead of HEX Value.   thanks in advance, thalla ... View more

Hi Team,   I am using DB2 Database to manage my clients data and connecting through SAS Enterprise Guide 8.3. Can anyone help me how to load some data into a table in my DB2 database.   In the DB2 database We have the subsystem architecture to access the database and it's table. For Ex: We have the subsystems like DBT1, DBT2 etc.., and under these subsystem we have some databases defined and then tables are created in those databases. My requirements is I have table (DBT1 --> T1101015A --> prsn_data Here DBT1 is subsystem, T1101015A is the database and PRSN_DATA is the table name. Please help to load some data into PRSN_DATA table using DBLOAD PROC in SAS Enterprise Guide.   thanks in Advance, thalla ... View more

Hi Team, I have created a Project in SAS Enterprise Guide with 2 Process Flows added in it. In the First process Flow I have created some PROMPTS and they are added in a program to get the inputs from user while running the Project. And the Inputs taken from user from the PROMTS in first process flow need to be passed into second process flow where the user will write actual code in second process flow. And we don't want all the users to see the code what was in first process flow. So do we have any option to hide a process flow in a SAS EG Project ?   thanks in advance, Thalla ... View more

Hi Team,   I have created a Stored Process in SAS Enterprise Guide 8.3. Now I have to save it in server and it has to be auto called in codes ran by my users list by default. Can anyone on this group help me to achieve this??   thanks, Thalla ... View more

Hi Team,   We have installed SAS EG 8.3 Newly, and connecting DB2 for querying data using Query builder Tool. We are using the Pass Through SQL option in this database connect and need to get the schema included in the Passthrough SQL Option to recognize which database used for data retrieval. So this include schema option is to be enabled manually by user every time. So is there anyway to make the "Include the Schema" by default in Query Builder ??   thanks, Thalla ... View more