i am completely new to programming and a beginner to sas learning. how to write keep or drop option in proc import while importing an excel file when it has spaces in the column names of its excel sheet the following are the program that i wrote and the log warning. options validvarname=v7; proc import datafile= '/home/u43101927/EPG194/Data/np_info.xlsx' out=species (keep=Park Name Category Scientific Name Common Names) dbms=xlsx replace; sheet="species"; getnames=yes; run; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 options validvarname=v7; 72 proc import 73 datafile= '/home/u43101927/EPG194/Data/np_info.xlsx' out=species (keep=Park Name Category Scientific Name Common Names) 74 dbms=xlsx replace; 75 sheet="species"; 76 getnames=yes; 77 run; NOTE: Variable Name Change. Species ID -> Species_ID NOTE: Variable Name Change. Park Name -> Park_Name NOTE: Variable Name Change. Scientific Name -> Scientific_Name NOTE: Variable Name Change. Common Names -> Common_Names NOTE: Variable Name Change. Record Status -> Record_Status NOTE: Variable Name Change. Conservation Status -> Conservation_Status NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. WARNING: The variable Park in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Name in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Scientific in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Name in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Common in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable Names in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The import data set has 119259 observations and 13 variables. NOTE: WORK.SPECIES data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 13.69 seconds user cpu time 13.65 seconds system cpu time 0.04 seconds memory 42037.78k OS Memory 75752.00k Timestamp 11/18/2019 04:16:33 PM Step Count 132 Switch Count 4 Page Faults 0 Page Reclaims 10399 Page Swaps 0 Voluntary Context Switches 41 Involuntary Context Switches 14 Block Input Operations 0 Block Output Operations 4616 78 79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 90 please help me to figure out the problem.
... View more
