This question was asked in one of the interview that i have faced. They asked how can i clear and turnoff the log messages in SAS? I was able to answer how to clear but not the second one.
... View more
Hi , Please see the whole post , i have mentioned everything then and there itself which includes the csv file that i need to import, error after i use infile as well as the code that i have tried. Thanks Rohini
... View more
Hi Guys. I want to import the CSV file through infile but i am getting below mentioned alert while doing so . Please help out in solving the error. FOllowing is the CSV file i need to import: After using infile getting following error Code Tested: data a; infile "C:\documets\2.csv" dlm="" dsd firstobs=2; input cc dob enroll; informat dob mmddyy10. ; informat enroll date9.; format dob mmddyy10.; format enroll date9.; run; Please help in rectifyin the error.
... View more
Hi , Below mentioned is the data from which i want to find the customer details who only uses gold card. I found the customers who uses whole three cards by using first. and last. concept. Now i am not able to put the logic how to find the 1)customers who only uses gold card. 2) customers who uses platinum but not gold 3)customers who uses titanium but not gold Please help me out in solving the questions?
... View more
please help me out in solving below mentioned error. How can rectify this error. Even i tried ny mentioning RECFM=v and LRECL=256 in the statment.Still didn't work out. Please help out.
... View more
how can i find the credit card numbers which range from A1-A100 for all the 3 types Gold, Platinum and Titanium, if there is any card holder with any other value, i need to create a dataset and excel file “Invalid_Cards”. Remove these invalid customers from the list of Individual cards list.
... View more
I want o import file from second row but it is throwing out error. Below mentioned is the statement that i have executed.Please find the attachement for error formed. Statement Executed: proc import datafile="C:\Documents\execrise2\Database.xls" out= work.a DBMS=EXCEL REPLACE; SHEET="Gold$"; GETNAMES=NO; DATAROW=2; RUN;
... View more
