hi, can i  use namerow,getnames,startrow and sheet within proc import  when trying to import a  CSV file? Getting errors  when trying to  import.   Anyone pls? Thanks, ... View more

hi guys, how do i get the first and last days of let's say last month or June. What would be the code/query to do that? Thanks, Tal ... View more

hello i have 4 tables and i need to join them. The 1st table has about 1M records and the other 3 about 20M each but i only need all the records from the 1st with all the coresponding ones  from the  other 3 tables which means left  join on the 1st table would do the job,right? But how do i do left join with more then   2  tables? ... View more

tryiing to conver  a num var (id) to char by writing this step: data new; set old (rename=(id=id1)); id=put(id1,2.); drop id1; run; and  i am getting asterix in the column of id. Does anyone know  why? ... View more

i have table of  let's say 234,567 records (2 variables) and need to  randomly select 5% of each group (only 2 groups,A and B) and assign those selected  records a  variable new='randomly selected'; I like to keep the selected records within the same dataset as the non selected ones so the resulting dataset should be like : id   group  new -------------- 100  A     randomly selected 101  A 102  B 103 A     randomly selected 104 B ...... i know how to do it in two steps but i was wondering  if this can be done  in one  step? Thanks, ... View more

if i am  to check whether var1 has any of the values '010','011','012',....'019' besides listing  all thes values inside the brackets is there another more efficient  way(shorter way)? I know if var1  was numeric then i could simply  have  "if var1 in (10:19)"  but would the be  the shortcut for char variables. Anyone please? ... View more