R_Win Tracker

Is there any SAS Free Trail Version Available.

R_Win — Tue, 11 Dec 2012 07:15:16 GMT

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

Re: Cal the obs and Macrotise the value

R_Win — Mon, 01 Oct 2012 18:47:13 GMT

Ref this

Cal the obs and Macrotise the value

R_Win — Mon, 01 Oct 2012 18:45:34 GMT

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

Re: Macro iteraction and calcualtion

R_Win — Fri, 28 Sep 2012 13:42:03 GMT

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

Macro iteraction and calcualtion

R_Win — Fri, 28 Sep 2012 13:30:41 GMT

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

Reg:Macro Looping i wnat one obs in that macro

R_Win — Tue, 28 Aug 2012 14:14:41 GMT

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;

Sending Email

R_Win — Mon, 27 Aug 2012 15:00:23 GMT

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

Re: Reg:REplace tab with pipe or ^

R_Win — Thu, 23 Aug 2012 14:30:07 GMT

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

Reg:REplace tab with pipe or ^

R_Win — Thu, 23 Aug 2012 13:44:16 GMT

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

Re: count spaces between words

R_Win — Tue, 03 Jul 2012 09:30:57 GMT

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

Re: count spaces between words

R_Win — Tue, 03 Jul 2012 07:28:12 GMT

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

count spaces between words

R_Win — Tue, 03 Jul 2012 07:27:00 GMT

Re: SUPRESS IF THE ENTIRE OBS IS SAME

R_Win — Fri, 29 Jun 2012 09:37:23 GMT

thqs it worked

Re: SUPRESS IF THE ENTIRE OBS IS SAME

R_Win — Fri, 29 Jun 2012 08:23:41 GMT

Thqs its working

Re: SUPRESS IF THE ENTIRE OBS IS SAME

R_Win — Thu, 28 Jun 2012 14:15:32 GMT

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

SUPRESS IF THE ENTIRE OBS IS SAME

R_Win — Thu, 28 Jun 2012 14:14:07 GMT

splitting data to differnt Rows

R_Win — Fri, 27 Apr 2012 06:45:29 GMT

Splitting the data in to differnt rows id name value2 value3 1 a,b a:1,b:1 a:2,b:2 2 a,b a:3,b:4 a:3,b:4 3 a a:5 a:6 4 a,b,c,d a:10,b:20 c:30 d:40 a:10,b:20 c:30 d:40 Output I am having a variable Name it should split base on the commas and the correspoding value(value2 and value3) sould come. id Name value2 value3 1 a a:1 a:2 1 b b:1 b:2 2 a a:3 a:3 2 b b:4 b:4 3 a a:5 a:6 4 a a:10 a:10 4 b b:20 b:20 4 c c:30 c:30 4 d d:40 d:40 For ef you can view in txt

Re: Find Dlm Postion

R_Win — Thu, 12 Apr 2012 13:57:50 GMT

actually my DLM was '^' but when i changed it pattern=prxparse("/\^/"); iam getting warnings ERROR: Argument 1 to the function PRXNEXT must be a positive integer returned by PRXPARSE for a vali d pattern.

Find Dlm Postion

R_Win — Thu, 12 Apr 2012 13:02:26 GMT

I wnat to find the 7 th positon of delimter '?' as (i am having 120 delimiters in a line as i have given below as example) data a; input id$ 1-10; i=findc(id,'?'); do until i=32; cards; 1?2?3445??6?7?8?9?10 ; run;

Re: Reg:Count in to a macro variable

R_Win — Fri, 30 Mar 2012 06:47:28 GMT

small probelm data l2; input id no; cards; 1 100 2 200 3 300 3 400 run; proc sql; select count(*) into :l2 from l2 where id=3 having no=max(no); quit; %put &l2; But i want the count id =3 and no having max count here the max(no)=400 so i should get count as 1 but it was getting output as 2.