About manojinpec

BrahmanandaRao · ‎03-13-2021

Please give solution if any documentation for email reporting after prepare proc report

nirupama1 · ‎11-09-2018

Yes, I was using cards.Thank you! it is really helpful. 🙂

ChrisBrooks · ‎09-06-2017

Also I'm not sure we should be helping people with WPS related problems given the history - "Just use SAS" would be my response...

Rick_SAS · ‎03-13-2017

To help with your Googling, this technique (removing the extreme observations) is known as "trimming". You can use PROC UNIVARIATE to get the trimmed means. You can read about some of the statistical shortcomings that are associated with trimming (or "Winsorizing") data, If you are trying to perform a robust ANOVA, the best way is to use a statistical procedure that is not sensitive to outliers. There is an example in the SAS documentation that shows how to use PROC ROBUSTREG to perform a robust ANOVA. By using PROC ROBUSTREG, you will not throw away good data unnecessarily, which is what happens when you automatically discar the minimum and maximum values in each group.

VijayRK1 · ‎02-07-2017

proc sort data=demo(firstobs=3 obs=5) out=demo9; by patient; run; Ref: http://www2.sas.com/proceedings/sugi31/030-31.pdf

Jagadishkatam · ‎12-30-2013

Hi, Did you try to read the version 8 data into version 9 by creating a new library like below libname mydata v9 "~path of the datasets"; Please try to read data from mydata library(engine v9). Thanks, Jag

LinusH · ‎11-07-2013

Wow... There are a lot of "What's new..." documentation. And lot of papers presented on a bunch of SAS Global Forums. Which products do you use? On what level are management? I believe that the level of support from SAS on old versions is an important issue for management...?

kuridisanjeev · ‎06-12-2013

Yes ,You Have to mention %global in your macro as said by . or else you have to create all the macro variables with dummy values before the macro. like data have; input var; datalines; 12 34 8 79 84 ; run; %let Val1=0; %let Val2=0; %let Val3=0; %let Val4=0; %let Val5=0; %macro m1; proc sql noprint; select count(var) into :cnt from have ; quit; Proc sql noprint; select var into :val1 - :val%left(&cnt) from have; Quit; %mend; %m1; %put &val1 &val2 &val3 &val4 &val5; But i always prefer to use %Global. Regards. Sanjeev.K

MKA · ‎06-12-2013

Try "Install Additional Software" instead of "Perform a Planned Deployment" - worked fine for me...

CarlosSantos · ‎08-06-2013

The result is correct because the format monname3. only works with sas date value and not with the month value. try this to see the difference: data _null_; call symputx('_month',put(date(),monname3.)); put "&_month." ; call symputx('_month2',month(date())); put "&_month2." ; call symputx('_month3',put(month(date()),monname3.)); put "&_month3." ; run; Regards, Carlos S

manojinpec · ‎02-01-2013

Hi Sanket, Please forward me to er.manoj@gmail.com if you get any docs.

vanukuru · ‎03-13-2015

Hi, I am Bharath I am new to this community and I am learning SAS tools for Text analytics.

manojinpec · ‎01-10-2013

you can also buy license for sas connection to that paricular database

lalmohan · ‎11-20-2012

IF WANT ONLY UNIQUE VALUE FROM TABLE A (WHICH IS NOT PRESENT IN TABLE B) YOU CAN USE THIS. PROC SQL NOPRINT; CREATE TABLE REFDATE_PORTFOLIOS AS SELECT A.PERMNO, /*A.DATE,*/ A.CUSIP/*, A.SHRCD, A.PRC, A.VOL, A.RET, A.SHROUT, A.VWRETD, B.R_RET*/ FROM /*PERFECT.*/CRSP_COMMONSTOCKS as A LEFT JOIN /*PERFECT.*/MAX_DECILED as B ON A.REFDATE=B.REFDATE and A.CUSIP=B.CUSIP WHERE B.CUSIP IS NULL; quit;

art297 · ‎09-12-2012

manojinpec: You never posted the code showing how you are creating the macro variable &part. Your original code wouldn't have resolved correctly, anyhow, but Amir's solution did work if the macro variable had been created correctly. Did you test it using the mlogic symbolgen and mprint options? I took dde out of the equation and ran the following to see if you were creating what you expected to create. You might want to try to do the same with your current code: data load_time2; informat final_delay $20.; input final_delay &; cards; Some Delays No Delay No Delays Lots of Delays ; %let part=11; data _null_; set load_time2; file "c:\testdde.txt";; if ((final_delay)='No Delays') then do; put '[select("R' "&part" 'C23")]'; put '[patterns(1,,6,true)]'; /* color it red */ end; run;

Online Status	Offline
Date Last Visited	‎09-06-2017 07:31 AM

Re: Load .WPD file to SAS as SAS7BDAT

Reading Version 8 sas datasets in version 9

Different Between SAS 8.2 and SAS 9.3

Re: Count with left

Re: SAS Installation Issue

Re: branch wise excel file using macro

Re: A Lock is not available..

Re: branch wise excel file using macro

Re: Issue with data set variable's data type

Re: Issue with data set variable's data type

Question on referring to variables

Re: branch wise excel file using macro

what is the purpose of if _N_=1 then do in this data step?

what's wrong with this macro?

Please let me know the reason

PROC XSL - any experiences?

Re: branch wise excel file using macro

Re: What is the difference between Missover and Truncover?

Re: Load .WPD file to SAS as SAS7BDAT

Re: How to exclude highest and lowest value from dataset?

Re: Basic Question on Obs= in proc sort

Re: Reading Version 8 sas datasets in version 9

Re: Different Between SAS 8.2 and SAS 9.3

Re: Count with left

Re: SAS Installation Issue

Re: MONNAME3.

Re: SAS E-MINER

Re: Introducing ourselves

Re: Querying SAS Data from Outside SAS

Re: Merging with PROC SQL

Re: USING DDE Excel with Macro Variable