Amarnath7 Tracker

Re: Add BATCH SUBMIT button to EG

Amarnath7 — Fri, 14 Sep 2018 02:46:53 GMT

Yes, it is similar to what you said with additional features.

Re: Add BATCH SUBMIT button to EG

Amarnath7 — Tue, 11 Sep 2018 23:51:26 GMT

Interesting topic. Please consider this feature to have it in BASE SAS as well.

Recently I have written very very simple macro but took my significant time to establish a link between current SAS session and batch run process. Does batch run of current program in SAS window (either one macro call/tool bar button), automatic log check and shows the log issues in special window in SAS session. So that you can fix your program immediately if there is any issue. Also, it opens the log file as text file when there is an issue found.

I am submitting this as abstract in SAS Global Forum. I will share the macro soon.

I would request SAS to add this feature in BASE SAS as well.

Re: modifying variables

Amarnath7 — Fri, 20 Sep 2013 05:46:54 GMT

for Task 1, Z. format works to add leading 0s

For task 2, can you please add more details?

Re: Listing the sas program based on library they are calling

Amarnath7 — Thu, 19 Sep 2013 12:30:11 GMT

Hi,

you can make use of dopen, dnum & dread functions if you do not want use OS commands

Re: Proc Import Truncating Values

Amarnath7 — Thu, 19 Sep 2013 12:22:56 GMT

Hi,

Instead of Proc import, if you use data step this can be fixed either to read single sheet or multiple sheets

Re: Convert values to missing

Amarnath7 — Thu, 19 Sep 2013 12:14:59 GMT

Use call missing function.

call missing (x,y) only for two variables

for all the variables use call missing (of _all_);

Re: Names in Date field

Amarnath7 — Thu, 19 Sep 2013 05:58:17 GMT

Hi,

Treat the variable as charater variable initially, then using charater functions identify dates with alphabets, then create flag variable to get top 10 or bottom 10 of each alphabet values.

Re: Getting next non missing value for the same variable

Amarnath7 — Thu, 19 Sep 2013 05:45:44 GMT

with simple steps;

data in ;
input x y;
ord=_n_;
cards;
1 .
2 .
3 7
4 6
5 7
6 .
7 0
;
run;

data y;
set in (keep=y where=(y^=.));
ord=_n_;
run;

data out;
merge in (drop=y) y;
by ord;
drop ord;
run;

Re: concatenation

Amarnath7 — Wed, 18 Sep 2013 14:56:08 GMT

use 'comm' variable as commAug ,commJun in any in the data. you can not keep two variables on the same name.

Else use proc report

proc sql;

select emp_aug13.*,emp_Jun13.*

from emp_aug13,emp_Jun13

where emp_aug13.depnto=emp_Jun13.depnto;

quit;

deptno commAug commJun

10 1000 500

20 3000 190

30 1500 250