I have column cust has character type and I want to change the type to numeric of the same variable. data one; set wes;  cust = input ( cust,best8.) ; run;   But still, in the output, I am seeing the type of cust as a character which I am expecting to be numeric.    ... View more

Hi ,   I need help creating one dataset which should contain two variables  B_date = today's date and start time 12:00:00 am  E_date = today's date and end time 11:59:59 pm    Thanks in advance. ... View more

I have I am working on a main frame program for the first time.When it says  TABLE FILE CARS1 PRINT CYLINDERS COUNTRY PRICE MAKE MODEL WHERE PAL = 'DAV' END  FIN   as I don't have PAL variable in the actual dataset and where PAL = 'DAV' statement says put PAL = 'DAV' or it works as a regular where filter in base SAS or it main frame code work differently?   Thanks KAJAL ... View more

Hi Team,   I am working on a task and want to create a table in oracle data base.Is it possible for me to use explicit SQL pass through query and create table or I need to create table in oracle using oracle commands and can only access(like insert data or update table using SAS) it using SAS?  Thanks Kajal   ... View more

Hi ,   I need help reading multiple excel files at one location and create multiple tables reading all excel files.Please if you can provide me the code   Thanks In Advance, Kajal ... View more

proc sql; select name into : table from country.DETAIL where ID = 34 and CD = "abc" ; quit;   proc sql; select name into : table from country.DETAIL where ID = &first_id. and CD = "abc" ; quit;   First query is running fine and second throwing error: ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. can you please help why hard coding macro variable value is not giving any error but macro variable is giving error ... View more

I am trying to read SAS catalog. I have printed out all the contents of the catalog but now I want to see what information in stored in each content .   Please help and provide code if possible   Kajal ... View more

Hi,   I am using Proc compare and want to create a table which has all the diff values only for column  eg: we have a table_1 with columns: A,B,C,D,E table_2 with columns : A,B,C,D,E output_table should have A,B,C,D,E (comparing table_1 and table_2 only for variable B and D)    Hope this helps   Thanks Kajal   ... View more