Thanks !!! latest file name is listed in filename .Can you please provide the syntax to read this file as we are dynamically getting the file name from directory
... View more
i have used below script to get the latest csv file in directory : but the script is not working for me .can any one please help me resolve the issue. filename file1 pipe "cd /folder/sub-folder ;ls -t | head -1" ; libname file_ext 'cd /folder/sub-folder/file_ext' ; data file_ext.file2_Read ; infile file1 truncover ; input filename $100 ; put filename=; /* call symputx('lastfile',file1); */ run;
... View more
how to identify if the data extracted from metadata is latin1 or utf-8 or any other encoding ..currently we have set the current session to run in utf-8
... View more
Im getting below error while extracting metadata from sas management console. ERROR: Some character data was lost during transcoding in the dataset YYYY.PERSON. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.
... View more
Can you please help me how to get the logs from OBject Spawner ..I could see log tab in Object spwaner ,,but it has below info Current message level: Off Current threshold level: Error Either there's no log available, you may need to enable logging at a higher message/threshold level or the server appender is not defined in the log configuration file.
... View more
Will the logs be created every day for the SASApp..bcz inour system i see logs are not created everyday ..can u pls help how to create logs every day
... View more
How to enable logs for each of apps like SAS EG, Visual studio in SAS Management console . Need the user login time and end time for each session from these logs.
... View more
Log: NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized. NOTE: Table created, with 0 rows and 2 columns.
... View more
I have used like statement as below PROC SQL ; CREATE TABLE GRP1 AS SELECT C.COMP_KEY, B.COMP_KEY AS GRP_COMP_KEY FROM TB1 B , TB2 C where B.COMP_KEY like '%'||C.COMP_KEY||'%' ; QUIT; But this is not working
... View more
