%let e=""xyz"" ; %put %substr(&e,3,2); when I am executing above programming I am getting error like ERROR: Open code statement recursion detected.     ... View more

data ex1; set table1 table2 table3 table4 ..........tablen; run;   data ex2; merrge table1 table2 table3 table4 ..........tablen; run; In above two steps how many data sets we can write like table1, table2....upto ? I think 256 datasets we can use. Kindly let me know   ... View more

  I have sashelp.class data set like above dataset and how to do group wise analysis in datastep block? first output: how to sex wise sum and insert extra record group wise in dataset(we should do data step block only) for ref:     ... View more

I have one csv file path is 'D:\Parc\file_dump.csv'  and we have to take 2nd row as column names. Note: dont delete first row. ... View more

I have xls file path is 'D:\Parc\file_dump.xls' . In this file I have sheet names so how to read those sheet names and create one dataset like (sheet names are class,car) . and  how to count no.of sheets. For ref: sheet_names 1)class 2)car ... View more

%let a=10 ; %let b=20 ; %let c=30 ; I am creating 3 macro variables a,b,c so with out executing above code how to do like how many macro  variables are present in that code (don't use _user_, sashelp.vmacro)   answer is 3 ... View more

data names ; length company_name $ 50; infile cards dlm='~' ; input company_name $ country $; cards ; lenevo pvt ltd~usa pvt lene~usa harish industries~india institute of harish technology~india bata showroom ltd~usa multi theature of bata's showroom~india run; I have created one data set like above . I have some records like company names so how to identify the  same sound spelling words for example : see first and second record 1--lenevo  2---lene new variable='lene'. for your reference see final dataset output: company_name                         country        match_spelling lenevo pvt ltd                                usa                lene pvt lene                                        usa                 lene harish industries                          india               harish institute of harish technology      india                harish bata showroom ltd                        usa                bata multi theature of bata's showroom  india             bata ... View more

id~class~section~mark~stagen~seq~test 101~class1~sectiona~~4~1~ 101~class1~sectiona~fi~3~2~fi 101~class1~sectiona~~9~3~fi 101~class1~sectiona~~9~4~fi 101~class1~sectiona~~9~5~fi 101~class1~sectiona~last~6~6~last 101~class1~sectiona~~2~7~last 101~class1~sectiona~~3~8~last 101~class1~sectiona~fi~9~9~fi 101~class1~sectiona~~2~10~fi 101~class1~sectiona~~3~11~fi 101~class1~sectiona~~9~12~fi 101~class1~sectiona~last~2~13~last 101~class1~sectiona~~9~14~last Note: delimiter is '~' Hi I have one dataset like above and I have to create sequence number test wise  By variables are id class section seq. How to create one variable (repeating) output should be below  for your ref: id~class~section~mark~stagen~seq~test_repeating 101~class1~sectiona~~4~1~ 101~class1~sectiona~fi~3~2~fi~1 101~class1~sectiona~~9~3~fi~2 101~class1~sectiona~~9~4~fi~3 101~class1~sectiona~~9~5~fi~4 101~class1~sectiona~last~6~6~last~1 101~class1~sectiona~~2~7~last~ 101~class1~sectiona~~3~8~last~ 101~class1~sectiona~fi~9~9~fi~1 101~class1~sectiona~~2~10~fi~2 101~class1~sectiona~~3~11~fi~3 101~class1~sectiona~~9~12~fi~4 101~class1~sectiona~last~2~13~last~1 101~class1~sectiona~~9~14~last~ only test='fi' values should go with sequence and test='last' only one number like above dataset ... View more