Hello everyone,   I need a help. I am trying to run an optmodel procedure but i am having SAS university edition which doeesn't supports SAS optmodel, i think. I have to run the below code for the dataset attached. Can anyone help me out?   proc optmodel; var hp, cyl ,mpg; min price = -8864.63 - 0.14398hp +1150.71mpg + 1215.28cyl; con -0.00997 - 0.1005mpg + 0.3351cyl - 0.0148hp + 0.000081price = 1; solve; print hp cyl mpg; quit; run;         ... View more

I am trying to run the below code but the values in variable (binary_sales) are missing. Please refer the attached screenshot for stat_globalsales dataset.       data binary_globalsale; set stat_globalsale; if Sales = '-Average' then binary_Sales = 0; if Sales = '+Average' then binary_Sales = 1; run; proc print data=binary_globalsale; run; ... View more

I am importing the attached dataset using the INFILE statement. But the 'quantity' 'sales' and 'profit' variables have missing values against them, Please have a look.   data inf_globalsale; infile'/folders/myfolders/global_sale.csv' LRECL=60000 DLM=',' FIRSTOBS=2; informat Order_ID$32. Order_Date ddmmyy10. Ship_Date ddmmyy10. Customer_ID$32. Segment$32. Country$32. Category$32. Sales dollar10.2; format Order_Date ddmmyy10. Ship_Date ddmmyy10. Sales dollar10.2; input Order_ID$ Order_Date Ship_Date Customer_ID$ Segment$ City$ State$ Country$ Category$ Sales Quantity Discount Profit; run; proc print data=inf_globalsale; run; ... View more

I am trying to write the below code, But the date values are missing in the output Dataset. Please Help     data global_sales; informat Order_ID$32. Order_Date ddmmyyyy10. Ship_Date ddmmyyyy10. Customer_ID$32. Country$32. Category$32.;  input Order_ID$ Order_Date Ship_Date Customer_ID$ Segment$ City$ State$ Country$ Category$ Sales Quantity Discount Profit; format Order_Date date10. Ship_Date date10. Sales dollar7.2 Profit dollar6.2; cards; CA_2014_AB10015140_41954 11-11-2014 13-11-2014 AB_100151402 Consumer Oklahoma Oklahoma United_States Technology 221.98 2 0 62.15 ; run; ... View more

Hi all,   I have analysed the correlation between two variables: hp and cyl and  i'm writing a code for cluster analysis for the same varibles but ending up with error, need help. The code is: proc corr data=rank_mtcars out=cluster_mtcars; /*Here rank_mtcars is a predefined dataset*/ var hp cyl;run; proc cluster data= cluster_mtcars method=centroid rmsstd outtree=cluster_mtcars; var cyl hp;run;   ERROR: TYPE=ACE, CORR, COV, EST, FACTOR, SSCP, UCORR, or UCOV data sets must be converted to TYPE=DISTANCE. Note that CLUSTER ignores the _NAME_ and _TYPE_ variables, if any. ... View more

Here Date is a set of different dates defined in d_mtcars dataset and I am trying to find the number of days between Date and last_date. But, the values in the days column are missing as output. Please help.   data date_mtcars; set character_mtcars(drop=prefix); set d_mtcars; last_date='29july2017'; days= intck ('day',Date,last_date); run; proc print data=date_mtcars; run; ... View more