About shru

shru · ‎10-31-2013

Hi, I need to append the data in the excel every month on a column wise using Libname excel method. For example:i need to append the data everymonth How can i do this..it would be helpfull if you suggest me on the same thanks shruthi

shru · ‎01-11-2013

Hi, My code is data text; set data1; if nobs=1 then do; b=0; v=0; end; b=b+bal; v=v+val; run; Where my data1 datset contains a column nobs like below nobs 2 3 4 5 6 7 and i want result like nobs bal val 1 2 3 2 3 5 3 5 8 likewise the code should produce the cumulative values ,but i am getting the missing value when i run the above code can anyone let me know is there any other way to do or y is this failing? Thanks

shru · ‎11-20-2012

Hi, There are four tables which are explicitly joined in a proc sql,can i use three inner joins for the same to get same results have a little confusion on this. for example: proc sql; select a.*,b.*,c.*,d.* from ahru as a, dsdf as b,ghdgfs as c,gfgsfs as d where a.dsss=b.gadfgafd; ; quit So for the same can i use three inner joins? Also,bit curious about what is the maximum inner joins we can use? Your help is needed Shru

shru · ‎08-14-2012

Hi, Just curious,Is there any method to export a sas dataset to excel format except proc export or ODS ? Anyone suggest on this please? Thanks Shru

shru · ‎04-03-2012

Hi, My excel file is like this obs Mar-12 1 56 2 34 4 . 5 . 6 . 7 78 8 12 like this. My code is data _null_; file sas2xl; put unquote(bquote("select(R&rowC&col)");PUT unquote(bquote("&value"); run; like wise my code updates the excel,but for some there wont be a value so in that place i need to put zero How can i do this? Help me Thanks

shru · ‎04-01-2012

Hi linlin, I can't post my excel as its in my project linlin, but its the same where i have asked the question. Thanks

shru · ‎03-30-2012

Hi, I need to put zero to the empty cells of an column in excel. My code updates the the column of an excel with the some values but some rows will be empty which dont have values. So how can i put zero's to the rows once i update my excel coulmn with figures. I am using %openexcel; and put statement to put the values.. So how can i do it? Thanks

shru · ‎03-30-2012

Hi Ksharp, One more help, Now i will get the common values from the your code. Can i get the for single single value i.e i need all the values in a seperate macro variable along with the value and if the name and value does not exits then i need to put zero. Its like i will compare both datsets,if values are there then put the values else put zero. Need ASAP Thanks

shru · ‎03-30-2012

Hi ksharp, the value of the macro variable TEST will be :ACU,BDU,HYY The code workrd fine, help me in using this macro,i need to put the values in the excel sheet for the values of macro variable. How can i do this? Thanks

shru · ‎03-29-2012

Hi, My first datset is like, Name ACU BDU POI and my second dataset is like Name value volume ACU 1 23 BDU 4 78 HYY 8 91 QWE 3 75 POI 1 89 PFD 3 56 KHT 1 02 i.e my first dataset is a subset of second, Now i need to match the names from both the datasets and put them in a macro variable using proc sql. How can i achieve this? Need help ASAP Thnaks

shru · ‎03-28-2012

Hi Linlin, The code works fine but sorrry if my question was not clear. But i have a problem as follows my sas dataset is like Name value volume AA 1000 10 BB 2000 20 CC 3000 30 I have A EXCEL sheet with two tabs value and volume.and the excel sheet with value tab and volume tab is like below Jan Feb Mar Apr may jun jul aug AA BB CC DD EE FF GG II So,from the existing sas dataset i need to update the excel's value and volume tab with respective figures, The prob is the excel is not havinh any name to NAME column of sas dataset. Actually i need search for currents months column and put the values from sas dataset And for others row which is having no figures i need to put zero. My excel column for names is fixed but the sas datset may vary every month.So i need to match the names for both and put values,but i dont have any column name in EXCEL for name column. It would be really helpfull if you help in this Thanks Shruthi

shru · ‎03-23-2012

Thanks for your reply linlin, But without importing the sheet from the location can i compare the names in the excel and sas dataset and put values into excel? Thanks

shru · ‎03-23-2012

Hi linlin, I again need an help from you. I have an excel sheet..name book1_test1 as follows. Name jan feb march april may A B C D E F which is alredy fixed. my sas code has an proc sql which fetches data and then the dataset will be tabulated using proc tabulated. as follows: Name value volume A 10 1000 B 5 900 C 8 1067 Now i have used out option in the tabulate to put the tabulated results in a dataset. Now,for some months i may get value for A,B, E and for other month i may get values for B,D only. Now i want to check the names from the sas datset and excel so that if the name A is present in sas and also in excel then that value to be put in the excel else it sholud put zero, I really need it.So help me in this.

shru · ‎03-21-2012

Hi,linlin, Your code works fine,but i neeed the same to do fraom sas to excel using the datset condition. It would be helpfull if you help me in this thanks

shru · ‎03-21-2012

Hi Keith, Its like i already have a datset with some values in rows but i have an excel with more rows, So i need to match the names in the excel and dataset and then put the values to the excel if both the names are same ,and for other rows i need to put as zero. Thanks

Append the data in the excel

unable to get the cumulative value in the datastep

Can three inner joins be used in a proc sql

Exporting a dataset to excel

Re: Insert zero in the column (excel)

Re: Need help in matching the obs from dataset to excel

Insert zero in the column (excel)

compare the two datssets using sql

compare the two datssets using sql

compare the two datssets using sql

Re: Need help in matching the obs from dataset to excel

Re: Need help in matching the obs from dataset to excel

Need help in matching the obs from dataset to excel

Need help in matching the obs from dataset to excel

Re: Need help in matching the obs from dataset to excel