Hello I want to find first location of character in string. Lets say I have the following data. Vector='0,0,5,11,9,10' I want to find the first location (after comma) where the number is different than 0. In this case the answer is  3  because the third argument in vector has value different than 0.   How can I calculate it in SAS  please?       thanks Ronein ... View more

Hello I have the following question I define the following parameter of dates (YYMM).   %let vector=1708+1707+1706+1612;   I want to create base on vector parameter another parameter called tarr  that includes also 4 arguments with  + symbol between them. Each argument is created by subscribing 12 months  and take end of month.   The wanted parameter is  '31AUG2016'd+'31JUL2016'd+'30JUN2016'd+31DEC2015'd     Can anyone help to do it please?       Thanks   ... View more

HELLO I am using proc report. The problem is that in the output table (created from proc report) the order of the rows is not same order as in proc format. I want to have same order or rows like in proc format: '0' '2--5' 6--7' '8--10' '11' '12' But the order of rows I get is: '0' '11' '12' '2--5' '6--7' '8--10'         Here is the code:       proc format; value gkFMT 0='0' 2,3,4,5 ='2--5' 6,7 ='6--7' 8,9,10 ='8--10' 11='11' 12='12' ; Run;     proc report data=aaa ; column    groupk    MOD     ob_MLS ; define groupk / group format=gkFMT.            order=formatted         'groupk' ; define MOD / group 'Model' ; define ob_MLS / analysis sum format=comma10. 'Ob'; run;     ... View more

Hello Please see this code. I want to do some changes to output and don;t know how to do it in proc report code. I want to add global total for following  grades:a.0,b.1-6  ,c.7-10,d.11 (without grade e.12)         Data TBl; INPUT grade $ Model $ Obligo; Cards; a.0           a   10 a.0           b   20 b.1-6       a   30 c.7-10     a   40 d.11        a   50 d.11        b   60 e.12        a   70 e.12        b   80 ; Run; libname proclib 'SAS-library'; options nodate pageno=1 linesize=64 pagesize=60 fmtsearch=(proclib); proc report data=TBl nowd headline headskip; column grade Model Obligo ; define grade / group 'Grade'; define Model / group 'Model'; define Obligo / analysis sum format=comma10. 'Ob'; /*total after each groupkCat*/ break after grade / ol summarize suppress skip; /*global total*/ rbreak after / summarize; compute after; type = 'Total'; endcomp; run; ... View more

Hello I am trying to create million format. Please look at this example proc format; picture million (round fuzz=0) 0 -< 50000 = '00.0' (prefix='' mult=0.0) 50000 -< 1000000 = '00.0' (prefix='' mult=0.00001) 1000000 -< 1000000000='0000.0' (prefix='' mult=.00001); run; data tbl1 ; x = 1200000; y = 230700000; z=1000; format _all_ million. ; run; title; proc print noobs;run;     In the print we can see that value of z is null  but we need to see value of 0.1. What is the siolution and why did it happen?     One more question: I saw in internet using statment :    put (_all_)(=million.); What is it doing ?     thanks Ron     ... View more

Hello I have to following issue. I have data that includes few rows for each customer. data aaa; infile cards; input CustomerID  group  $; cards; 1 a 1 c 2 b 2 a 2 c 3 a ; run;   I want to create a new data set that contain 1 row for each customer with a calculated string field called: CustomerGroups  that concatenate all groups that a customer belong to CustomerID   CustomerGroups  1            a_c 2            a_b_c 3            a Please see that the concatenate of the groups should be from low to high. For example customer 2 belongs to groups a  b c so the new field should be a_b_c ... View more

Hello My task at work is to import multiple Excel files into SAS . Each excel file that I import will be a SAS data set. The Excel files are a daily files that started from 01012017(01Jan2017) until 31122017(31Dec2017). I crrated a vector of dates from 01012017  until 31122017  and run a macro to import the excel files. The problem is that there are dates that there is no excel file and then I get an error while I run the import Macro. What do you offer to do? Is there a way to tell sas that if it dosen't find the excel file then don't send an error and just create an empty file? Is there a way to tell SAS  to import excel files only for existing dates?     thanks Ron ... View more