About shivamarrora0

shivamarrora0 · ‎07-20-2017

Hi all i have data in vertical format i want it in horizontal format without using proc transpose with simple approch

shivamarrora0 · ‎07-16-2017

Hi Reeza, i know it from proc sql but i want to do it from data step only

shivamarrora0 · ‎07-16-2017

Hi all can you Please solve my small problem data have; input id name$ marks; total+marks; cards; 1 a 10 2 b 20 3 c 30 4 d 40 ; run; in the above the last observation of total will 100 i want to make a new variable called V and put the last observation of total in every observation of V i dont want to hardcore the value i want to make it dynamic output like this

shivamarrora0 · ‎07-10-2017

Thank you @Reeza 🙂

shivamarrora0 · ‎07-10-2017

i want this as output

shivamarrora0 · ‎07-10-2017

I want to multiply those 4 values to every 1-4 observations repeatedly . like Donald will multiply by 1st value of array then Ricky by 2nd value of array .. This operation repeat for every 1-4 observation. I am sorry if am unable to portray what i want

shivamarrora0 · ‎07-10-2017

but if i have some more observations and want to multiply them by same , then it will give the error " Array subscript out of range" ex: data have (drop=mult:); input emp_name $ sal ; array mult(4) (.1,.25,.09,.11); want=sal*mult(_n_); cards; Kevin 3000 david 2300 Kat 2100 ricky 10000 Donald 2100 Ricky 1100 ; run;

shivamarrora0 · ‎07-10-2017

Hi All, i want to use array and loops only i want to multiply the 1st emp salary by .10 2nd by .25 3rd by .09 and 4th by .11 data have; input emp_name $ sal ; cards; Kevin 3000 david 2300 Kat 2100 ricky 10000 ; run;

shivamarrora0 · ‎07-03-2017

Thanks for the explanation , if possible can you please tell the code

shivamarrora0 · ‎07-03-2017

i just started learning SAS. data test; p=100000; int=.10; do i = 1 to 5; p+p*int; end; run; this code will over right the original data

shivamarrora0 · ‎07-03-2017

i just started learning SAS. data test; p=100000; int=.10; do i = 1 to 5; p+p*int; end; run; this code will over right the orginal data

shivamarrora0 · ‎07-03-2017

I want to do using loops Hi, i have below data p=100000 interest=10% will be the total amount after 4 years i want below screen result Year Principal interest sum 1 100000 0.1 110000 2 11000 0.1 12100 3 12100 0.1 13310 4 13310 0.1 14641

shivamarrora0 · ‎06-20-2017

dataset id include exclude a . abc a . xyz b j abf b . gtj output required a . abc,xyz b j abf,gtj

shivamarrora0 · ‎05-30-2017

Tom, I am new to SAS i just tried to create blank dataset with 5 var and 10 obs.

shivamarrora0 · ‎05-30-2017

/* you can use the below simple code as well */ data z; input id1$ id2$ id3$ id4$ id5$; cards; a b c d e a b c d e a b c d e a b c d e a b c d e a b c d e a b c d e a b c d e a b c d e a b c d e ; run; data blank; set z; id1=""; id2=""; id3=""; id4=""; id5=""; run;

Online Status	Offline
Date Last Visited	‎04-09-2018 05:05 AM

Re: Way to export graph into Excel

Way to export graph into Excel

Re: Run the whole code on the base of condition

Run the whole code on the base of condition

Re: Using IF condition while using PUT function

Using IF condition while using PUT function

Re: reading raw data

reading raw data

sas report format

sas boxplot

Re: Arrays

Re: base sas

base sas

Re: base sas

Add overall total to the data set

Re: Arrays

Re: Arrays

Re: Arrays

Re: Arrays

Arrays

Re: loops

Re: loops

Re: loops

loops

delete multiple observations

Re: SAS code to create a blank dataset with 5 variables and 10 observa...

Re: SAS code to create a blank dataset with 5 variables and 10 observa...