I have some problems making sense of your code. - j iterates 1 to 36, but array cutoff() has only 5 elements? - where does date1 come from? Aside from that, you may be able to solve your problem without macro processing.
... View more
Aside from what Tom said, you tried to use data step variables in the macro %while statement. During macro execution, these do not yet exist. Keep in mind that macro processing occurs BEFORE the data step is even compiled.
... View more
Without metadata, you could only audit table (file) access via the audit subsystem of the operating system (if you have one, I come from AIX) or with the RTRACE/RTRACELOC option. Be aware that (at least in 9.2) the RTRACELOC option in the sasv9.cfg does not support dynamically generated filenames as the LOG option does, so you may have to do that in the script that invokes sas and use the -rtraceloc command line option. Access of columns could only be audited by working through the logs, IMO.
... View more
There is no "working scenario", because: 20 do i= 01 to 04; 21 22 j=01 to 04; __ 388 202 ERROR 388-185: Expecting an arithmetic operator. ERROR 202-322: The option or parameter is not recognized and will be ignored.
... View more
An other idea: put the part that may need editing into an include file, and have users make a local copy of that. The main program would then do a %inc '$HOME/something.sas'; and be saved without write access for the users. Have a provision for the log of every run to be saved permanently, so you can show it's the include that is causing the odd ERROR.
... View more
Chris, I know that, but in the example he/she was _creating_ a local SAS data set. Doing that only so you can then use the SAS Data Provider to use it in a _local_ Windows application would reside quite to the right of the dumbness scale IMO.
... View more
With SAS On Demand, the SAS process runs on a server that cannot see your local filesystem(s). To create SAS tables locally, you need a local SAS installation. If you want to save data, you have to export it to a local location (.sas7bdat not possible). Don't know if it's possible to use ssh/ftp to the On Demand server.
... View more
OK, next try proc sort data=test; by customer_id month_num; run; data upon (keep=customer_id); set test; retain number old_m ; by customer_id; if first.customer_id then do; old_m = month_num - 1; number = 0; end; if month_num = old_m + 1 then number + 1; else number = 0; old_m = month_num; if number = 3 then output; run;
... View more
data upon (keep=customer_id number); set test; by customer_id; if first.customer_id then number = 0; number + 1; if last.customer_id and number ge 3 then output; run;
... View more
Use the operating system's access control. (my preferred method for .sas files). If it is part of an EG project, save the project in a folder in the metadata and set the access rights there.
... View more
