And moreover,in your Excel file,first 4 rows containing Header columns.So you have to Use Firstobs=6 in your Infile statement. Regards. Sanjeev.K ... View more

Hi Aniket.. Have you tried with bellow link??? http://downloads.energystar.gov/bi/qplist/dehumid_prod_list.xls?b9a2-770c If not try once and let me know. Regards. Sanjeev.K ... View more

HI @Aniket As mentioned by Tomkari, your link might be incorrect. Are you sure it works? I too tried to open your provided link,it is redirecting to http://www.energystar.gov site ,not to the excel file. Please check and let me know. Regards. Sanjeev.K ... View more

Hi @Aniket. Here is the another alternative.. proc http out=clindata url="https://www.dmepdac.com/docs/crosswalk/march_13/2013-03-05_xwalkfinalversion.xls" webUserName="*******" webPassword="***************" method="get" ; run; If the website don't asks any login credentials,then you no need to use   webUserName,webPassword. Not tested above code.but hope that will helps to you. Regards. Sanjeev.K ... View more

Hi @Aniket You Can Use Filename Statement to do that i guess. Here is the small example .. FILENAME myurl URL 'http://www.masil.org/archives/smoking.txt'; DATA js.smoking;    INFILE myurl FIRSTOBS=34;    INPUT state $ cigar bladder lung kidney leukemia area; RUN; Regards. Sanjeev.K ... View more

HI  Karthik "NEW" option is available in Proc Printot procedure,it clears any information that exists in a file and prepares the file to receive the SAS log or procedure output. You can not use that in Filename statement. Use NEW option in Proc Printto procedure as suggested by Data_null_   Syntax: proc printto print='output-file' new; run; Thanks &Regards. Sanjeev.K ... View more

Hi Anil.. Here is the other way to get output. Data final_data_summ; input Name$ product $ unit volume; cards; A1 CC 6 0 A1 PL 2 116650 A1 SL 1 38930 A2 CC 9 0 A2 SL 1 20588 A3 CC 4 0 A4 PL 13 523137 A4 SL 2 90423 A5 CC 2 0 A5 PL 4 176813 A5 SL 1 53988 ; run; proc print; run; proc transpose data = final_data_summ out=final_data_transpose; by name; var unit volume; id product; run; Data unit val; set final_data_transpose; if _name_="unit" then output unit; else output val; run; Data Final(Drop=_name_); merge Unit(rename=(CC=CCUnit PL=PLUnit SL=SLUnit)) Val(Rename=(PL=PLVal SL=SlVal)); by name; run; Regards.. Sanjeev.K ... View more

Hi.. I Always Suggest Solution.. But If you want more tricky Solution try This..:-) 🙂 Data test; input ANLN1 BUKRS ANLKL KANSW01 $9. MENGE; cards; 000002500001 0001 00001258 8300.00-  1.000 000002500002 9600 00001258 20213.40  1.000 ; run; Data My(Rename=(new=KANSW01) Drop=KANSW01); set test; if substr(KANSW01,length(KANSW01),1) eq '-' then new=input(substr(KANSW01,length(KANSW01),1)||substr(KANSW01,1,length(KANSW01)-1),8.2); else new=KANSW01; run; Regards. Sanjeev.K ... View more

Found this one also.. http://www2.sas.com/proceedings/sugi30/249-30.pdf Reagrds. Sanjeev.K ... View more

Yup.. You can also Perform All Types of joins in datastep with IN= options. For more info.. http://www.nesug.org/Proceedings/nesug11/ds/ds03.pdf Regards, Sanjeev.K ... View more