Dear Viveklanka Inbuilt comma format give you output like 111,111,111.00, while Indian currency comma format is like 11,11,11,111.00 . Thanks
... View more
Tried doing picture format on numeric values which displays value like 11,11,11,111.00 . But Picture format will convert numeric values in categories in VA.
... View more
I have created picture format using below program proc format ; picture amt1 low- high ='00,00,00,00,00,009.99'; run; proc format ; picture amt low- high ='00,00,00,00,00,000.00'; run; Am I missing something here?? Thanks Pallav
... View more
Hello All, I have been working on SAS VA for some time and stuck in couple of tasks. 1) I need numeric values display in particular format of india (99,99,99,99,999.00) which is not available in sas by default. I created user define picture format and applied on data to display values in that form and also place format in configuration directory. Problem is : in SAS VA my sale_amt value on which format is applied is converted in category which i can not change to measure. Because of this I can not create cross tabulation having sale_amt as measure. Any solutions? 2) I have created user define format on numeric data to convert it in category. I want sorting to be done in VA according to unformatted value. I was able to do it on SAS VA. But in Mobile BI sorting order is changed. so report on VA is good but on ipad it is having different sorting order (according to formated value) Any solution for this?? 3) In cross tabulation :-- in Column definition , I have used one variable called prod_category. Some of the value in prod category are more than 30 characters. so when viewing in IPAD is troublesome as on row level i have 3 level hierarchy. Is there any option to wrap column name on cross tabulation?? which can be viewed proper in ipad. Appreciate your answers. Thanks
... View more
This might be useful proc sort data = test; by id visit; run; data new; set test; by id visit; if first.visit then flag=0; flag +1; Run; proc print; run;
... View more
May be this can be useful for your task... Its a bit complicated but can be used as a macro application. Assuming your single folder have all program that you want to call using %include.... Here is the program Note: This macro take the full name of all file in a folder ending with .sas . Create a series of macro variable with file name . Resolve the value of each SAS file in %include statement using %do loop in macro. %macro test(dir=); filename filelist pipe "dir /b /s &dir\*.sas"; data _null_; infile filelist truncover end=last; input filename $100.; call symputx('mac1'||left(_n_) , strip(filename)); if last then call symputx('nobs' , _n_); run; %do i =1 %to &nobs; %include "&&mac&i"; %end; %mend test; Hope it will help..... %test(dir=\\133.3.3.3\a\a\DataPre\Macro)
... View more
If you want to have average of last three visit of each subject then following long but simple code might help. DATA TEST; INPUT SUBJECT $ VISIT; DATALINES; E101 10 E101 10 E101 20 E101 30 E102 10 E102 20 E102 30 E103 10 E103 10 E103 20 E103 20 E103 40 E103 40 E103 50 ; RUN; proc sort data = test; by subject; Run; data new look; set test; by subject; if first.subject then flag=0; flag +1; output new; if last.subject; output look; Run; data final(drop = flag flag2); merge look(rename= (flag = flag2)) new; by subject; if flag2-flag >2 then delete; Run; proc print data = final; Run; proc sql; create table final1 as select subject, avg(visit) as avg_visit from final group by subject; quit; proc print data= final1; Run;
... View more
Do proc contents for both datasets and find out which variable has a numeric value for Donar_id. Convert that variable in to charactor using PUT function. specify the variable length same as the second dataset Donar_ID variable.
... View more
data class; input rollno studentname $ subject $ mark division $; datalines; 1 A English 60 1 2 B English 80 1 4 D English 40 2 5 E English 80 1 6 F English 10 FAIL 1 A Science 70 1 2 B Science 30 3 3 C Science 50 2 4 D Science 40 2 5 E Science 40 2 6 F Science 50 2 1 A Math 70 1 2 B Math 80 1 3 C Math 90 1 4 D Math 50 2 5 E Math 50 2 1 A History 60 1 2 B History 80 1 3 C History 30 3 5 E History 80 1 6 F History 10 FAIL ; Run; %macro student(Name); data student_&name; SET class; where upcase(studentname)=upcase("&name"); Run; proc print data = student_&name; rUN; %mend; %student(e);
... View more
Try this ods pdf file = 'test.pdf'; ods escapechar = '^'; * Your image has to be of proper size; * you can also make logo left or right justify; title "^S={preimage='C:\Users\sas.jpg'}"; proc print data = sashelp.class; run; ods pdf close;
... View more
Try this... ods pdf file = 'test.pdf'; ods escapechar = '^'; * Your image has to be of proper size; * you can also make logo left or right justify; title "^S={preimage='C:\Users\sas.jpg'}"; proc print data = sashelp.class; run; ods pdf close;
... View more
