If you have SAS 9.2 or newer you have the INDSNAME option http://support.sas.com/kb/34/513.html So: data final; format dsname datasetname $20.; *something equal to or longer than the longest dataset name including the library and dot; set my_data_1 abc xyc indsname=dsname; datasetname=dsname; run;
The ERRORS=1 option was previously suggested, but that only stops he ERROR messages from writing to the log. I would suggest another system option ERRORABEND which will stop the program from further processing for most errors. I don’t know of an option to terminate processing due to warnings, but I think that you could add … Read more
Here are some links that have a large number of commands: FSP Commands Commands specific to Windows AF Windowing Commands Commands for the Program Editor (Scroll down to second paragraph)
In order to identify possible output datasets, SAS provides the ods trace statement. This asks SAS to write to the log the name (and some details) of each data table it writes to the output. In most cases, this can be saved to a dataset via ods output. For example, in the SAS example referred … Read more
With a single set of ampersands, what you get is pretty boring; after one, odd number of ampersands leads to resolving twice, even number of ampersands resolves once. So you use 1 ampersand to resolve once and 3 ampersands to resolve twice, unless you have stock in the company that owns rights to the ampersand. … Read more
It’s easy with PROC SQL. Do a count and put the results in a macro variable. proc sql noprint; select count(*) into :observations from library.dataset; quit;
This in part depends on what your macro is doing. If we assume that your macro is doing something that is intended to be run outside of a data step (ie, it’s not just assigning a data step variable), then you have several options. CALL EXECUTE PROC SQL: SELECT INTO macro variable Write macro calls … Read more
Wes is of course right! I’m just chiming in to provide a little more complete example code. I had the same issue with a 129 Mb file, which was solved by: import pandas as pd tp = pd.read_csv(‘large_dataset.csv’, iterator=True, chunksize=1000) # gives TextFileReader, which is iterable with chunks of 1000 rows. df = pd.concat(tp, ignore_index=True) … Read more
Macro variables in SAS won’t resolve when they are in single quotes, ‘&myvar’. They need to be in double quotes, “&myvar”, in order to resolve properly. If you need to have single quotes and a resolved macro variable, you have a few options, but the simplest is: %str(%’&myvar.%’) The %’ inside of %str will place … Read more
If you are using any spreadsheet application there is a basic function if() with syntax: if(<condition>, <yes>, <no>) Syntax is exactly the same for ifelse() in R: ifelse(<condition>, <yes>, <no>) The only difference to if() in spreadsheet application is that R ifelse() is vectorized (takes vectors as input and return vector on output). Consider the … Read more