Hi all, I am trying to automate the file zipping process.any sample codes? ... View more

I was trying to save my log to a permanent location ,but when i mentioned the libname in the PROC PRINTTO ,i got an error saying INVALID FILE. Here is my code: PROC PRINTTO LOG='S:\DEV\user20\test\op' NEW; RUN; proc contents data=work noprint out=sample; run; PROC PRINTTO PRINT=PRINT LOG=LOG ; RUN; ... View more

Hi , I have a library that has, say for example 'n' number of sas datasets.Is there any way I can get the exact count of the sas data sets in the library. Please help. Ren ... View more

I was running a sql input table EMP is like the following: id name sal 1 ram 300 My sql: proc sql; create table aa as select id,name=name,sal from emp; quit; In output table id _TEMA001 sal 1 1 300 the variable _TEMA001 is numeric and has value 1 ,any one has any idea why this unusual name is appearing and why it is numeric? Please help. ... View more

Hi, I have a new patient dataset where patient num(numeric field) is in format 11 and informat 11 but recently the team who provides the patient dataset created new patient dataset and the patient num is in format 2O AND informat 20. but when i create another version of new patient dataset i want to use patient num in format 11 and informat 11. i use sql to create another version of new patient dataset,and i use like this proc sql; create table newver as select patnum format 11. from newpat ; quit; My question is what if i do not change the informat here? Can any one help? ... View more

Hi, I have a situation,where i have a variable NAME eg: NAME ---------- JOHN C MAT,MD SARA ATIO,MD I would like to seperate this name as Fname,MIDname,Lname so my output look like Fname MIDname Fname --------------------------------------------------- JOHN C MAT,MD SARA ATIO,MD Please let me know,if you have a solution for this. thanks, Ren ... View more

Hi, I have a situation like the following example: doctor ----------------------------------- specialtykey doctorname 1 john 2 Sam 3 Mary doctor specialty table ---------------------------- specialtykey specialty 1 ENT 1 Cardiologist 1 General 2 eyes 2 family 3 Gastro My output dataset should look like this Final ---------- doctorname specialty1 specialty2 specialty3 john ENT Cardiologist General sam eyes family mary Gastro Please help ... View more

I have a date variable where dates are stored as mmddyyyy format, how do i check the date variable using sql where condition? Suppose i want to select all records whre date is greater than 01012009 what will be sql for this. ... View more