cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
233
‎08-04-2018
  • 14 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: how to create variable in sql?

by Calcite | Level 5 in SAS Programming
‎08-04-2018 11:05 PM
‎08-04-2018 11:05 PM
Thank you so much! I am not very familiar with SQL and I am looking for notes of sub query but still stuck on the problem. Really appreciate your help! ... View more

Re: how to create variable in sql?

by Calcite | Level 5 in SAS Programming
‎08-04-2018 09:57 PM
‎08-04-2018 09:57 PM
My homework requires me to do that. I think I didn't make enough clarification. In the data step, a if subset statement is using to create a variable called total_sales (seems like accumulate the value of a original variable called retail_price) And now I have to code them using SQL, so I was wondering is there anyway I could do in SQL to create a variable and assign the accumulation of the values from the existed variable?   ... View more

how to create variable in sql?

by Calcite | Level 5 in SAS Programming
‎08-04-2018 09:18 PM
‎08-04-2018 09:18 PM
data discountRet_kinson2 discountCat_kinson2 discountInt_kinson2; set work.orders; by Customer_ID Order_Type; if first.Order_Type then Total_Sales=0; Total_Sales+Total_Retail_Price; if last.Order_Type and Total_Sales >= 200 then do; select (Order_Type); when (1) output discountRet_kinson2; when (2) output discountCat_kinson2; when (3) output discountInt_kinson2; end; end; I have the above code and I have to express them using SQL instead of data step. I have try a few lines of code, but I don't know how to express the if subset statement in SQL. Is there any similar procedure in SQL that I ignored?   my code: proc sql; create table work.discountRet_sliu116 work.discountCat_sliu116 work.discountInt_sliu116 as select Customer_ID, Customer_Name, Total_Sales from hw7.orders2018 ... View more

Re: Questions for merging datasets

by Calcite | Level 5 in SAS Studio
‎08-04-2018 05:40 AM
‎08-04-2018 05:40 AM
I have successfully add the name of dataset beside the variable. Thank you so much! ... View more

Questions for merging datasets

by Calcite | Level 5 in SAS Studio
‎08-04-2018 04:54 AM
‎08-04-2018 04:54 AM
Hi, I have two datasets, one is about sale of beer and another is about sale of snacks. The two datasets have the same variables but different values, and below are part of data from beer data set.   IRI_KEY WEEK SY GE VEND ITEM UNITS DOLLARS F D PR 664497 1114 0 1 41633 2154 3 2.97 NONE 0 0 664497 1114 0 2 41633 145 6 13.14 NONE 0 0 664497 1114 0 1 41633 2119 3 2.97 NONE 0 0 664497 1114 0 2 41633 135 3 6.57 NONE 0 0 664497 1114 0 1 41633 2140 1 0.99 NONE 0 0 664497 1114 0 1 41633 2155 2 1.98 NONE 0 0 664497 1114 0 2 41633 150 1 0.69 NONE 0 0 664497 1114 0 2 41633 115 3 2.07 NONE 0 0 664497 1114 0 4 41633 136 6 13.14 NONE 0 0 664497 1114 0 1 28400 992 3 2.97 NONE 0 0 664497 1114 0 2 28400 1459 2 0.50 NONE 0 0 664497 1114 0 1 28400 981 3 2.97 NONE 0 0 664497 1114 0 1 28400 1180 2 5.98 NONE 0 0 664497 1114 0 4 28400 988 1 0.99 NONE 0 0   I'm a newbie and not quite familiar with many procedures. I was wondering is there a procedure  I could use to let me point out which part of data is from beer and which part of data is from snack after I merge the two datasets? Could I create a categorical variable and maybe use some procedures to point out each row represents the sale from beer or snack? Any suggestions will be really appreciate! ... View more

Re: meet problems for reading in data

by Calcite | Level 5 in SAS Studio
‎08-04-2018 12:21 AM
‎08-04-2018 12:21 AM
It works! Thank you! ... View more

