Thanks @Tom , you absolutely clarified the point. ... View more

@Tom may I ask, suppose you have a macro program in a macro program: /* %let choice = xxx; -- either exists as global or does not exits */ %macro main; %local choise; ... %called(....); ... %mend; %macro called(...arguments ...); %global choice; %if %symexist(choice) %then ... ; %mend; %main; in such case which macro variable CHOICE shall %symexist() check - the %local or the %global ? ... View more

@DanD999 I hope next code will clarify the usage of %symexist() macro function: %let x=; %macro test; %if %symexist(x) %then %put X; %else %put NOx; %if %symexist(y) %then %put Y; %else %put NOy; %mend; %test; the log messages in this example: X NOy   ... View more

%GLOBAL clause is just a declaration and will not override existing value.   By the way, I checked myself and length("&none"), when NONE was not assigned a value, result in 1 and not 0 as I expected.         ... View more

Can you add to your shared model a line: %global choice; /* force existence of the macro variable without assigning a value */ then you can check whether the global macro variable is assigned a value: %let chkvar = ABC; /* this is global by default */ %global none; /* Force existence of global variable */ %macro chk; data _NULL_; if length("&chkvar") then put "chkvar exists"; if not length("&none") then put "none do not exist"; run; %mend; %chk; ... View more

1)  Using function EXIST(<xxx>) - xxx is a data set name, not a variable name ! 2) You assigned:  %let choice = yes;       Then in your code &choise is replaced by the string yes.      Do you mean that the variable to name is yes ?   Do you need to check one variable only? is it always the same variable?  Or maybe you need different variables to check depending on the situation?   You can check whether a variable exists in a data set by any of next methods: 1) check existence of the variable in sashelp.vcolumn :       %let varname = NAME; %let exist = 0; data _null_; set sashelp.vcolumnn(where=(libname="ANYLIBRARY" and member = "DATA_SET_NAME"); if _N_then call symput('exist','1'); run; %put EXIST = &exist; pay attention = libname and data set name should be in unppercase.   2) Next code may be used inside your data step code:       data ds_out; set any_lib.ds_in; ... dsid = open("any_lib.ds_in"); if dsid > 0 then do; exist = varnum(dsid,"var_name"); dsid = close(dsid); end; if exist = 0 then put "VAR_NAME does not exist in lib.ds_in"; else do; ... any code .... end; run; ... View more

@mcook wrote: That would require a different adaptation for each CSV file correct? I am trying to figure a way to import many CSV files without having to manually attend to the Carriage returns in each. Alternative code may be used with any csv file containing breaklines: /* 1 - creating test csv file */ filename mytest '/folders/myfolders/flat/test.csv'; data _null_; fname = 'barry'; lname = 'Allen'||'13'x||'Smith'; mi = 'Q'; line = catx(',',fname,lname,mi); file mytest; put line; run; /* 2 - remove breaklines */ filename newtest '/folders/myfolders/flat/testnw.csv'; data _NULL_; infile mytest; file newtest; input ; infile = translate(_infile_,' ','13'x); put infile; run; /* 3 - importing the csv file by a data step */ data test; length fname lname $20; infile newtest dlm=',' termstr=CRLF truncover; input fname $ lname $ mi $; put lname=; run; ... View more

Can you post the generated code by proc import from the log? As you have a lot of variables it may be convenient to adapt the generated code and use it as  a data step with infile statement. ... View more

I have created my own test file with one row and used '13'x as ENTER character. check next code and adapt to your input file. I suggest not to use proc import but write your own data step to read the csv file. /* 1 - creating test csv file */ filename mytest '/folders/myfolders/flat/test.csv'; data _null_; fname = 'barry'; lname = 'Allen'||'13'x||'Smith'; mi = 'Q'; line = catx(',',fname,lname,mi); file mytest; put line; run; /* importing the csv file by a data step */ data test; length fname lname $20; infile mytest dlm=',' termstr=CRLF truncover; input fname $ lname $ mi $; lname = translate(lname,'-','13'x); put lname=; run; ... View more