My program works fine when the dataset did not come from SAS Viya. However, if it came from viya, i receive this error:   ERROR: Array subscript out of range at line 52 column 3.   Below is the program. It throws an error the moment I add statuses(schedule_id) = return_cd1 and date_stat(schedule_id) = LOG_END_DTTM:   %macro arrange; %do i=1 %to %trim(&cnt.); /*In order for data step Job_Sch_Merge2 logic to work correctly, each _n_TH iteration should be placed at the bottom. */ data want want&i; set Today_progress; if &i=obs then output want&i; /*Every _n_=i will be added to want&i*/ else output want; run; data Job_Sch_Merge2; set want want&i; /*This will make the _n_TH iteration be placed at the bottom*/ array statuses(1000) _temporary_; array date_stat(1000) _temporary_; length pending_job $100; statuses(schedule_id) = return_cd1; date_stat(schedule_id) = LOG_END_DTTM; run; %end; %mend; %arrange; ... View more

I have a .xlsx file that has this column: LastAccessTimeStamp 3/23/2021 14:15 44278.89847   When I do proc import, the output was this: LastAccessTimeStamp 44278.59403 44278.89847   May I know what should be done to convert it from numeric to date with format datetime16. ? ... View more

Below is my sample data:   data have; infile datalines dlm='|'; input Directory $ Date SizeInMB; informat Date Date9.; format Date Date9.; datalines; Folder 1|'13Mar2021'd|20 Folder 1|'14Mar2021'd|26 Folder 1|'15Mar2021'd|14 Folder 2|'13Mar2021'd|250 Folder 2|'14Mar2021'd|110 Folder 2|'15Mar2021'd|300 Folder 3|'13Mar2021'd|.89 Folder 3|'14Mar2021'd|4 Folder 3|'15Mar2021'd|3 ; run;   May I know how to graph it wherein: 1. The date will be in the x-axis 2. SizeInMb will be in the y-axis 3. The directories will be in the line graph (So there will be a legend)   I would also want to divide the graph by their sizes. Example, folders with SizeinMB ranging from 100 to 100MB will be in Graph1, filders with sizes ranging from 101 to 200 will be in Graph2, and so on and so forth ... View more

When i'm running the below query:   data alldata (dbcreate_table_opts='primary index(Detection_Strat_ID,End_Date)'); set table1 table2; run;   I'm having this error: 26 data alldata (dbcreate_table_opts='primary index(Detection_Strat_ID,End_Date)'); ___________________ 22 ERROR 22-7: Invalid option name DBCREATE_TABLE_OPTS.   May I know how to fix this? Thanks ... View more

data have; length jobs $ 100; input jobs $; datalines; 11,2,11,2 11,2 2,11,2 2,11,3,11,4,11 ; run;   From the dataset given, May I know how to add a column that has this logic: 1. If a number appeared only once, it will be removed 2. If a number appeared more than once, it will be retained BUT it will only appear once   To explain further, the output of the added column should be like this: data want; length final $ 100; input final $; datalines; 11,2 . 2 11 ; run;   ... View more

Hello,   Please refer on the data steps below:   data have; length; infile datalines delimiter='|'  dsd truncover; input job_id return_cd1 Trigger $ Prerequisite $; datalines; 2|0|Exec| 11|1|Exec| 7|.|Not Exec|11,2 ; run; data Job_Sch_Merge; set have; array statuses(1000) _temporary_; length pending_job $100; statuses(job_id) = return_cd1; if find(Trigger,'Not Exec','i') and Prerequisite ne '' then do; /*This will list down pending pre-requisite jobs in pending_job column*/ do _n_ = 1 to countw(Prerequisite); _job = scan(Prerequisite,_n_); if statuses(_job) ne 0 then pending_job = compress(catx(',',pending_job,_job),,'s'); end; end; drop _job /*return_cd1*/; run;   data step Job_Sch_Merge will work fine as long as the Prerequisite of a job_id is above it (see above work.have).   However, if work.have is like the dataset below, it will have an issue. May i know how to fix data step Job_Sch_Merge? Thank you in advanced.   data have; length; infile datalines delimiter='|'  dsd truncover; input job_id return_cd1 Trigger $ Prerequisite $; datalines; 2|0|Exec| 7|.|Not Exec|11 11|0|Exec| ; run;   ... View more