About allurai0412

allurai0412 · ‎04-20-2013

hi, please check as DEFINE AUTH / ANALYSIS mean; DEFINE ASGN / ANALYSIS mean;.... ......... ......... COMPUTE AVG; /*IF AUTH=0 THEN AVG=ASGN/1;*/ AVG=(AUTH.mean/ASGN.mean); ENDCOMP; or please check the example with SASHELP.CLASS... Proc Report data=sashelp.class nowd; columns name sex age height weight ratio; define name / 'name' display width=10; define sex / display width=6; define age / display width=4; define height /'htmean' analysis mean format=8.1; define weight /'wtmean' analysis mean format=8.1; define ratio / computed format=percent8.2; compute ratio; ratio = height.mean / weight.mean; endcomp; rbreak after / summarize; run;

allurai0412 · ‎04-20-2013

hi PG, I have attached the txt file to my original post ....please help.. Regards Allu

allurai0412 · ‎04-20-2013

hi, I used this for little bit big data.....but i found some errors.. data porfolio; infile 'C:\Users\galax_allu\Desktop\portfolio.txt' dlm=',' pad ; input Portfolio $ Expiration_Date mmddyy9. @17 TradeDate mmddyy9. Master_Ticket_Number Ticket_Number Ticket_type $ Transaction_Type $ Amount dollar11.2; format expiration_date mmddyy9. tradedate mmddyy9.; run; data trade_post; set porfolio ; by portfolio notsorted; if first.Portfolio then call missing(t) select(Transaction_Type); when ("Buy") t + Amount; when ("Sell") t + (-amount); otherwise; end; run; PROC PRINT data=trade_post ;RUN; ................................................... The Amount in "t" column is not as Required.....it is summing up sometimes and sometimes not.... Note : Even I sorted by Portfolio Transaction_type ,..........it is not working.. i have attached TXT of my file..................please help...

allurai0412 · ‎04-20-2013

hi, Thanks for help....how can take "Trans " also for addition of updated_corpus folio transtype tradeunits updated_corpus 566 buy 5678 5678 566 buy 344 6022 566 buy 1222 7244 566 sell 1000 6244 455 buy 3455 3455 455 trans 344 3799 455 sell 234 3565

allurai0412 · ‎04-20-2013

hi, i need some help to get my required output .....i need the updated corpus.....whenever 'SELL"transtype happens..i need substract that from UPDATED_CORPUS...i used Retains and last.id ...but it is giving me just sum...... data have; input folio transtype $. tradeunits; datalines; 566 buy 5678; 566 buy 344; 566 buy 1222; 566 sell 1000; 455 buy 3455; 455 trans 344; 455 sell 234; run; ***********************Required output************** folio transtype tradeunits updated_corpus 566 buy 5678 5678 566 buy 344 6022 566 buy 1222 7244 566 sell 1000 6244 455 buy 3455 ............. 455 trans 344 ................ 455 sell 234 Regards ALLU Message was edited by: Y ALLU

allurai0412 · ‎04-18-2013

hi , we can use PROC FORMAT..!! Regards ALLU proc format; value trace_id '29MAY2012'D - < '12JUL2012'D = '101' '05AUG2012'D - '22AUG2012'D = '102' '01SEP2012'D - '05SEP2012'D = '102' ; RUN; DATA TABLE1; infile datalines truncover; INPUT MRN E1 date9. i1 date9.; format E1 trace_id.; FORMAT i1 trace_id.; datalines; 999 12jun201222JUN2012 ; run;

allurai0412 · ‎04-15-2013

hi , try this...but............please atleast post your working / sample datasets..... data samp; infile datalines missover; input id sal ; if missing(sal) then sal=symget("avgsal"); datalines; 001 5000 002 7000 003 004 7832 005 ; run; proc sql noprint ; select avg(sal) into : avgsal from samp ; run; Regards ALLU

allurai0412 · ‎04-08-2013

hi, please check in the below link... i guess it will help... https://communities.sas.com/message/123860 Regards ALLU

allurai0412 · ‎04-03-2013

