About Tom

Tom · ‎10-22-2011

Look at the modifiers for the COMPRESS function. I assume you want the W modifier. clean=compress(raw,,'wk'); Also look at the COLLATE function to specify a range of values by code number. For example to keep just the printable basic ASCII codes: clean=compress(raw,collate(32,127),'k') Of if you have an old version of SAS where compress does not support the modifiers you can use compress twice. clean=compress(raw,compress(raw,collate(32,127)));

Tom · ‎10-21-2011

Why would you want to DELETE the variables? Perhaps you mean that you want to exclude those variables from later analysis? What are you ultimately doing with the data? To sum a "column" use PROC SUMMARY. proc summary data=have; var _numeric_; output out=stats(drop=_type_ _freq_) sum=; run; Then use PROC TRANSPOSE to rotate so that each row represents a variable. proc transpose data=stats out=vars (rename=(col1=sum)) ; run; Now you can use PROC SQL to create macro variables with either the list of variables to keep or those to drop. proc sql noprint ; %let keep=; select _name_ into :keep separated by ' ' from vars where sum ne 1 ; %let drop=; select _name_ into :drop separated by ' ' from vars where sum = 1 ; quit; Now you can write code to use the original dataset and select which group of variables you want. proc print data=have ; var &keep ; run; data want ; set have; drop &drop; run;

Tom · ‎10-21-2011

I would look first to make sure that the OPTION statement is actually running. It is possible that there is some character in front of it that is converting it into a comment or text string. Otherwise you would need to check the program statements to see if there are any that have turned off the MPRINT option.

Tom · ‎10-20-2011

Then the question with this syntax is whether your Sharepoint server allows you to view the document folder as if it was a actual network folder. On the sites I have used you can access a document library as if it was a network folder by selecting Open in Windows Explorer from the Actions menu. See image below. I assume that is a feature that the site owner can turn on or off depending on the security settings that they need, but the details of how are beyond me.

Tom · ‎10-20-2011

Are you sure that the macro generated any code? It is possible that the code is conditional and in your current program the macro has decided to skip all of the parts that generate code. It is possible the create macros that only execute macro statements and hence will not generate any code.

Tom · ‎10-20-2011

Unfortunately that method will only work if you are running SAS on your Windows machine.

Tom · ‎10-19-2011

The problem with moving the data into macro variables and back is more that you could lose precision. Macro variables are just character strings and so will not match exactly the original floating point numbers. Also if you use datasets then you can easily add grouping variables by using BY statements.

Tom · ‎10-19-2011

You are missing an ampersand in the first %LET statement. Also you do not use quotes around character strings in SYSFUNC calls. What format do you want the NEWDAY variable? You are currently asking for an integer (number of days since 1/1/1960). Perhaps you meant to do: %let dateend=&sysdate9.; %let newday=%sysfunc(intnx(day,"&dateend"d,-1),date9.); Or better still if you are like me and sometimes leave SAS running interactively for past midnight. %let dateend=%sysfunc(today(),date9.); %let newday=%sysfunc(intnx(day,"&dateend"d,-1),date9.);

Tom · ‎10-18-2011

If you have it as a macro variable then you can use it as date literal. %let textdate=10JAN2011; %let endmonth = %sysfunc(intnx(month,"&textdate"d,0,E),date9.); %put &textdate &endmonth; 10JAN2011 31JAN2011

Tom · ‎10-18-2011

Almost all procedure will now deliver the output into datasets for you using the ODS output system. http://support.sas.com/documentation/cdl/en/odsug/62755/HTML/default/viewer.htm Also many procedures have options to specify output datasets. In particular for PROC MEANS/SUMMARY there is the OUTPUT statement.

Tom · ‎10-18-2011

Did you try using SAS/Connect?

Tom · ‎10-18-2011

Cannot do it that way. You will need to use a little code generation. You could query the SAS metadata to get a list of the variables and generate the new variable names. proc sql noprint ; select name, trim(name)||'mv' into :vlist separted by ' ' , :vlist2 separated by ' ' from dictionary.columns where libname='WORK' and memname='BASETABLENUM' and type='num' ; quit; data basetabel_imputed; set basetablenum; array wit &vlist; array new &vlist2; do i=1 to dim(wit); new(i) = (wit(i) = .); if new(i) then do; wit(i)= symget(vname(wit(i)); end; end; drop i; run; Now I am confused about why you are using macro variables to transfer the medians. It is much better use SAS datasets to do that. proc sql noprint ; select name , trim(name)||'mv' , trim(name)||'median' into :vlist separted by ' ' , :vlist2 separated by ' ' , :vlist3 separated by ' ' from dictionary.columns where libname='WORK' and memname='BASETABLENUM' and type='num' ; quit; proc summary data=basetablenum ; var &vlist ; output out=basetable_medians median=&vlist3; run; data basetabel_imputed; set basetablenum; if _N_=1 then set basetable_medians; array wit &vlist; array new &vlist2; array median &vlist3 ; do i=1 to dim(wit); new(i) = (wit(i) = .); if new(i) then do; wit(i)= median(i); end; end; drop i &vlist3; run;

Tom · ‎10-14-2011

Sounds like a permission issue. You have read access to the directory so that you can see the file name, but you do not have read access to the actual files. If you want to use the FILEVAR option with an FTP file I found that it does not honor the CD option when using the DIR option. Not sure if there is another way, but you can just use the fully qualified filename in the FILEVAR variable. filename ftpdir ftp cd="&dname" host="&host" user="&user" pass="&pass" ls ; data files ; infile ftpdir truncover; input fname $200. ; run; filename ftp ftp recfm=v host="&host" user="&user" pass="&pass" dir ; data _null_; set files ; where fname like 'x%.sas'; filevar="&dname/"||fname; put 100*'-' / fname / 100*'-'; infile ftp filevar=filevar end=eof ; do while (not eof); input; put _infile_; end; eof=0; run;

Tom · ‎10-14-2011

Perhaps your server requires SFTP instead of normal FTP?

Tom · ‎10-14-2011

FileZilla is probably NOT using mget. It probably retreives the directory and then retrieves the files one by one. SAS does not translate the *, that function is being done by the remote FTP server. Are you sure they do not have embedded spaces or other things so that they do not match the pattern that you are trying to use? Try testing your pattern by using the DIR command instead of the MGET command to see if the files you want are actually there.

Online Status	Offline
Date Last Visited	yesterday