Hello everyone; I have a problem when I run the code: %put This is  Tom's car; Please advise. Thanks! ... View more

Hello everyone, I have a problem import .xls file to SAS when the sheet's name including " - " (Minus sign with blanks),please advise. Thanks! Mike PROC IMPORT OUT= one DATAFILE= "c:\abc.xls" DBMS=EXCEL REPLACE; SHEET="north - east"; /*if I remove the blanks before and after the minus sign that will be ok(sheet="north-east")*/ GETNAMES=YES; MIXED=YES; USEDATE=YES; SCANTIME=YES; RUN; ... View more

Hi guys, When open a sas program in SAS ,you open a windows to choos the program you want to open,on the right top there is a "submit " option ,I don't know what this for. please see the attached picture,right top. could anyone can help me explain that? Thanks ... View more

Hello All, When I create a new favorite folder in SAS ,after I close the SAS section and re-open SAS,the new favor folder will disappear, How to create a favorite folder permernently? Thanks, Mike ... View more

Hello everyone, when I connect to SQL server with SAS ,I use the code as below. Could anybody please help me explain what is the defference between sdn and schema? Thanks! Mike libname mydatas odbc dsn=name1 schema=dbo; ... View more

Hello everyone, when i connect to sql server with SAS ,I use the code as below,but I don't even know what is the meaning of the code. Could anybody please help me explain what is the meaning of the SAS code below(2,3,4,)? Thanks! Mike   1.libname mydatas odbc   2. bulkload=YES   3.dsn=name1   4; schema=dbo; ... View more

Hello everyone, Is there any SAS options for us so when we create a new dataset has same name with other dataset but the new dataset doens't override the old one? maybe automaticly change the new dataset's name. Thanks ... View more

Hello everyone, How to specify options to run a macro without show the content of the macro in the SAS log? Thanks ... View more

.Hello everyone, The code below I just what to see the macro options  show "mlogic and mprint" result of the macro, but I don't want it be executed,just for testing the code before it will be run in the remote server .Please give me asome advice. Thanks! Mike. options mlogic mprint; %macro one; rsubmit; data a; ..... run; proc sql; create table b as .... ; quit; ... endrsubmit; %mend one; %one; ... View more

Hello averyone, If we use "num " command we can show the rows number of each row in SAS code. My question is Is there any auto macro or SAS  function can record/return the row number? /*SAScode_one.sas*/   ........ 165 proc transpose data = one out = two; 166 by LN_NBR; 167 id StaffID; 168var STAFF_INDIV_ID; 169 run; ....... in the example above,transpose statement's row number is 165. The aim is when run the SAS code ,we can see the log ,I want to add some information(such as current running code's row number in the code) show on the log.. Thanks! Mike ... View more