columns are being selected by *(all columns) if you want to specify only few columns, then specify the names in place of * ... View more

Hi, What i understand from your code is, you want to left join both the tables and want only those records for the first instance of the id. below is the code which can do it for you, you need to use your column names. proc sql; create table final as select *,monotonic() as rowid from test as a left join test1 as b on a.opbel=b.opbel group by a.opbel having rowid=min(calculated rowid); quit; ... View more

Hi here are 3 basic programs to illustrate do, do while and do until loop.   hope this helps you to understand.   /*DO LOOP*/ data doloop; age=5; do year=2010 to 2030 by 1; age=age+1; output; end; run; /*DO WHILE LOOP*/ data doloop; age=5; year=2010; do while(year<=2030); year=year+1; age=age+1 ; output; end; run; /*DO UNTIL LOOP*/ data doloop; age=5; year=2010; do until(year=2030); year=year+1; age=age+1 ; output; end; run; Thanks ... View more

I assume your base dataset has 12 entries for all the 12 moths. as per your code the output data should have 6 records, but you can obviously check it in log as well and check the values which are being returned by qtr function ... View more

could you please show what exactly you have in your hand and what you want as an output dataset. ... View more

Hi,   43626 43146 43146 42826 42586  these dates are of 2076 and 2078(in sas format) the numbers which you are seeing are the number of days between jan 1 1960(cutoff date for sas) to whatever dates are these, of 2076 or so. now coming to your issue. There must be some problem when you are importing your excel file to sas that's why dates are getting disturbed. could you show your code which you are using for importing the data.   FILENAME REFFILE 'filepath/test.xlsx'; PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=WORK.IMPORT; GETNAMES=YES; RUN; I used the above code for importing the file and its working fine for me   ... View more