英文:
Combining SAS datasets
问题
我必须通过从以下文件之一获取数据来创建一个SAS数据集：
DATA Latest_data;SET new_table&yday. new_table&Bfryday. append_new&yday. append_new&Bfryday.; RUN;
因此，在SET语句中的4个文件中，只有一个可能存在。因此，当我尝试创建Latest_data时，会出现错误，因为其余3个数据集为空。如何解决这个问题或可以使用什么其他方法。&yday的值类似于30MAY2023，&Bfryday的值类似于29MAY2023。
英文:
I have to create a SAS dataset by taking data from either of the below files :
DATA Latest_data;SET new_table&yday. new_table&Bfryday. append_new&yday. append_new&Bfryday.; RUN;
So here among the 4 files present in the SET statement only one of might will exists. So when I am trying to create the Latest_data it throws the an error since the rest 3 datasets are empty. How can I resolve this or what other method can be used.
&yday has a value like 30MAY2023 and &Bfryday has a value like 29MAY2023
答案1
得分: 3
你可以通过设置NODSNFERR系统选项，告诉SAS将不存在的文件视为非错误。只需确保随后重新设置它。
示例：
1188 options nodsnferr;1189 data want;1190 set sashelp.class xy xyz ;1191 run;NOTE: 数据集WORK.WANT有19个观测值和5个变量。NOTE: 数据语句已使用（总处理时间）：实际时间 0.01秒CPU时间 0.01秒1192 options dsnferr;1193 data want;1194 set sashelp.class xy xyz ;ERROR: 文件WORK.XY.DATA不存在。ERROR: 文件WORK.XYZ.DATA不存在。1195 run;NOTE: 由于错误，SAS系统停止处理此步骤。WARNING: 数据集WORK.WANT可能不完整。当此步骤停止时，观测值为0，变量为5。WARNING: 数据集WORK.WANT未被替换，因为此步骤被停止。NOTE: 数据语句已使用（总处理时间）：实际时间 0.00秒CPU时间 0.00秒
英文:
You could just tell SAS to treat a non-existent file as NOT an error by setting the NODSNFERR system option. Just make sure to set it on again.
Example:
1188 options nodsnferr;1189 data want;1190 set sashelp.class xy xyz ;1191 run;NOTE: The data set WORK.WANT has 19 observations and 5 variables.NOTE: DATA statement used (Total process time):real time 0.01 secondscpu time 0.01 seconds1192 options dsnferr;1193 data want;1194 set sashelp.class xy xyz ;ERROR: File WORK.XY.DATA does not exist.ERROR: File WORK.XYZ.DATA does not exist.1195 run;NOTE: The SAS System stopped processing this step because of errors.WARNING: The data set WORK.WANT may be incomplete. When this step was stopped there were 0 observations and 5 variables.WARNING: Data set WORK.WANT was not replaced because this step was stopped.NOTE: DATA statement used (Total process time):real time 0.00 secondscpu time 0.00 seconds
答案2
得分: 2
这是一个很好的使用条件宏函数来检查每个数据集是否存在的用例。如果数据集存在，那么表将被添加到set语句中。否则，不会添加。
英文:
This is a good use case of using a conditional macro function to check if each dataset exists. If the dataset exists, then the table will be added to the set statement. Otherwise, it will not.
DATA Latest_data;set %if(%sysfunc(exist(new_table&yday))) %then %do;new_table&yday.%end;%if(%sysfunc(exist(new_table&Bfryday.))) %then %do;new_table&Bfryday.%end;%if(%sysfunc(exist(append_new&yday.))) %then %do;append_new&yday.%end;%if(%sysfunc(exist(append_new&Bfryday.))) %then %do;append_new&Bfryday.%end;;run;
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论