hi, Did you check the OPTIONS in the SAS 9.2 editor..??/ second point please check with other name of the RTF file....like scaterr1 or scatterr2.... please find the attachment of my OPTIONS,....in SAS editor... I got no error with your code.......except i have taken my data..... *******************my data********************* Data have ; input GVKEY SID data_date SICS SALES comma6.3; format GVKEY z6. ; FORMAT DATA_DATE MMDDYY9.; datalines; 001004 1 19970531 4582 46.14 001004 2 19970531 4582 34.395 001004 1 19980531 4582 53.16 001004 2 19980531 4582 39.66 001005 3 19981031 3412 189.897 001005 4 19981031 3443 26.328 001005 5 19981031 5088 31.787 ; run; ods rtf file='C:\Users\galax_allu\Desktop\scatter.rtf'; proc gplot data=have; plot SICS*SALES; run; quit; ods rtf close; *************************options settings for RESULTS**************88

allurai0412 · ‎04-03-2013

hi, i am getting success with no errors (SAS 9.2)... please check 1)the data set exists or not 2)the output destinations in html and ods prefrences.... Please check in SAS editor .... Tools...>options...>preferences,,,>results....> please check here...how is ur settings ...??? Regards ALLU

allurai0412 · ‎04-01-2013

hi, i made some modifications to jagadish help, .....'If you want particlulary the first......observation to be imputed to entire row'' the follwing will helps you.. Note : if first obs is 'Numeric' ...then only this would helps... data ddd; input first num1 num2; datalines; 12 33 56 23 44 67 22 56 78 ; run; data want(drop =i); set ddd; array mis(2) num1-num2; do i = 1 to 2; mis(i)=first; end; run; Regards ALLU

allurai0412 · ‎03-30-2013

hi, i am still have some questions ... what are the values you assinged to the following ? &nod...........? &subject...........? And please try without macros for single value/excution......and post here...some one would help you Regards ALLU

allurai0412 · ‎03-25-2013

hi, Thanks ...i found the error....I have not included the "&" in the line .. SHEET="EXL_SHT"; It is working now... Regards, ALLU

allurai0412 · ‎03-25-2013

hi, I am trying to import multiple excel sheets to get different ouput datasets,.... Please check and help ...what's wrong in my approach?? %MACRO IMPR(IMP,OUT_DAT,EXL_SHT); PROC IMPORT DATAFILE="&IMP" DBMS=EXCEL OUT=&OUT_DAT REPLACE; SHEET="EXL_SHT"; MIXED=YES; RUN; %MEND IMPR; %IMPR(C:\Users\galax_allu\Desktop\Y3DTR.XLS,PURCHASE, PUR); %IMPR(C:\Users\galax_allu\Desktop\Y3DTR.XLS,SWITCHES, SWT); ***************Error message**************88 NOTE: Data source is connected in READ ONLY mode. ERROR: File _IMEX_.'EXL_SHT$'n.DATA does not exist. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.96 seconds cpu time 0.56 seconds

allurai0412 · ‎03-24-2013

hi, May be it is problem with quotes ....in the line... LABEL icd_n = 'Sum Diagnoses';...................should like... LABEL icd_n = Sum Diagnoses; Regards ALLU

Online Status	Offline
Date Last Visited	‎04-21-2016 11:24 AM

Re: How to create cumulative sums

Re: Delimiter for Tab in SAS.

Re: multiple sheets in excel

Re: Splitting up accounts on a weekly basis

Re: Splitting up accounts on a weekly basis

Re: Splitting up accounts on a weekly basis

Re: Why doesn't the book's macro to separate data work?

Re: search long hyphen (−) in the program

Re: function ...contain()

function ...contain()

Re: SAS datatime variables

Re: SAS datatime variables

Re: concatenating all observations in single

Re: concatenating all observations in single

Re: search long hyphen (−) in the program

Re: Delimiter for Tab in SAS.

Re: diff b/n value and invalue in Proc Format

Re: PROC REPORT multi avg

Re: multiple sheets in excel

Re: search long hyphen (−) in the program

Re: PROC REPORT multi avg

Re: Updted corpus by retain / last.id ....

Re: Updted corpus by retain / last.id ....

Re: Updted corpus by retain / last.id ....

Updted corpus by retain / last.id ....

Re: Array Task?

Re: I have 2 data sets one with mean value for each variable(proc mean...

Re: Libname error with excel engine

Re: Unable to see graph output in HTML and RTF when using ODS

Re: Unable to see graph output in HTML and RTF when using ODS

Re: How to impute the first observation value in the entire row

Re: SAS Macro help

Re: Creating datasets based on 'sheets' in Excel!!

Creating datasets based on 'sheets' in Excel!!

Re: simple problem with labeling variables