Re: meet problems for reading in data

by Calcite | Level 5 in SAS Studio
‎08-04-2018 12:16 AM
‎08-04-2018 12:16 AM
Thank you! I try on the blank and it works. I have another concern that all the dataset starts on the second row, and the first row appears dot. Is there anything I could do to fix that?   ... View more

Re: meet problems for reading in data

by Calcite | Level 5 in SAS Studio
‎08-03-2018 11:47 PM
‎08-03-2018 11:47 PM
Sorry I'm newbie, still struggling for the basic. I have paste the data below, will that be okay?   IRI_KEY WEEK SY GE VEND ITEM UNITS DOLLARS F D PR 664497 1114 0 2 33200 19180 1 2.73 NONE 0 0 664497 1114 0 2 22600 2062 2 6.38 NONE 0 0 664497 1114 0 3 22200 3 1 2.95 NONE 0 0 664497 1114 0 1 22200 500 1 1.79 NONE 0 0 664497 1114 0 1 22200 960 1 0.99 NONE 0 0 664497 1114 0 1 22200 95104 1 3.19 NONE 0 0 664497 1114 0 3 22200 315 2 3.98 NONE 0 0 664497 1114 0 2 22200 324 1 1.99 NONE 0 0 664497 1114 0 1 22200 865 4 3.96 NONE 0 0 664497 1114 0 2 22200 93043 1 2.99 NONE 0 0 664497 1114 0 1 79400 60420 1 3.79 NONE 0 0 664497 1114 0 1 47400 27517 2 6.98 NONE 0 0 664497 1114 0 1 47400 27509 1 2.99 NONE 0 0 664497 1114 0 1 47400 27520 1 2.99 NONE 0 0 664497 1114 0 1 47400 13138 4 13.96 NONE 0 0 ... View more

Re: meet problems for reading in data

by Calcite | Level 5 in SAS Studio
‎08-03-2018 11:42 PM
‎08-03-2018 11:42 PM
Sorry, the txt file is too large and can not be attached. If without the txt file, is it possible for you to give me some advice like change the delimiter or something? Thanks ... View more

meet problems for reading in data

by Calcite | Level 5 in SAS Studio
‎08-03-2018 11:25 PM
‎08-03-2018 11:25 PM
Hi,  I'm using SAS on demand version. I am trying to read in the txt file in to sas, but I met some problems. I have a dataset shown as below.   And I try for a few lines of code as shown in the picture. I am confused about the delimiter and I try on "09"X.   However, the output dataset appears all dot without any values, any suggestions will really appreciate.   ... View more

how to include a categorical classification variable for logistic regr...

by Calcite | Level 5 in Statistical Procedures
‎07-19-2018 12:30 AM
‎07-19-2018 12:30 AM
Hi, I'm dealing with a problem of logistic regression and I am confused about including the categorical classification variable in the model. The variables in the model are R Age S Ed Ex0 Ex1 LF M N NW U1 U2 W X respectively; I have to fit the logistic regression model of high as a function of all variables using Age through X and treat S as a categorical classification variable in the model. Below are my codes   proc logistic data=uscrime;          class S /param=ref ref=first;          model high = Age S Ed Ex0 Ex1 LF M N NW U1 U2 W X;          ods select ModelInfo ParameterEstimates Type3 OddsRatios;  run;   Am I in the right way or is there any suggestions? Thanks! ... View more

which statement should I use to display the top 15 players with the hi...

by Calcite | Level 5 in SAS Procedures
‎07-09-2018 11:50 PM
‎07-09-2018 11:50 PM
Hi, I was assigned to create a temporary data set that contains the top 15 players with the highest efficiency rating. Efficiency rating is one of the variables in the dataset. I was wondering which statement could I use to solve this kind of problem? (I only learned about where, if, proc freq statements like that) Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-04-2018 11:06 PM
Quick links