About shru

shru · ‎03-21-2012

Its like every month i need to add one column in the speard sheet like this month i will fill values for last month with the existiin datset. In spread sheet there are 20 rows but my datset from the sql will fetch the values for some of them only depending on the values. My program will tabulate a data which i need to copy paste to that excel So,i wanted to do automation for that,so that the column will fetch data from the existin datset,if the name are matching then it will put the values there and for other rows it will put zero. help me how can i do this? Thanks

shru · ‎03-21-2012

Hi Hai.kuo and Ksharp It worked fine Thankss

shru · ‎03-21-2012

I need to fetch one value from the dataset with respect to column name obs and f4. So that when i run the code i only get the value 8 as i mentioned. Thanks

shru · ‎03-21-2012

Hi, My datset is as follows obs f1 f2 f3 f4 1 1 2 3 4 2 3 4 5 6 3 7 6 6 8 Now, with respect to condition like if obs =3 and f4=8 i need to fetch the value 8. how can i achieve this?

shru · ‎03-21-2012

Your code is helpfull,but as i mentioned i need to output the values in the excel. I have a proc tabulate with values,So in excel i will search for the month column i require and update the values which is present and for others i will put zero. It would be helpfull,if you provide me the code from where i can update the values from sas to EXCEL as how you have provided the same in the datset itself Help me ASAP

shru · ‎03-20-2012

Hi, I have an excel like with sheet name='sheet1' name feb march april may VA 1 2 3 BA 3 6 9 WA 7 5 2 Ma 4 8 8 Now i have a dataset called shru like below Name amount Va 2 Ma 6 where i need to put these values in the excel sheet for Va and Ma and for others i need to put zero So,any one help me with this as to how to achieve this? I need it ASAP Thanks

shru · ‎03-20-2012

Hi, I need to read the row number eg:67 and assign it to another macro variable. So when i run the daily,it should get updated every day. I need to assign row number only. Thanks

shru · ‎03-20-2012

Hi, I have a dataset imported from excel.Now i need to read a row number say for ex:67 and assign it to macro variable. How can i do this? help me in this Thanks

shru · ‎03-19-2012

I imported the excel file to sas and now i have a sas dataset. example: data today tom dayafter d 1 2 3 e 4 7 9 Now i need to read the row 'd' and assign it to one macro so that when i run today it will upadate the row. This updation i need to do in excel.. Thanks

shru · ‎03-19-2012

Hi, I am able to import the excel sheet successfully. But i need to read an one row number for example:-23 and assign it to one macro,so that when i run everyday it should update for the current day. How can i achieve this? Thanks

shru · ‎03-18-2012

o, its like the excel format is different i guess,so when i try to import the excel with correct sheet name,its showing error as FILE_IMEX error. I tried importing it using import wizard but still the same error exists, I tried giving the rangein the proc import like sheet="sheet1A1:A10$"n but its not working It would be helpfull,if you guide me with some other way of giving sheet name. Thanks

shru · ‎03-18-2012

I need to upadate excel cells by sas

shru · ‎03-17-2012

Hi, I need to import the excel with three woroksheets and and in the inported worksheet i need to make one cell as dynamic so when i run the code daily automatically the cell for that day should be filled with data. and aslo, I tried importing with proc import ,but i get a error telling file_imex_error. so anyone help me in this please? Thanks

shru · ‎03-15-2012

Hi, I have a excel sheet with four worksheets. How can i achieve importing this using proc import I tried giving as 'sheet $'n but i did not work and also i need to make one cell in the imported excel sheet as dynamic,so that when i run the macro the value needs to get updated Help me in this..

shru · ‎03-15-2012

Thanks It workrd fine

Online Status	Offline
Date Last Visited	‎07-30-2017 02:04 PM

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

Need help in matching the obs from dataset to excel

Need to fetch a single value from the existing dataset

Need to fetch a single value from the existing dataset

Need to fetch a single value from the existing dataset

Need help in matching the obs from dataset to excel

Need help in matching the obs from dataset to excel

Need to read a row number from the datset.

Need to read a row number from the datset.

import excel with three worksheets

import excel with three worksheets

import excel with three worksheets

import excel with three worksheets

import excel with three worksheets

import excel with three worksheets using proc import

Re: read the address and write it in different column