About VISHNU239

VISHNU239 · ‎07-27-2018

Hi, All. I have an issue while exporting proc report to excel using ODS. I am using a macro which has all the names of individual persons and individual excel tabs needs to be created for every unique person in a single excel file. I am using the below code where it is generating only one excel tab for only the last person in the macro . I am giving macro name in the sheet_name option. I want to create individual excel tabs for every person in the macro. please help me. ods excel file="\c\desktop\output\temp.xlsx" options (sheet_interval="none" sheet_name="&Name" embedded_titles="YES");

VISHNU239 · ‎07-12-2018

Hi I have three macros &a , &b and &c &a and &b are character and &c is numeric. I have to convert both &a and &b to numeric and multiply &b with &c. &a I am going to use it for further calculations. all three macro variables include decimal values. Please help me.

VISHNU239 · ‎07-11-2018

Thanks guys. it worked.

VISHNU239 · ‎07-11-2018

a and b will have decimal values too. can you help me the statement for that part too?

VISHNU239 · ‎07-11-2018

Hi, Tom. I changed the code to this way data abc; infile "file path" dsd dlm=',' firstobs=2 missover; length target_percent 8. ; input target_percent :percent. ; run; In the output of sas the percent values are being displayed as .50 instead of 50%. Any other suggestions. Your suggestion worked for calculation part but for the display it is showing as .50 instead of 50%. Thank you.

VISHNU239 · ‎07-11-2018

Hi, I have two macro variables &a and &b. I have to sum these two macro variables and assign it to other macro variable name &c. How do I do that? Please help me.

VISHNU239 · ‎07-01-2018

data abc; infile "file path" dsd dlm=',' firstobs=2 missover; length target_percent percent6.; input target_percent; run; input file has target_percent values as 98%. i need to read 98% into target_percent in sas and it should be displayed as 98% in sas.Thank you.

VISHNU239 · ‎07-01-2018

Hi, i have data in .csv file. i am unable to read percent variables into sas enterprise guide. percent variables values are like 98%,92%. i tried percent6. in length and input statements but still percent values are not being read. i am using infile statement to import the file to sas. please help me.Thanks in advance.

VISHNU239 · ‎06-12-2018

Hi, I need a code to the below attached file scenario. I need to calculate total paid to john and total paid to monty separately by adding rows and in the end I want to calculate total paid to both by adding both sum columns in the proc report. I am using enterprise guide.

VISHNU239 · ‎06-11-2018

yes. I want all the information in a single sheet and using options(sheet_interval='none') after ods excel statement worked for me in enterprise guide.

VISHNU239 · ‎06-11-2018

thanks Cynthia it worked.

VISHNU239 · ‎06-10-2018

How to avoid page breaks in sas proc tabulate?i want all the tables in one page. i am using ODS excel.

VISHNU239 · ‎02-02-2018

yeah got it sir. examples helped me in understanding. what does the symbol || mean and what is its function?

VISHNU239 · ‎02-02-2018

that is what i didnt understood. what has it to do with the count included in the freq?

VISHNU239 · ‎02-02-2018

The following SAS program is submitted: data work.staff; JobCategory = ‘FA’; JobLevel = ‘1’; Jobcategory = Jobcategory || JobLevel; run; Which one of the following is the value of the variable JOBCATEGORY in the output data set? FA FA1 FA 1 ‘‘(missing character value) Answer: A how is it option A?

Online Status	Offline
Date Last Visited	‎08-16-2018 11:12 AM

ODS EXCEL MULTIPLE TABS

macros

Re: sum of macro variables

Re: sum of macro variables

Re: import percent values

sum of macro variables

Re: import percent values

import percent values

PROC REPORT

Re: proc tabulate page break

Re: sum of macro variables

Re: sum of macro variables

Re: sum of macro variables

Re: proc tabulate page break

Re: proc tabulate page break

ODS EXCEL MULTIPLE TABS

macros

Re: sum of macro variables

Re: sum of macro variables

Re: import percent values

sum of macro variables

Re: import percent values

import percent values

PROC REPORT

Re: proc tabulate page break

Re: proc tabulate page break

proc tabulate page break

Re: character variable

Re: proc ttest

character variable