SAS

How to schedule SAS job on mainframe
Does your mainframe have administrators? If so usually what you would do is to setup a JCL job that calls a SAS program or actually has the SAS program included in the same file with the JCL around it, then submit a request to the operations department of your shop to schedule the job for every Monday at 5PM. You... 6 Jan 2010 08:49

How to schedule SAS job on mainframe
Hello SAS-L, I would like to know if there is a way to schedule a SAS job, say,=20 run the program every Monday at 5:00 PM, on an IBM mainframe (I think its an iSeries). I do not have SAS connect installed on my PC nor do I have SAS on my PC. I simply manually log on to the mainframe, do my work=20 there we... 6 Jan 2010 08:49

how to FTP a pure XLS file to MAINFRAME and do PROC IMPORT
I don't think there is a mainframe program that knows how to read Excel files - there's not from SAS Institute, and I haven't heard of one from another supplier (not that someone couldn't port OpenOffice.org, but as far as I know it hasn't happened). When I have to do something with a PC binary file on the mainfr... 6 Jan 2010 08:49

SAS-L Digest - 5 Jan 2010 - Special issue (#2010-9)
oops! I'm in too much of a hurry. Dataset b is the fields dataset, not a. you should change a.* to b.* to accomplish what I understood that you were asking. Like this proc sql ; create table want as select b.* from param1 as a, fields1 as b where a.param1 eq b.field1 and a.param2 eq b.field2 and a.pa... 6 Jan 2010 08:49

Use %like in a dataset
Hi, i need to use in a dataset the option %like... but it is not the same that in a proc sql... I don´t remember, it was something using ":"? thank you ... 6 Jan 2010 08:49

Merge n no of Datasets using macros
Hi , Thanks a lot. Regards On Tue, Jan 5, 2010 at 5:47 PM, Murphy Choy <goladin(a)gmail.com> wrote: Hi, Why not use a loop? %macro merge(); Data alldata; Merge %do I = 1 %to n; Test&i %end; ; By Id; Run; %mend; ------Original Message------ From: SUBSCRIBE... 6 Jan 2010 08:49

Merge n no of Datasets using macros
HI all, i have to merge datasets at a time using macros,i should keep incrementing till the last dataset is merged i have tried to write a macro for merging 3 datasets but how can i do it say for 30 datasets..please guide me... sample code... %macro sort(no=); options mprint mlogic symbolgen; %do i=1... 6 Jan 2010 08:48

Termination due to Floating Point Exception with Proc NLMixed for a count data set
I am trying to fit a count data set to zero-inflated Negative Binomial model using Proc NLMIXED in SAS 9.2. My program works well with all datasets except the particular data set below, from there I got an error message of “ ERROR: Termination due to Floating Point Exception” My research tells me that this probl... 6 Jan 2010 08:48

How to utilize the FORMAT statement to format the produce output data set.
Hi Guys: This is a section of code come from a book. ROC MEANS DATA=JES.Results_1 NOPRINT; VAR Defects Resistance Fail; OUTPUT OUT=Tab_3 N(Defects)=N SUM(Defects) = N_DEF MEAN(Defects) = M_Def MEAN(Resistance) = M_Res SUM(Fail) = N_Fail MEAN(Fail) = P_Fail; FORMAT M_Def P_Fail 6.2; RUN; The Format st... 6 Jan 2010 08:48

File is full or damaged
Hi, I have a 4GB dataset saved on my hard disk in C drive. I need to remove duplicate records from it and storing the dataset in work library. My work library has a free space of 22GB but still, I am gettin an error while running the code. It processes half of the observations and then gives an error that the fi... 6 Jan 2010 08:49