Unfortunately my crystal ball seems to be broken, so I can't look into the configuration of your sas servers. I recommend contacting local server administraion and/or sas tech support.
... View more
The variable FULL_LIST_PHONE_LAST_EMPLOYER is reset to missing in each iteration, to preserve the value you need to add a retain statement: length ....; retain FULL_LIST_PHONE_LAST_EMPLOYER; SET EANEADTBUILDUP ; ...
... View more
%sysfunc (FILENAME (fileinfo,%str (&Pipe_Command)),pipe); I think the there should be just one closing brace after &Pipe_Command. %sysfunc (FILENAME (fileinfo,%str (&Pipe_Command) ,pipe));
... View more
Hello! Is it possible to create read only macro variables? Right now some global macro variables are created in the appserver_autoexec_usermods.sas configuration files. Unfortunately those variables can me modified by all users, causing some trouble when it happens in a stored process ... Any ideas?
... View more
What do you want to be highlighted, exactly? The whole row? A cell? The example highlights the variable 'age': proc format; value AgeBgFmt 11 = 'Gold' 16 = 'light green' other 'white' ; run; proc print data=sashelp.class; var Name Sex; var Age / style={background=AgeBgFmt.}; var Height Weight; run;
... View more
Without any example data given this is just a blind guess: proc summary data=work.bob; class age sex marriage status; output out=work.frequencies; run;
... View more
Do you need the total number of observations in an additional variable in each observation or do you need the observations position in the dataset? The variables nlobs and nobs in sashelp.vtable contain the total number of observations in a dataset. /* get number of obs */ proc sql; select nlobs into :counter from sashelp.vtables where lowcase(libname) = 'work' and lowcase(memname) = 'test'; quit; /* update dataset */ data work.test; set work.test; num_obs = &counter; run; Code is not tested!
... View more
Your can use the cmiss-function: data work.marked;
set work.somedata;
length hasMissings 3;
hasMissings = 0;
hasMissings = cmiss(of _all_);
run;
... View more
1) EG has build-in ODBC support. 2) The import procedure requires SAS Access to PC File Formats, but with SAS on Linux a PC File Server on a Windows machine is also required. 3) + 4) You have already found the solution to your problem: installing unixODBC driver for MS Access.
... View more
Maybe this helps:
[pre]
%macro filter(ages=);
%local datasetPostfix;
%let datasetPostfix = %sysfunc(compress(&ages, %str( )));
data work.Class&datasetPostfix;
set sashelp.class;
where age in (&ages);
run;
%mend;
%filter(ages=13 15);[/pre]
Works as long as you pass at least one value.
... View more
