%MACRO DOWNLOAD_BIB(DSN); %chk_dir(dir=&path.\&DSN); LIBNAME new "&path.\&DSN"; OPTIONS VALIDVARNAME=any; signon Rsysv user="&_host_user" password="&_host_pass" noscript; %SYSLPUT DSN=&DSN; RSUBMIT; OPTIONS VALIDVARNAME=any; LIBNAME new "&DSN." DISP=SHR; OPTIONS OBS=MAX; PROC DOWNLOAD INLIB=new OUTLIB=new V6TRANSPORT; RUN; LIBNAME new CLEAR; ENDRSUBMIT; %MEND DOWNLOAD_BIB; In this I am downloading SAS dataset from mainframe to windows Macro variable path will have location where SAS dataset would be downloaded in windows when I am ruuning the macro I am getting below error ERROR: Cannot open data library new because it is uninitialized and user has has only read access.   can you help what is the error ... View more

  %MACRO DOWNLOAD_BIB(DSN); %chk_dir(dir=&path.\&DSN); LIBNAME new "&path.\&DSN"; OPTIONS VALIDVARNAME=any; signon Rsysv user="&_host_user" password="&_host_pass" noscript; %SYSLPUT DSN=&DSN; RSUBMIT; OPTIONS VALIDVARNAME=any; LIBNAME new "&DSN." DISP=SHR; OPTIONS OBS=MAX; PROC DOWNLOAD INLIB=new OUTLIB=new V6TRANSPORT; RUN; LIBNAME new CLEAR; ENDRSUBMIT; %MEND DOWNLOAD_BIB;   In this I am downloading SAS dataset from mainframe to windows Macro variable path will have location where SAS dataset would be downloaded in windows when I am ruuning the macro I am getting below error ERROR: Cannot open data library new because it is uninitialized and user has has only read access.   can you help what is the error ... View more

Hello    I have written below statement    %let ardato=01feb2018; Title1 'data pr' &ardato;   below is the warning coming up  the title statement is ambiguos due to invalid options or unquoted text    how can i suppres the warning    ... View more

hello   I am running a SAS program through batch mode   I am using below batch file     "\\server1\Program Files\SASHome\SASFoundation\9.4\sas.exe" -config "\\server1\SASConfig\Config\Lev1\BANKDATA\sasv9.cfg" -metaautoresources "BANKDATA" -sysin "\\server1\CODE\new.sas" -log "\\server1\LOG\DG20AUG2018\new.txt"   SAS program new conatin following code     data new; set sashelp.class; run     when I am running this BAT file program is running file   Log file looks this   NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.NEW has 19 observations and 5 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds         But I want log file should look like this   15   data new; 16   set sashelp.class; 17   run;   NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.NEW has 19 observations and 5 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds           I want log file should include data and proc step so that I can know what code has run   How can i acheive that ... View more

filename sample1 'L\Common\new1.txt'; filename fixed 'L\Common\new2.txt'; data _null_; retain maxp 8 p 0; infile sample1; file fixed lrecl=4000; input ; if p then put ' ' @; put _infile_ @; p+countc(_infile_,'#'); if p>= maxp then do ; put ; p=0; end; run;   I am running above code aand I have used LRECL=4000 to write into a text file   But when  i see the log maximum record length is 1473    NOTE: 16767 records were read from the infile SAMPLE1. The minimum record length was 1. The maximum record length was 200. NOTE: 1596 records were written to the file FIXED. The minimum record length was 125. The maximum record length was 1473. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.03 seconds     how can i increase the record length    ... View more

data new; input x; datalines; 1 2 3 4 5 ; run; data new1; input x; datalines; 3 4 5 ; run;    I want my output to be 1 and 2 .I know I can acheive this through merge step but I want to use proc sql .I have used below proc sql  code but when I am having large observation it takes too much time .Is their any other way i can use proc sql in this ?   proc sql; create table final as select a.x,b.x as y  from new as a left join new1 as b on a.x=b.x where b.x=.; quit; ... View more