Dear experts,   I have a variable called as follows: %let date=200907;   And a table containing the following variables: AA_200901, AA_200902, AA_200903, AA_200904, B, C, D   In the proc sql; I would like to select: B, C, D and AA_+&date.   Any idea on how to do it? I would like to keep it as simple as possible. Thanks a lot in advance. SH     ... View more

  Dear experts,   I was used to access sql database using the following parameters: LIBNAME NOP ORACLE PATH="klm" SCHEMA=abc  USER=def PASSWORD=ghi ;   Now I got the following data that should allow me to access a DB: DB user/password: abc/def DB Instance: ghi DB machine: srv001 (IP: 22.22.22.222) DB port: 222   Is it enough? I searched a lot but I did not find any string fitting these given parameters. Thanks a lot in advance for your support.   Best regards, SH ... View more

Dear experts, I need to import some files from a Csv. I am using " infile -> informat -> format" But I am struggling with the field address that contains almost everything in term of delimiters, kind of information, number of rows. Any good suggestion to cope with it efficently, i.e. getting all the data in a string for the same variable. Here two examples of the cells that are generating problems: 1. 65, Zenedine Zidane Brügge 7100 BELGIUM   2, Diego Costa Private Limited | z.H. Cesc Fabregas | Dr. BRUG Wenger, Loftus Road Bistocchi 642009 Bangladesh   How to import the data in order to be sure to get the content as one record each? I am using the following delimiter "¦" to avoid confusion but still due to the several rows in the address the csv is not correctly imported. Thank in advance, SH. ... View more

Dear expert,   after some checks I get a data set with the following structure:   data b; input type: $12. variable: $12. variable_min; datalines; date begin 2000 num price 3000 date end 2500 ;run;   How can I show for the same variable (variable_min) in some cases (when type='date') as date and in some cases (when type='num') as numeric?   Thanks in advance, SH. ... View more

Dear experts,   givedn the following two datasets: data a; input country: $12. month_201601: $25. month_201602: $25. month_201603: $25.; datalines; russia 20 30 40 50 belgium 0 0 0 0 germany 10 20 30 40 ;run; data b; input country: $12. sales_201601: $25. sales_201602: $25. sales_201603: $25.; datalines; russia 20 30 40 50 belgium 0 0 0 0 germany 10 20 30 40 ;run;   I need to merge the data into a unique data set. How can I adjust the variable names droppin the prefix, i.e. sales_201601 renamed as 201601 and month201601 as 201601. Afterward I could easily append them. Thanks in advance, SH. ... View more

Dear Expert,   I should do a calculation calculate the difference between two variables: - dataset_201610 - dataset 201609   starting from the point that: &current.=201610 &prev.=201609   How can I flexibly specify the columns using something like: data_set_"&current."-data_set_"&prev."?   Thanks a lot in advance, SH     ... View more

Dear experts, how can should I adjust the following data set?   data time_stamp; input status $ date time; datalines; start '%put %sysfunc(date(),worddate.).' '%put %sysfunc(time(),timeampm.)' ; Thanks, SH ... View more