I'm trying the following sql code and it gave me this warning message when I limit the outputs to 3   Is this warning ok??    1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 proc sql outobs=3; 72 create table &Queries.3 as 73 select category, count(*) as cat 74 from &Queries.1 75 where status="Open" 76 group by 1 77 order by 2 desc; WARNING: Statement terminated early due to OUTOBS=3 option. NOTE: Table WORK.QUERIESN3 created, with 3 rows and 2 columns.   78 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 6269.89k OS Memory 36028.00k Timestamp 03/06/2018 02:36:18 PM Step Count 205 Switch Count 2 Page Faults 0 Page Reclaims 634 Page Swaps 0 Voluntary Context Switches 22 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 272     79 80 81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 93 ... View more

I'm trying to create macros in sql and I'm also trying to create a table and that my code and the error that I got    proc sql ; create table &visit.2 as select count (distinct internal_visit_id) AS counttime, 1360 AS TIME_POINT_CONTRACTED from &visit.1 where Earliest_Visit_Date ne . select counttime , TIME_POINT_CONTRACTED into :counttimet, :timecont from &visit.2; quit;     71 proc sql ; 72 create table &visit.2 as 73 select count (distinct internal_visit_id) AS counttime, 1360 AS TIME_POINT_CONTRACTED 74 from &visit.1 75 where Earliest_Visit_Date ne . 76 select counttime into :counttimet from &visit.2; ______ 22 76 ERROR 22-322: Syntax error, expecting one of the following: <, <=, <>, =, >, >=, EQ, EQT, EXCEPT, GE, GET, GT, GTT, INTERSECT, LE, LET, LT, LTT, NE, NET, UNION, ^=, ~=.   ERROR 76-322: Syntax error, statement will be ignored. ... View more

I have this code in proc sql  and I want to create a macro variable for only one raw of the variable counttime  I saw some methods to create macro variable for all the variables that selected but I don't know how to do it for only a variable.      select internal_visit_id, Earliest_Visit_Date, count (distinct internal_visit_id) as counttime from &visit.1 where Earliest_Visit_Date ne .; quit;   ... View more

I want to create sequences of sas data set macros for example &site  is a subset of site  then I want to create &site1 which is the subset of &site    then &site2 which is a subset of &site1    Do you know what is the best way to do it, bc when I tried to do it this way &&site1 it shows error in the log    %let site=site; PROC IMPORT OUT=&site DATAFILE= "&Path1" DBMS=XLSX REPLACE; run; data &&site1; set &site; run; 92 &site1 _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, /, ;, _DATA_, _LAST_, _NULL_.   ERROR 200-322: The symbol is not recognized and will be ignored.   ... View more

I'm new to proc sql. I want to print the results of proc sql table    can you help me to do that?? ... View more