First off let me just say i am quite a novice with SAS and i'm using the studio version and studying it through a work scheme / online modules. I am using a sas program which i have written to import 2 sheets and merge them together which it does successfully (to a point) However i am having an issue whereby the column it inserts the data (similar to how a vlookup works) doesn't allow me to specify a length when creating it this column is totally empty in my input sheet as i then get the value from the other sheet. The error i get is NOTE: The LENGTH attribute cannot be changed and is therefore being ignored. and the code i am using is proc import replace datafile= '/folders/myfolders/arron/tab.xlsx' DBMS=xlsx OUT = work.tab; length agent $ 25; run; I am also then experiencing an issue whereby it lists the first value only and then moves onto the next agent leaving lots of blanks. my code is data arron.tab; merge tab (in=a) agent_stores (in=b keep=store agent); by store; if a; run; Store is the variable i reference within the agent_stores list. Any help appreciated.
... View more