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.
