Hi,   I am instructor, registered the same with SAS on demand. When i try uploading the 2GB file, it is not allowing me to do. Can some one help me with that?   Thanks   ... View more

Not sure on the location: So I have selected Base SAS programming. If somebody wants this to be changed, feel free to tell me. I wanted to use SAS back end. I mean at frond end I will have webpage, where I am allowed to enter data into input text boxes. Data entered by user has to be put into SAS datasets. Front end can be JAVA(JSP)/PHP. I need (may be a doc) how JSP/PHP and SAS interconnected? I have searched out but couldn't get info. Can somebody help me on this, please? Thanks. ... View more

Wanted to understand, Merge will retain the values in PDV or intializes the values when it reaches DATA statement.   DATA TESTA; INPUT A B; DATALINES; 10 20 20 30 30 40 ; RUN;   DATA TESTB; INPUT C D; DATALINES; 10 20 20 30 30 40 40 50 ; RUN;   DATA TESTC; PUT _ALL_; MERGE TESTA TESTB; PUT _ALL_; RUN;   when i see the log    a=. b=. c=. d=. _ERROR_=0 _N_=1 a=10 b=20 c=10 d=20 _ERROR_=0 _N_=1 a=10 b=20 c=10 d=20 _ERROR_=0 _N_=2 a=20 b=30 c=20 d=30 _ERROR_=0 _N_=2 a=20 b=30 c=20 d=30 _ERROR_=0 _N_=3 a=30 b=40 c=30 d=40 _ERROR_=0 _N_=3 a=30 b=40 c=30 d=40 _ERROR_=0 _N_=4 a=. b=. c=40 d=50 _ERROR_=0 _N_=4 a=. b=. c=40 d=50 _ERROR_=0 _N_=5 NOTE: There were 3 observations read from the data set WORK.TESTA. NOTE: There were 4 observations read from the data set WORK.TESTB. NOTE: The data set WORK.TESTC has 4 observations and 4 variables. NOTE: DATA statement used (Total process time):       real time           0.03 seconds       cpu time            0.01 seconds   What is happening with MERGE statement?? Can somebody can help me in understanding this?? ... View more

Hi, Im unable to tag URL using CALL DEFINE in PROC REPORT? can somebody help on this. Code that i used here is DATA TEMP; SET SASHELP.AIR(OBS=10); RUN; ODS TAGSETS.EXCELXP PATH="ABC" FILE="REPORT.XLS" STYLE=PRINTER OPTIONS(ABSOLUTE_COLUMN_WIDTH="11" GRIDLINES='NO' WRAPTEXT='NO' EMBEDDED_TITLES='YES' EMBEDDED_FOOTNOTES='YES'); ODS TAGSETS.EXCELXP OPTIONS(SHEET_NAME="TABONE"); PROC REPORT DATA=TEMP(KEEP=AIR); COMPUTE AIR;/*DEFAULT ACTION FOR COMPUTE BLOCK IS TO SUM UP ALL ROWS FOR COLUMN 'AIR'*/ CALL DEFINE(_COL_,'URL',www.google.com);/*HYPERLINKING SUMMARY VALUE TO NEXT TAB*/ ENDCOMP; RUN; ODS TAGSETS.EXCELXP CLOSE; When i go to excel and look at URL, i could see that it is going to abc\www.google.com , but i want it should go to www.google.com. Thanks. ... View more

Hi, My below code taking 211 CPU seconds in Mainframes.I have 8 code snippets similar to below code, that needs to be run daily? any idea how can i optimize them?? ODS TAGSETS.EXCELXP BODY=HTML1    OPTIONS(SHEET_NAME='123'); PROC PRINT DATA=ABC      WHERE REGION IN ('123');                                       VAR var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12;      FORMAT var3 var4 MMDDYY10.;                        RUN;   ODS TAGSETS.EXCELXP                                               OPTIONS(SHEET_NAME='456'); PROC PRINT DATA=DEF      WHERE REGION IN ('456');                                       VAR var1 var2 var3 var4 var5 var6 var7 var8 var9 var10 var11 var12;      FORMAT var3 var4 MMDDYY10.;                        RUN; ODS TAGSETS.EXCELXP CLOSE; ODS LISTING;             And each proc print gives more that 100K observations, that variables that are included VAR condition are always same, but the data i read from is different, ABC in 1st and DEF in 2nd. Thank you. ... View more

data one; do i = 9 to 11; nextfile = "C:\sasuser\month"!!compress(put(i,2.))!!".txt"; infile temp filevar=nextfile; input num; output; end; /*stop;*/ run; if i comment the stop keyword, program going to infinite loop, what makes programe to go infinite loop, can somebody please explain? In those files, i have data num. My assumption is after run, it is again going to Data step and executing whole code again and again. Is it true?? If at all this is the reason, why the below code is not going infinite loop? data one; a=1; run; Can somebody please explain? Thank you very much. ... View more