Hi All,         I have been trying to understand the difference between inobs and outobs, but it's not clear to me.  I have referred to the earlier post on this forum at: https://communities.sas.com/t5/SAS-Programming/Difference-between-in-inobs-and-outobs/m-p/419910#M103290 and executed the example given by Reeza. In this example, we run the code with outobs = 2 first and the result contains 2 records where age is 16 and 15 and after this if we run the code with inobs =2 then the result contains 2 records where age is 14 and 13. I didn't understand why inobs result is different from outobs.   Also, I have gone through the documentation on SAS site: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/sqlproc/n0a693shdq473qn1svlwshfci9rg.htm#n0pz0czrns2pksn1im05lnw36t98 but, I am not clear on the differences between the two. Can anyone help me to understand the differences between the two, giving some examples?    Thanks   ... View more

Hi All, I am trying the code execute the code given in https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1lhhti7fjxgb1n1fuiubqk11h4d.htm But, It's not working. Please, help me to understand why this error is coming and how to rectify it. These programs given at the above SAS site say that it will give some output but instead of that I am getting errors. Code is: %macro vars(first=1,last=); %global gfirst glast; %let gfirst=&first; %let glast=&last; var test&first-test&last; %mend vars; proc print; %vars(last=50) title "Analysis of Tests &gfirst-&glast"; run; In the log: 26 options mprint; 27 %macro vars(first=1,last=); 28 %global gfirst glast; 29 %let gfirst=&first; 30 %let glast=&last; 31 var test&first-test&last; 32 %mend vars; 33 proc print; ERROR: There is not a default input data set (_LAST_ is _NULL_). 34 %vars(last=50) MPRINT(VARS): var test1-test50; 35 title "Analysis of Tests &gfirst-&glast"; 36 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds   Similarly, the program given in https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/n0i4icf2nv7wu7n1lm4wf1epykfh.htm#p06942xl3jrvwpn1vt2rmuza3vwi is also not working. The code from this link is: %macro namels3(name,number); %local n; %global g_number; %let g_number=&number; %do n=1 %to &number; &name&n %end; %mend namels3; %let n=North State Industries; proc print; var %namels3(dept,5); title "Quarterly Report for &n"; footnote "Survey of &g_number Departments"; run;   In the log: 37 %macro namels3(name,number); 38 %local n; 39 %global g_number; 40 %let g_number=&number; 41 %do n=1 %to &number; 42 &name&n 43 %end; 44 %mend namels3; 45 %let n=North State Industries; 46 47 proc print; ERROR: There is not a default input data set (_LAST_ is _NULL_). 48 var %namels3(dept,5); MPRINT(NAMELS3): dept1 dept2 dept3 dept4 dept5 49 title "Quarterly Report for &n"; 50 footnote "Survey of &g_number Departments"; 51 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

Hi All, below is the code to create a quoted list separated by spaces. I am trying to modify the program using translate function to create a new list in the same code which contains the output is a list separated by commas. But, what I am trying is not working. Please, help me how to correct this error.    Here, is the code that creates a quoted list separated by spaces:   data one; input empl $; datalines; 12345 67890 45678 ; %let list=; data _null_; set one; call symputx('mac',quote(strip(empl))); call execute('%let list=&list &mac'); run; %put &=list;   Output in the log: %put &=list; LIST="12345" "67890" "45678"   Now, I am trying to use this LIST in the same program to create a new list separated by commas . Here, is the code that I am trying: %let list=; %let var1=; data _null_; set one; call symputx('mac',quote(strip(empl))); call execute('%let list=&list &mac'); call execute('%let var1=$sysfunc(translate(&list,',',' '))'); run; %put &=list; %put &=var1;   In the log errors are: 59 call execute('%let var1=$sysfunc(translate(&list,',',' '))'); ---- 22 ------- 253 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, ^=, |, ||, ~=. ERROR 253-185: The EXECUTE subroutine call has too many arguments. 60 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 61 62 %put &=list; LIST= 63 %put &=var1; VAR1= ... View more

Hi All,        I have the following code from  https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1hogk0ekd1z62n18xx76ou16unt.htm Please, help me to understand why fread is reading only John from the file and not entire record. How to make fread to read entire row of each observation?   %macro test(outf); %let filrf=myfile; %if %sysfunc(fileexist(&outf)) %then %do; %let rc=%sysfunc(filename(filrf,&outf)); %let fid=%sysfunc(fopen(&filrf)); %if &fid > 0 %then %do; %let rc=%sysfunc(fread(&fid)); %let rc=%sysfunc(fget(&fid,mystring)); %if &rc = 0 %then %put &mystring; %else %put file is empty; %let rc=%sysfunc(fclose(&fid)); %end; %let rc=%sysfunc(filename(filrf)); %end; %else %put file does not exist; %mend test;   /*Calling the above macro*/ %test(c:\Address.dat)   Output in the log: %test(c:\Address.dat) John   The contents of test.dat are as follows: John Garcia            114 Maple Ave. Sylvia Chung      1302 Washington Drive Martha Newton    45 S.E. 14th St.     Thanks   ... View more