About R_Win

R_Win · ‎12-11-2012

Is there any SAS Free Trail Version Available. please help me in this if any version is available can u send me the link.

R_Win · ‎10-01-2012

Ref this

R_Win · ‎10-01-2012

i am having a data set data main; input sal; cards; 100 200 run; data mon_sal; input days; cards; 2 3 run; %macro sas_cal; proc sql; select count(*) into :cou from mon_sal; select sal into s1-s&cou from main; quit; data mon_sal; set mon_sal; do i=1 %to &cou; mo_days=days*s&cou; %end; run; %mend; %sa_cal; I am trying to iterate it as the same calulation i want to do for few datasets i want the sal from one dataset and days from another datasets to create new variable how can i macro tise it output of mon_sal; days mo_days 2 200 3 600

R_Win · ‎09-28-2012

data l; input id age; cards; 2 2 2 2 run; data l2; input amt rupees; cards; 3 4 5 6 run; proc sql; select count(*) into :cnt from l2; quit; %macro cal; %do i =1 %to &cnt; data _null_; set l; call symput('id',id); call symput('age',age); run; data l2; set l2; amt =amt *&id; rupees=rupees*&age; run; %end; %mend; %cal; output shd be for L2 6 8 10 12

R_Win · ‎09-28-2012

data l; input id age; cards; 1 2 3 4 run; i want to create a macro do loop it and calculate it for ex data l2; input amt rupees; cards; 3 4 5 6 run; now i wnat to usae the macro and calulate dynamically proc sql; select count(*) into :cnt from l2; %macro cal; %do i =1 %to &cnt; data l2; set l2; amt =&id*2; rupees=&age*2; run; %end; %mend; %cal; output for l2 6 8 10 12

R_Win · ‎08-28-2012

data l2; input id $; cards; c1 c2 c3 run; proc sql; select count(*) into:emailtblcnt from l2; quit; In this the macro varibale at a time should hold one value if we run this at one instance the macro ids should have one value. how can i loop it %macro emicnt; %do i=1 %to &emailtblcnt.; proc sql; select id into:ids from l2; quit; %put &ids; %end; %mend; %emicnt;

R_Win · ‎08-27-2012

SENDING EMAIL Data l; input id email; cards; 1 xyz@abc.com 2 abc@abc.com 3 xyz@xyz.com run; now i want to send email to correspoinding id for example for email xyz@abc.com it should go the id is 1 abc@abc.com it should go the id is 2 xyz@xyz.com it should go the id is 3 Refer the attachment if needed

R_Win · ‎08-23-2012

done this ok i have tryed on this data for example it shd be Input: done this ok output shd be done|this|ok you can che the text file

R_Win · ‎08-23-2012

data l i am having a record in a table that data in that record is having with tab Ex: OBS_Data done this ok Now i want to split it in to obs Obs1 -Done Obs2- this obs3-ok or is there any way in the data that we can replace tab with | or ^ Ex: done^this^ok

R_Win · ‎07-03-2012

How can i count the spaces in between the words data sp; input word $ 1-100; cards; as,bn hj nm lpo a b acf b c d a,b,c,d,e asdf 29/12, SOUTH TUKOGANJ, a b,c d e 29/12,29/12,29/12, run; Actually i want is in the data if we are having 5 words separated by space or comma it should give one flag as 1 word flag as,bn hj nm lpo 1 a b 0 acf b c d 1 a,b,c,d,e 1 asdf 0 29/12, SOUTH TUKOGANJ, 0 a b,c d e 1 29/12,29/12,29/12, 0

R_Win · ‎07-03-2012

How can i count the spaces in between the words data sp; input word $ 1-100; cards; as,bn hj nm lpo a b acf b c d asdf 29/12, SOUTH TUKOGANJ, run; output spacecount as,bn hj nm lpo 4 a b 1 acf b c d 3 asdf 0 29/12, SOUTH TUKOGANJ, 2

R_Win · ‎07-03-2012

How can i count the spaces in between the words data sp; input word $ 1-100; cards; as,bn hj nm lpo a b acf b c d asdf 29/12, SOUTH TUKOGANJ, run; output spacecount as,bn hj nm lpo 4 a b 1 acf b c d 3 asdf 0 29/12, SOUTH TUKOGANJ, 2

R_Win · ‎06-29-2012

thqs it worked

R_Win · ‎06-29-2012

Thqs its working

R_Win · ‎06-28-2012

HI i am having data in some obs the data will be repetative i want to supress that records how can i do i.i dont know the length as it may be 3 or 100 how can i do.I want to supress them ex data Test; input id$ 1-100; cards; AAA VVVVVVVVVVVVVVVVVVVVVV EEEEEEEEEEEEEEEEEEEEEEEEEE RTYUY QWEPO ZZZZZZZZZZZZZ KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK KOOL GONE RUN ; OUTPUT SHOULD BE : RTYUY QWEPO KOOL GONE CAN REFER THE TEXT

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Is there any SAS Free Trail Version Available.

Re: Cal the obs and Macrotise the value

Cal the obs and Macrotise the value

Re: Macro iteraction and calcualtion

Macro iteraction and calcualtion

Reg:Macro Looping i wnat one obs in that macro

Sending Email

Re: Reg:REplace tab with pipe or ^

Reg:REplace tab with pipe or ^

Re: count spaces between words

Is there any SAS Free Trail Version Available.

Re: Cal the obs and Macrotise the value

Cal the obs and Macrotise the value

Re: Macro iteraction and calcualtion

Macro iteraction and calcualtion

Reg:Macro Looping i wnat one obs in that macro

Sending Email

Re: Reg:REplace tab with pipe or ^

Reg:REplace tab with pipe or ^

Re: count spaces between words

Re: count spaces between words

count spaces between words

Re: SUPRESS IF THE ENTIRE OBS IS SAME

Re: SUPRESS IF THE ENTIRE OBS IS SAME

Re: SUPRESS IF THE ENTIRE OBS IS SAME