Yes, this program does run OK. But, this means you can only store your results window data in your "home" folder only. Thus is NOT OK. I have been programming SAS for the last 20 years and I have many folders and subfolders which someone found some kind of a mistake. Someobe found "%include" statement some kind of mistake. I should be able to store my results log data in any folder or subfolder. Yes, it is something that need to go to Tech Support and I will. Thanks anyway. This post should be closed.
... View more
Here is the copy of the program and there was nothing wrong with the path statement: %include '/home/jain.ram.b/Macros/all_fmts.sas'; %include '/home/jain.ram.b/Macros/all_macros.sas'; libname ym '/home/jain.ram.b/MyData'; libname pfkl '/home/jain.ram.b/Progs/PFAAKL'; ods rtf '/home/jain.ram.b/Progs/PFAAKL/out.rtf'; proc freq data = pfkl.pfkl; tables mckd; run; ods rtf close; and I am copying here the error statement: ERROR: 22-322 Syntax error: expecting one of the following: EXCLUDE, SELECT ERROR: 76-322 Syntax error statement will be ignored.
... View more
I am not able to store out from my SAS on Demand results window in a file. Here is the program I wrte but got errors like no exclude select command. Any help how to store rtf and pdf file from results window in SAS On Demand. Ods rtf file=’/home/jain.ram.b/Prgs/output.rtf’; Proc freq data=x; tables gender race; run; Ods rtf close;
... View more
NO, it did not after libname statement. The uploaded file was not recognised as a SAS data.Here is my program:filename resp "/folders/myfolders/sasdata/CMV_J.XPT";proc http url='https://wwwn.cdc.gov/nchs/nhanes/search/datapage.aspx?Component=Laboratory&CycleBeginYear=2017' method="GET" out=resp;run;libname xp xport '/folders/myfolders/sasdata/CMV_J.XPT';proc copy in=xp out=work;run;proc contents; run; And here is the LOG OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 filename resp "/folders/myfolders/sasdata/CMV_J.XPT"; 74 proc http url='https://wwwn.cdc.gov/nchs/nhanes/search/datapage.aspx?Component=Laboratory&CycleBeginYear=2017' 75 method="GET" out=resp; 76 run; NOTE: PROCEDURE HTTP used (Total process time): real time 1.46 seconds cpu time 0.15 seconds 77 libname xp xport '/folders/myfolders/sasdata/CMV_J.XPT'; NOTE: Libref XP was successfully assigned as follows: Engine: XPORT Physical Name: /folders/myfolders/sasdata/CMV_J.XPT 78 proc copy in=xp out=work; 79 run; NOTE: Input library XP is sequential. ERROR: File XP.ALL. is not a SAS data set. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE COPY used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 80 proc contents; run; ERROR: File WORK.VERSION_1606509115215.DATA does not exist. NOTE: Statements not processed because of errors noted above.
... View more
Is there a way to upload XPORT files from Internet website like NHANES website directly to an ODA folder?Of course, I can download it to my computer and hen upload it to ODA folder but that is probably not what I want to do. Any suggestions?
... View more
Hello! If i have a dataset with numbers having two places after decimal, say, 6, 6.1, 6.12 but I want to save them as characters so that they are save as 6.0, 6.10, and 6.12. How can I do that? Is there a SAS function for that? The same when I have numbers with 3 places after the decimal. For example, if the numbers are 6, 6.1, 6.12, and 6.134, I will like to save them as 6.000, 6.100, 6.120, and 6.134. How can I do that?
... View more