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 Kiwi, I saw it immediately after I posted the question, sorry but still I do not get to the point. I get the following errors: ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement. This is the reason why I asked if the component installed in my SAS version are enough....
... View more
I just runned a proc setinit and this is the result: ---SAS Workspace Server for Local Access is ist enough to access the DB via the parameters above described? Thanks again!
... 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 @Daniel-Santos, nice to know that you agree but I posted what I can. Of course it is a guess, if you do not have a best guess, the problem is for you too complex and you cannot support, feel free to ignore the topic and avoid redundancies. But thanks for the effort.
... View more
Dear experts, I understand that "probably" the file is not properly structured to be a csv but this is what I have, let's put in this way: the file's extensions is .csv @ShmuelI have several variables, e.g. name, surname and addresse is just one of them. In most of the cases the cell where the address is contained is of 3 rows but this is not always he case, sometimes. Would you have a suggestion in case I would have always 3 rows? Maybe it could be already step forward. Output example: if the address as a variable is before the last column which is gender. I would like to get: as variable address: Diego Costa Private Limited | z.H. Cesc Fabregas | Dr. BRUG Wenger, Loftus Road Bistocchi 642009 Bangladesh Gender: "Male" (an not Fabregas) 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 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
so based on your understanding the issue was to find a valid SAS name for a dataset? Thanks for your effort but please avoid to spam the forum answering if you can contribute to solve the issue.
... 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: ¤t.=201610 &prev.=201609 How can I flexibly specify the columns using something like: data_set_"¤t."-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
This site uses cookies and related technologies for site operation, analytics and third-party advertising purposes, as described in our SAS Privacy Statement. You may consent to our use of these technologies, reject non-essential technologies or further manage your preferences. To opt out of SAS making information relating to cookies and similar technologies available to third parties for advertising purposes, select "Required only." To exercise other rights you may have related to cookies, select "Manage cookies."
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
