/* Generated Code (IMPORT) */ /* Source File: Aspirin field trial.xls */ /* Source Path: /folders/myfolders */ /* Code generated on: Thursday, January 28, 2016 3:26:09 AM */ %web_drop_table(WORK.IMPORT); FILENAME REFFILE "/folders/myfolders/Aspirin field trial.xls" TERMSTR=CR; PROC IMPORT DATAFILE=REFFILE DBMS=XLS OUT=WORK.IMPORT; GETNAMES=YES; RUN; PROC CONTENTS DATA=WORK.IMPORT; RUN; %web_open_table(WORK.IMPORT); data WORK.IMPORT2; set WORK.IMPORT; * Convert kill_wt from character to numeric; Lung_wt2 = input(Lung_wt, best9.); run; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 /* Generated Code (IMPORT) */ 57 /* Source File: Aspirin field trial.xls */ 58 /* Source Path: /folders/myfolders */ 59 /* Code generated on: Thursday, January 28, 2016 3:26:09 AM */ 60 61 %web_drop_table(WORK.IMPORT); NOTE: Table WORK.IMPORT has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 62 63 64 FILENAME REFFILE "/folders/myfolders/Aspirin field trial.xls" TERMSTR=CR; 65 66 PROC IMPORT DATAFILE=REFFILE 67 DBMS=XLS 68 OUT=WORK.IMPORT; 69 GETNAMES=YES; 70 RUN; NOTE: Variable Name Change. Ear tag -> Ear_tag NOTE: Variable Name Change. Entry wt -> Entry_wt NOTE: Variable Name Change. Treat d1 -> Treat_d1 NOTE: Variable Name Change. Treat d3 -> Treat_d3 NOTE: Variable Name Change. Treat d6 -> Treat_d6 NOTE: Variable Name Change. Lung wt -> Lung_wt NOTE: Variable Name Change. Kill wt -> Kill_wt NOTE: The import data set has 244 observations and 21 variables. NOTE: WORK.IMPORT data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.06 seconds cpu time 0.04 seconds 71 72 PROC CONTENTS DATA=WORK.IMPORT; RUN; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.18 seconds cpu time 0.18 seconds 73 74 75 %web_open_table(WORK.IMPORT); 76 77 data WORK.IMPORT2; set WORK.IMPORT; 78 * Convert kill_wt from character to numeric; 79 Lung_wt2 = input(Lung_wt, best9.); 80 run; NOTE: There were 244 observations read from the data set WORK.IMPORT. NOTE: The data set WORK.IMPORT2 has 244 observations and 22 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 81 82 83 84 85 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 97 PROC SQL; CREATE TABLE WORK.query AS SELECT Ear_tag , Entry_wt , Gender , 'Cast'n , DH , Treat_d1 , Treat_d3 , Treat_d6 , Lung_wt , Kill_wt , 'Group'n , ADG , Fibrin , Fibrosis , Lesion , Plant , Feedlot , S_3MI_D0 , S_3MI_D3 , S_3MI_D6 , R_3MI FROM WORK.IMPORT; RUN; QUIT; PROC DATASETS NOLIST NODETAILS; CONTENTS DATA=WORK.query OUT=WORK.details; RUN; PROC PRINT DATA=WORK.details; RUN; I'm not sure where my proc contents are, but hopefully this helps.
... View more