摘要: When and where do DROP, KEEP, and RENAME act? ![When and where do DROP, KEEP, and RENAME act?](https://img2023.cnblogs.com/blog/3254841/202309/3254841 阅读全文
posted @ 2023-09-26 20:43 helloyuen 阅读(1) 评论(0) 推荐(0) 编辑
摘要: Explain the meaning of the following SAS code. data ds5 (drop=_type_ _freq_ ); retain style exercisetype sales grandtotal percent; if _N_=1 then set s 阅读全文
posted @ 2023-09-20 18:12 helloyuen 阅读(1) 评论(0) 推荐(0) 编辑
摘要: ERROR: Physical file does not exist, \SAS\ReportFontsforClients\9.4\saswcur.ttf A circumvention for this issue is to add the following OPTIONS stateme 阅读全文
posted @ 2023-09-20 18:11 helloyuen 阅读(25) 评论(0) 推荐(0) 编辑
摘要: # Character functions ## ANYALNUM(str, startpos) Return position of first occurrence of any alphabetic or numeric value after or at the start postion 阅读全文
posted @ 2023-09-13 13:37 helloyuen 阅读(1) 评论(0) 推荐(0) 编辑
摘要: # REFERENCE TO EXTERNAL FILE VIA LIBNAME ENGINE LIBNAME {libref} {DBMS descriptor} {dir to file} DBMS descriptor for Excel: XLSX, XLS, EXCEL DBMS desc 阅读全文
posted @ 2023-09-11 15:55 helloyuen 阅读(4) 评论(0) 推荐(0) 编辑
摘要: # Method 1: ``` proc contents data=cars short out=outds00; run; data outds(keep=name); set outds00; vnam=substr(name, 1, 1); if vnam ne "M" then outpu 阅读全文
posted @ 2023-09-08 13:24 helloyuen 阅读(2) 评论(0) 推荐(0) 编辑
摘要: In Python, a variable can perform increments in the form of i=i+1 (i+=1) or i=i+j (i+=j). In SAS, the same operation can be done in the form of i+1 or 阅读全文
posted @ 2023-09-02 09:59 helloyuen 阅读(1) 评论(0) 推荐(0) 编辑
摘要: /* To check if a variable {vnam} exists on a dataset {dsnam} */ /* Return a non-zero number if variable exists */ ``` %macro var_exists(dsnam, vnam); 阅读全文
posted @ 2023-08-30 08:55 helloyuen 阅读(3) 评论(0) 推荐(0) 编辑
摘要: ods exclude all; proc freq data=temp_ds_01; tables &grp*&ctg; ods output crosstabfreqs=temp_ds_02; run; ods exclude none; 阅读全文
posted @ 2023-08-29 13:24 helloyuen 阅读(6) 评论(0) 推荐(0) 编辑
摘要: To find references for PROC MEANS on sas.com, use the following search technique in Google Search Engine: `site:support.sas.com/resources/papers/proce 阅读全文
posted @ 2023-08-23 12:48 helloyuen 阅读(3) 评论(0) 推荐(0) 编辑