About chirumalla

chirumalla · ‎10-21-2014

Hi, My SAS scripts generating some warning messages. when I run this scripts in LSF warnings consider as a errors and jobs become red and exit the flow. is any option or method to suppress/ignore warnings in LSF scheduler.

chirumalla · ‎07-09-2014

Hi, I need to move txt and excel and sas datasets from one location to another location. I can't use X command an Systask commands due to certain server limitations. am using proc datasets move. but am able to move only sas data sets. pls advise me how to move all type of files. libname SR "C:\source"; libname TG "D:\Target" ; PROC DATASETS; COPY IN=SR OUT=TG MOVE MEMTYPE=ALL; RUN; quit; libname SR CLEAR; libname TG CLEAR;

chirumalla · ‎05-20-2014

Hi, I am using below code to store values in macro variable based on this vales I need to delete vales from target table but INTO clause default taking only first value pls help me how to get all values in macro variable. data export; input id num; cards; 1 10 2 20 3 30 ; run; proc sql; select num into: nu from work.export; quit; %PUT ν 15 proc sql; 16 select num into: nu from work.export; 17 quit; 18 %PUT ν 10 I need all value 10 20 30 in &nu please help me and is their any alternate way suggest me.

chirumalla · ‎04-24-2014

Hi monthly I will receive weekly datasets like XYZ_WK1, XYZ_WK2. few months I will receive 4 and few months 5. when I use SET/APPEND to Append data to Base table when one file is missed showing error message how to over come irrespective of datasets number need to append all data sets which are available. data SOURCE.XYZ ; set TARGET.XYZ_wk1 TARGET.XYZ_wk2 TARGET.XYZ_wk3 TARGET.XYZ_wk4 TARGET.XYZ_wk5 ; run; or proc append base=SOURCE.XYZ data=TARGET.XYZ_wk1; run; proc append base=SOURCE.XYZ data=TARGET.XYZ_wk2; run; proc append base=SOURCE.XYZ data=TARGET.XYZ_wk3; run; proc append base=SOURCE.XYZ data=TARGET.XYZ_wk4; run;

chirumalla · ‎04-14-2014

Thanks Reeza...it's working...:)

chirumalla · ‎04-13-2014

Hi I'm using Proc datasets moving option to moving data from one library to another if datasets not available I need to capture Warning/error from code. Same&syserr macro working in data step but not working in proc datasets. pls advise me how to capture error. /*1-WORKING*/ data NULL; set doesnotexist; run; %put &syserr; /*2-NOT WORKING*/ PROC DATASETS; COPY IN=Source OUT=Target MOVE MEMTYPE=DATA; RUN; %put &syserr;

chirumalla · ‎04-13-2014

Hi I'm using Proc datasets moving option to moving data from one library to another if datasets not available I need to capture Warning/error from code. Same &syserr macro working in data step but not working in proc datasets. pls advise me how to capture error. /*1-WORKING*/ data NULL; set doesnotexist; run; %put &syserr; /*2-NOT WORKING*/ PROC DATASETS; COPY IN=Source OUT=Target MOVE MEMTYPE=DATA; RUN; %put &syserr;

chirumalla · ‎03-14-2014

Hi, I have developed programs in SAS development here my library name like ABC.dataset but in UAT library name is different like DBA.dataset now i'm manually using ctrl + H and replacing lib name. is any other option/ functions available to find the code and replace the code if I write at starting in the program. pls help me.

chirumalla · ‎02-13-2014

Hi I tried this still I'm facing same issue pls help me how to resolve if possible give me code. data _null_; x = intnx('MONTH',today(),-1,'SAMEDAY'); %put &x; run; see below log ================================================ 15 data _null_; 16 x = intnx('MONTH',today(),-1,'SAMEDAY'); 17 %put &x; WARNING: Apparent symbolic reference X not resolved. &x 18 run;

chirumalla · ‎02-13-2014

Hi All, I'm using below code to get last month data set when I try to run first time it's giving error/warning and if I ran same code again it's running successfully and giving vales how to trouble shoot this first run issue. pls advise me. %LET JOBNAME=acardact_; data _NULL_; date1=intnx('MONTH',today(),-1,'SAMEDAY'); CALL SYMPUT("LOAD", TRIM(LEFT(PUT(DATE1, YYMMN6.)))); LOAD_T= "&JOBNAME"||"&LOAD"; CALL SYMPUT ("LOAD_DATE", LOAD_T); %PUT &LOAD_DATE; run; Expecting value----- acardact_201401 LOG 124 %LET JOBNAME=acardact_; 125 data _NULL_; 126 date1=intnx('MONTH',today(),-1,'SAMEDAY'); 127 CALL SYMPUT("LOAD", TRIM(LEFT(PUT(DATE1, YYMMN6.)))); 128 LOAD_T= "&JOBNAME"||"&LOAD"; WARNING: Apparent symbolic reference LOAD not resolved. 129 CALL SYMPUT ("LOAD_DATE", LOAD_T); 130 %PUT &LOAD_DATE; WARNING: Apparent symbolic reference LOAD_DATE not resolved.

chirumalla · ‎02-07-2014

Hi I have same issue but I have files in SAS library/folder how can i use this code. pls help me

chirumalla · ‎02-06-2014

Hi, I have 50+ data sets having different lengths with date extension, I want to read only date part from data sets and store in a variable for time stamp. pls advise me how to read date part from data set name. TEST_201312.sas7bdat TEST__MONTH_201312.sas7bdat TEST__YEAR_201312.sas7bdat

chirumalla · ‎01-28-2014

Hi Pradeep, Thanks for your answer, as you suggested I given job level but the client asking flow level statistics in one table. LSF is capable to produce flow statics if pls advise me.

chirumalla · ‎01-28-2014

Hi, In LSF scheduler I have 15 jobs in one flow I need all jobs statistics in one table for client view like Job name, Start time, End time, Total time, Status. Is any option in LSF to get all statistics in single view. pls help me bit urgent.

chirumalla · ‎01-23-2014

Hi, In DI studio development. I have data in DI server I want to append this data into EBI server datasets and I need to use trigger file in DI server for LSF jobs. both are different servers and in different environment(Not using Spds). advise me how to connect both servers. if any sample code pls share with me.

Online Status	Offline
Date Last Visited	‎10-19-2016 11:03 AM

Re: Character to numeric convertion

Re: Character to numeric convertion

Re: Character to numeric convertion

Character to numeric convertion

Update table code

Re: compare 2 date values in YYYY.WK format

Re: compare 2 date values in YYYY.WK format

compare 2 date values in YYYY.WK format

Re: DI Studio 4.6 Not able to delete transformation from job

DI Studio 4.6 Not able to delete transformation from job

Re: &syserr macro not working in Proc data sets

Re: How to read sas data set having date extentions

LSF warnings issue

Moving Txt and exls files

INTO Clause issue storing values in macro

Appending/Set datasets issue

Re: &syserr macro not working in Proc data sets

&syserr macro not working in PROC DATASETS

&syserr macro not working in Proc data sets

FIND AND REPLACE CODE

Re: Apparent symbolic reference not resolved for first run

Apparent symbolic reference not resolved for first run

Re: Get the max date of a file in the directory

read only date part from data set name

Re: update control table information

How to get LSF flow jobs information in table

Copy datasets in different serves