About sasikala

sasikala · ‎11-05-2020

Hi All, How to read the XML file and convert into SAS file without using SAS mapper (map file). we are panning create SAS utility,That should support different structural XML file.

sasikala · ‎10-30-2020

Hi KurtBremser, The DB records will be inserted by other process and I don't have control to update or modify it to schedule my job along with it.so my job should run independently, if some new entry is present in the DB table, need to fetch it and invoke the data load process. Thanks, Sasi.K

sasikala · ‎10-30-2020

Thanks! This helps lot

sasikala · ‎10-29-2020

Thanks for the update. My requirement is , need to check the DB table entry, in case new record inserted by other job, need to fetch that record immediately and execute the SAS job load the data into DB. My sas job should be running independently to check entry in DB table .. if new entry present , It should load data immediately Thanks, Sasi.k

sasikala · ‎10-29-2020

Hi Experts, I need to keep sas session alive for all time and in some time frequency (Call sleep()) call macro and execute it. I am thinking to schedule the SAS script in unix nohup and clear sas tmp space frequently part sas script. Could you please let me know if there any disadvantage of keeping SAS session alive for all time by nohup. Thanks, Sasikala.k

sasikala · ‎10-12-2020

Hi Experts, We are updating our code to use xpt2loc macro to extract the V6 and V8 format xpt file. Kindly help me with the below queries. What is pros and cons of using xpt2loc macro? Why libname xport is not supporting the V8 format xpt file which is created by loc2xpt macro? What is the different in using xpt2loc macro and libname xport proc copy for extracting files? Thanks, Sasikala.k

sasikala · ‎10-12-2020

Thanks Tom

sasikala · ‎10-09-2020

Hi Experts, Will SAS 9.4 support to create a dataset in UTF-16 encoding format. Could you please tell ,is there anyway to create dataset in UTF-16 format. Thanks, Sasikala.

sasikala · ‎10-05-2020

Thanks Tom. This helps.

sasikala · ‎09-24-2020

Thank you so much.! Tom. I understand, we can read only OLD version if XPT and CPORT in SAS V9 and can not create it. Colud you please help me on below quries - 1. Is there any way to programatically identify the XPT is created by libname XPORT engine or LOC2XPT macro ? 2.Will XPT2LOC macro support to extarct the all old version XPT files and, V8 and V9 XPT file created by Libname XPORT engine ? 3. I understand V5 XPT and V8 XPT has its own format as documented in https://documentation.sas.com/?docsetId=movefile&docsetTarget=n1xbwdre0giahfn11c99yjkpi2yb.htm&docsetVersion=9.4&locale=en. My understaing here 1. The V5,V6 and V7 version XPT will support only for V5 XPT formats 2. The V8 will support only form V8 xpt format 3. The V9 will support for both V5 and V8 (VALIDMEMNAME=EXTEND option for V8) 4. Is XPT file version specific to SAS release version ? i mean V6 XPT file can be created by SAS V6 ? Please Correct my understanding on point 3 and 4. Thanks in advance !

sasikala · ‎09-22-2020

Hi Experts, How can we create the different version of XPT file in SAS 9.4 ?? I need the xpt V4,V5,V6,V7 and V8 file for testing . Thanks, Sasi.k

sasikala · ‎03-11-2020

Thanks Tom.

sasikala · ‎12-03-2019

Hi Guys ! One more requirement, I needed get the CPORT or XPORT file encoding and store it in another variable . Any idea ? Thanks, Sasikala.k

sasikala · ‎12-03-2019

Thanks All !.

sasikala · ‎11-29-2019

Hi Friends, I need to capture the encoding type of dataset in 1 macro variable for further process. Proc contents is displaying encoding type in .lst file . I need to capture it in one variable . Can we find encoding type of dataset in any internal SAS metadata dataset ? Thanks, Sasikala.k

Online Status	Offline
Date Last Visited	‎12-22-2020 07:25 AM

Convert the XML file to SAS datasets

Re: Pros and Cons of Keep Base SAS session alive for all time

Re: Pros and Cons of Keep Base SAS session alive for all time

Re: Pros and Cons of Keep Base SAS session alive for all time

Pros and Cons of Keep Base SAS session alive for all time

XPT2LOC Macro VS Libname XPORT Proc copy

Re: Creating SAS dataset with UTF-16 encoding format

Creating SAS dataset with UTF-16 encoding format

Re: How to create V5 xpt file in sas 9.4

Re: How to create V5 xpt file in sas 9.4

Re: XML LIBNAME reading data from URL

Re: Convert the XML file to SAS datasets

Re: Pros and Cons of Keep Base SAS session alive for all time

Re: Pros and Cons of Keep Base SAS session alive for all time

Re: How to create V5 xpt file in sas 9.4

Convert the XML file to SAS datasets

Re: Pros and Cons of Keep Base SAS session alive for all time

Re: Pros and Cons of Keep Base SAS session alive for all time

Re: Pros and Cons of Keep Base SAS session alive for all time

Pros and Cons of Keep Base SAS session alive for all time

XPT2LOC Macro VS Libname XPORT Proc copy

Re: Creating SAS dataset with UTF-16 encoding format

Creating SAS dataset with UTF-16 encoding format

Re: How to create V5 xpt file in sas 9.4

Re: How to create V5 xpt file in sas 9.4

How to create V5 xpt file in sas 9.4

Re: Need to store Dataset encoding type into variable

Re: Need to store Dataset encoding type into variable

Re: Need to store Dataset encoding type into variable

Need to store Dataset encoding type into variable