About Imroze

Imroze · ‎01-19-2017

Hi My requirement is to print percentage9.1 format in excel . If the data has 0 in decimal point then that should be ignored. note: I have tried converting to character as well but did not work Forexample: If I am printing x variable with value as 99.0% then it should be printing 99% in excel and if it has a value of 99.1% then it should print the same. What I have tried 1.style = {tagattr='type:String'}; 2.type:@ 3.type:@\% Thank you

Imroze · ‎01-01-2016

Hi Babloo, the enclosed one is a parameter to the macro. Example: If you want to pass some value to the macro then you can pass the variable value in it for each observation. if you have a dataset with name as the variable name (4 names) then all four times it will pass and call the calling macro. data test; input name $; datalines; kumar akash vinay babloo ; %macro printmacro(name); %put These are very good guys : &name.; %mend; data _null_; set test; call execute('%test('||name||'); run; Here the print macro will be called 4 times (as many observations as test dataset has) and prints the output to the log. Hope answered the question.

Imroze · ‎01-01-2016

yup this is what I was looking for tom. thanks a lot ...

Imroze · ‎12-31-2015

Yes I have a similar sort of text file text file 1: 001DATA... 002DATA... RSSDATA... 001DATA... 002DATA... text file 2: 001DATA... 002DATA... 001DATA... 002DATA... Here as per the data if I dont find the value of a variable to be RSS then dont need to read the text file.

Imroze · ‎12-31-2015

Thanks tom, Its the same issue which I posted . I had some logic running and was not working in between to solve reading text file.

Imroze · ‎12-31-2015

want to add few more points 1. I thought to create a flag (retain varialbe) and continue reading the text file. 2. text file reading has many conditions and want to improve performance. if there is any other solution to read a text file (optimized way, as it got 100's of condtions in it)

Imroze · ‎12-31-2015

Thank you for the replies. well I have a confusion of how call execute works. My issue is to restrict the reading of text file based on condtion (so I created a macro and a sample example). For example: I have to read a text file filename in "c:/temp.txt"; data test; infile in truncover; input x $500.; if x > 'some value then only i need to create dataset or else discard reading the file'; /*Here i might need previous observations if this condition is true */ /*Value of x may come in nth row */ run; data test; infile in truncover;

Imroze · ‎12-31-2015

did not resolve my issue, if possible could you please try the sample code.

Imroze · ‎12-31-2015

still u pasted the log, what I want is a sample code which you are using. Well as per the log you need to provide the infile statement with dlm option . Ex: data test; infile datacards dlm="." dsd truncover; input x y z; datacards; 123.123.123 ; hope answered the question.

Imroze · ‎12-31-2015

If you provide more data then it will be helpful to answer. say give the sample code (how you are using and where--scenario).

Imroze · ‎12-31-2015

HI I have two different datasets where I want to identify the matching values . For example in the below code I have used both similar datasets (in real both are different). Here I would like to get local as the macro variable but uanble to graple the value with in one call. could any one please help me how to resolve macro variable by calling a macro from datastep. %global temp; %let temp = %str(std='yes'); %macro test(name); data _null_; set sashelp.class; if name=&name then do; call symput("temp",%str(local='yes')); stop; end; %mend; data xyz; set sashelp.class; call execute('%test('||name||')'); &temp; run;

Imroze · ‎01-21-2015

Dear Michelle, Thank You very much for the reply. I will move my question.. I have tried the add link option, but it will not interact the data which is filtered . Thank You Imroze

Imroze · ‎01-20-2015

Dear, Requirement : Need to link the report in the same tab when highlighted. (It is possible to link a report to another tab or report , but requesting to link in the same tab) Ex: I am creating a VA report which has many tabs x1,x2,x3..... Say, In X1 tab STEP1: There are prompt container to filter the data in list table1 (with columns 1,2,3,4). STEP2: If I click the column value (say 2) then the values for column 2 should filter and display table 2 (m,n,o) like inner join . STEP3: Hide the table if not selected. Thank You Imroze

Imroze · ‎08-25-2014

HI Cynthia , for question1 yes it is monthly bills generated based on customer request dates. I got the answer . Thank you. For question 2 . I have two databases where in 1 st one will have called or dialled numbers, the 2nd database has defined telephone numbers such as numbers starting series with 9900 to 9999 are local 8800 to 8899 are local or std . Thank you

Imroze · ‎08-25-2014

3 1HI I am creating a bill where I have to use row_start, row_end, row_span, Column_span and other options. (one observation with multiple columns--billnumber,billdate,billperiod,storeid,.......) My Question) Is there any possibility to achieve this by proc report (as procs are much faster than data step). Ex bill store Name and Address billnumber billdate xyz xyz corporatio, road no 10,.... 101 12132131 customer id bill period 123 123s1f32- 1213213 Question 2 ) Is there any possibility to create parse (prxparse) for local numbers , std numbers , isd numbers as the data given was huge millions of numbers... and is taking time to search for the numbers. Thank You

Online Status	Offline
Date Last Visited	‎01-19-2017 09:32 AM

Maintaining formats in ods excel "percent"

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: Error Message

Re: Error Message

Re: how to resolve macro variable by calling a macro from datastep.

Re: ODS ExcelXP SAS Generate Title

Re: Efficient coding

Re: Efficient coding

Re: pdf header issue.

Re: intck('hours') how to exclude certain time and day?

Maintaining formats in ods excel "percent"

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: how to resolve macro variable by calling a macro from datastep.

Re: Error Message

Re: Error Message

how to resolve macro variable by calling a macro from datastep.

Re: SAS VA report creation

SAS VA report creation

Re: Using proc report instead of rwi (data step)

Using proc report instead of rwi (data step)