Hello, I am trying to create a drop statment using a list of variables in a file eg "a b c" to drop from a table with EG: "a b c d e f" output should only have var "d e f". Any help is appreciated.   //DRPFLE DD DISP=SHR,DSN=SAS.OUTPUT.DROPLIST //TBLFLE DD DISP=SHR,DSN=SAS.OUTPUT.TABLE DATA DRPVAR(KEEP=VARNAME); INFILE THEFILE END=EOF MISSOVER ; INPUT @1 VARNAME $CHAR8. ; DATA DRPSTF (KEEP=VARLIST); FORMAT VARLIST $32767.; SET DRPVAR END=EOF; VARLIST=CATS(' ',VARLIST,VARNAME); DATA DRPIT; SET STUFF DRPSTF (DROP=&VARLIST); PROC PRINT; ... View more

Hi,   How do I print the full contents of the infile?   //FILE DD DISP=SHR,DSN=ABCD.TSS7 //SYSIN DD * DATA abc; OPTIONS PAGESIZE = 9999; INFILE FILE end=EOF missover ; input ; options pageno=1; proc printto print=recpdtl; proc print data=abc noobs; RUN; ... View more

Hello,   I am trying to add label titles to a data proc. Any help is appreciated thanks.     data printe (keep=sdate t1_ts t2_ts t3_ts t4_ts t5_ts uow recpname recpback maxrcrsn t2_t1 t3_t2 t4_t3 t5_t4 t5_t1 intfbe entries ); set recpresp; file recpdtl noprint; put @1 recpname $20. @23 t1_ts time13.4 @38 t5_ts time13.4 @52 t5_t1 9.5 @63 entries $2. @68 uow $12. @81 recpback $10. @91 maxrcrsn $4. @95 t2_t1 9.5 @103 t3_t2 9.5 @111 t4_t3 9.5 @119 t5_t4 9.5 @131 intfbe $30. ; ... View more

Hello,   I am trying to remove the variable labels and force them into specific positions ie "put intv @1" volume @12.etc..   proc print data=recpsum noobs; var sdate intv class object volume over mean max; format intv time8.0; format volume 8.0; format over 8.0; format mean 8.4; format max 8.4;   Thanks,   Ian      ... View more