Hi.. I have arithmetic expressions in a character field in a dataset as below... example: exp 701*10 ** 6 460*10 ** 6 6.22 * 10**-4 2*10**-3 Am unable to evaluate the expressions and keep them in a numeric variable..Can anyone please help me in this regard.. Thanks ... View more

Hi,     Its a very basic condition in where clause.. data person;    input name $ dept;    datalines; John 1 Mary 1 Matt 2 Rob  3 Mary 3 ; run; data filter; set person; where dept ^=1 and name ^= "John"; run; If I run the above datastep, why is it excluding all rows whose department is 1 or name is John. It should exclude only if dept is 1 and name is John. Thanks in advance.. ... View more

Hi..    I have a csv file with a line break in one of the columns enclosed by ". Am havign trouble importing them to SAS using proc import.Can anyone please help me on this..? here is an example.. test.csv name  address abc,"aaa, China" def,"ccc,USA" If you observe first row has a new line character in address column and proc import treats it differently.. Am using the below code for import.. proc import datafile = "C:\test.csv" out = test dbms = csv replace;  run; Thanks in advance ... View more

Hi All,   Is there any way to know the last page number and line number of that page where the last "proc print" statement written to the rtf file in ODS RTF. For example:   ODS RTF file = "text.rtf" ;                     proc print data=one;           run;           proc print date=two;           run; /* I want to know the page number and line number where the above print statement ended... */                       proc print date=three;           run;           ODS CLOSE; Thanks in advance.  ... View more

Hi All,    Is there any option in proc print to print the serial number instead of observation number..? for example : proc print with obs option is resulting in below output..           Obs    Name       Sex    Age    Height    Weight              1    Alfred      M      14     69.0      112.5              5    Henry       M      14     63.5      102.5              6    James       M      12     57.3       83.0              9    Jeffrey     M      13     62.5       84.0 but I want it to print                Obs    Name       Sex    Age    Height    Weight              1    Alfred      M      14     69.0      112.5              2   Henry       M      14     63.5      102.5              3   James       M      12     57.3       83.0              4    Jeffrey     M      13     62.5       84.0 Thanks in advance.. ... View more