sir thanks for your solution. sir l will explain in a clear manner.i have an excel file with some data..and my SAS Environment have permissions only for CSV files to import and export.so when i want to get the from excel to sas data set firstly i convert that excel into .csv and that file looked as excel.. so that's why i am asking multiple data sets into csv. thank you
... View more
thanks for the Solution. and wrote a code in data step like this Proc sort Data =Sam out=Sam_srt ; By Name ; Run; Data Sam_1 ; Set Sam_srt; By Name ; If First.name ; Run; Sir i want output based on Name only.and can you write the code for above data step into Proc SQL.
... View more
Dear All I have multiple(More than 10)date sets in Work Library and i want them into Single .CSV file With Multiple Sheets(each data set in different sheets on a Single .Csv File). Can Anyone Help Me with Proper Code For above problem. Thank you in Advance Regards Nehemiah
... View more
Dear All bellow is the code i run : Data SAm; input Name $ Item $ Value ; cards; nehemiah ball 20 nehemiah bat 100 nehemiah glouse 50 naari battary 14 naari remote 40 naari cover 120 ; Run; I want output like this output: naari battary 14 nehemiah ball 20 please help me with the code Proc Sql
... View more
Hi All Please find the attached pdf output generated by SAS Studio version 3.6 and the code used is given below. data one; set sashelp.cars (keep= Model Type Origin); run; ods pdf file= "xxx/test.pdf" ; proc print data=one; run; ods pdf close; the problem i faced was the pdf generated was not searchable .so please give a solution to this problem. thanks in advance. Regards, Nehemiah
... View more