Ok, this is far more complicated than my paygrade but I'll do whatever is necessary. Bear with me because a lot of basic questions are incoming. For the first bit of code, I entered PROC SQL; CREATE TABLE xlmergZ AS select Date_of_Visit into :varlist separated by ' ' from xlmergM; QUIT; ... and got back the column of entries under the variable I asked for. So far so good I think. The next code string in the example you cited is utter Greek to me, even with a SAS book at my side to refer to. Here's what it says: select case type when 'num' then case when missing(format) then cats(Name,':32.') else cats(Name,':',format) end else cats(Name,':$',length,'.') end into :inputlist separated by ' ' from dictionary.columns where libname="&lib" and memname="&dsn" ; I entered this: PROC SQL; CREATE TABLE xlmergY AS select case Date_of_Visit when 'num' then case when missing(format) then cats(Name,':32.') else cats(Name,':',format) end else cats(Name,':$',length,'.') end into :inputlist separated by ' ' from dictionary.columns where libname="&lib" and memname="&dsn" ; LOG returned the error that it did not recognize my variable date_of_visit. I am sorry to require so much hand-holding but I am utterly lost. I appreciate that you need this info to answer my question, and I am trying, but was already having trouble with the elementary code to upload a file in another format, and now I'm trying to write SQL code in order to get an answer to a far simpler question.
... View more
