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: 
aminkarimid
‎06-29-2020
  • 166 Posts
  • 32 Likes Given
  • 7 Solutions
  • 1 Likes Received

Re: How to choose a dummy manually for regressing as an intercept?

by Lapis Lazuli | Level 10 in Statistical Procedures
‎07-30-2017 12:50 PM
‎07-30-2017 12:50 PM
Hello @PaigeMiller Here is my first result: First result When I use "REF=first", the result is: Question01: Why the result have changed when I use "ref" that it is contrary to what you mentioned? Question02: The "REF" option can be "first" or "last" and I want to choose reference category between them. How can I do that?   Thanks. ... View more

Re: How to choose a dummy manually for regressing as an intercept?

by Lapis Lazuli | Level 10 in Statistical Procedures
‎07-30-2017 12:20 PM
‎07-30-2017 12:20 PM
The "REF=option" just can be first and last. However, I have six dummies that I want to choose between them and the result absolutely different by changing the reference category. ... View more

How to choose a dummy manually for regressing as an intercept?

by Lapis Lazuli | Level 10 in Statistical Procedures
‎07-30-2017 09:44 AM
‎07-30-2017 09:44 AM
Hello everybody, I want to run a regression with dummies. My dummies are half-hour period variables which are from 9 to 12 o'clock and I have totally six dummies. However, SAS just predict five dummies and one intercept in a regression model as you know and the last dummy is the intercept subtracted by the aggregate of other dummies (in my research the dummy variable which is made for half-hour period from 11:30 to 12 o'clock). SAS choose which dummies to be the intercept and I want to choose it by myself. I use codes which are shown below:   proc glm data=Sampledata_02_mer; class TRD_EVENT_ROUFOR; model adjusted_volume = TRD_EVENT_ROUFOR / solution; ods select ParameterEstimates; quit;   How can I do that? Thanks in advance. ... View more

Re: How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 10:07 AM
‎07-28-2017 10:07 AM
What is difference between "Where MYVAR between '09:00't and '12:00't" and What you said. Because, I have different results from them. Thanks ... View more

Re: How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 09:49 AM
‎07-28-2017 09:49 AM
I want to bind TRD_EVENT_TM as the time variable between 9:00 till 12:00. So, all observations which are not in this range must be omitted from the dataset. Thanks. ... View more

Re: How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 09:44 AM
‎07-28-2017 09:44 AM
I want to bind TRD_EVENT_TM as the time variable between 9:00 till 12:00. So, all observations which are not in this range must be omitted from the dataset. ... View more

Re: How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 09:22 AM
‎07-28-2017 09:22 AM
Here is a sample of my dataset. Thanks in advance. data WORK.SAMPLEDATA03; infile datalines dsd truncover; input TRD_STCK_CD:$15. TRD_PR:32. TRD_TUROVR:14. TRD_EVENT_DT:DATE9. TRD_EVENT_TM:TIME5.; format TRD_TUROVR 14. TRD_EVENT_DT DATE9. TRD_EVENT_TM TIME5.; label TRD_STCK_CD="TRD_STCK_CD" TRD_PR="TRD_PR" TRD_TUROVR="TRD_TUROVR" TRD_EVENT_DT="TRD_EVENT_DT"; datalines4; IKCQ1,1,100,24MAR2008,12:19 ALBZ1,1537,10000,24MAR2008,12:28 ALBZ1,1567,10,24MAR2008,13:13 AZAB1,683,10000,24MAR2008,12:20 AZAB1,695,10,24MAR2008,13:13 BALI1,850,9260,24MAR2008,9:14 BALI1,850,2000,24MAR2008,9:15 BALI1,850,10000,24MAR2008,9:15 BALI1,850,6000,24MAR2008,9:15 BALI1,850,10000,24MAR2008,9:29 BALI1,850,10000,24MAR2008,12:28 BALI1,850,10000,24MAR2008,12:28 BALI1,865,10,24MAR2008,13:13 BANK1,1164,10729,24MAR2008,9:38 BANK1,1148,2000,24MAR2008,11:24 BANK1,1147,1575,24MAR2008,11:24 BANK1,1147,5000,24MAR2008,12:10 BANK1,1147,3425,24MAR2008,12:10 BANK1,1141,41575,24MAR2008,12:14 BANK1,1141,8425,24MAR2008,12:14 ;;;; Code inserted by @Kurt_Bremser from the .zip ... View more

Re: How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 08:57 AM
‎07-28-2017 08:57 AM
Hello @Kurt_Bremser How can I use your codes using sas 9.4 TS Level 1M3 X64_8PRO platform? I use the code which is shown below. However, it doesn't work. %data2datastep(sampledata03,work,test,20) Thanks. ... View more

Re: How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 08:35 AM
‎07-28-2017 08:35 AM
So, Would you please tell me how can I fix this problem? If you know another codes for this purpose, please tell me. ... View more

Re: How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 07:37 AM
‎07-28-2017 07:37 AM
Here is a sample of my dataset. Thanks. ... View more

How to use "where statement" for bounding time?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 06:30 AM
‎07-28-2017 06:30 AM
 Hello everybody, I want to restrict time variable of my dataset and I use code which is shown below, however, it doesn't work and out of range data still exist in the dataset!   data sampledata04; set sampledata03; where hour(TRD_EVENT_TM) between 9 and 12; run;   Attributes of dataset are:   Alphabetic List of Variables and Attributes # Variable Type Len Format Informat Label 4 TRD_EVENT_DT Num 8 DATE9. DATETIME19. TRD_EVENT_DT 5 TRD_EVENT_TM Num 8 TIME5.     2 TRD_PR Num 8     TRD_PR 1 TRD_STCK_CD Char 15 $15.00 $15.00 TRD_STCK_CD 3 TRD_TUROVR Num 8 14 14 TRD_TUROVR      What is the problem?   Thanks in advance. ... View more

How to delete duplicate data based on matching data in two table?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-28-2017 02:22 AM
‎07-28-2017 02:22 AM
Hello everybody, I have two tables which are shown below:   Table 01 Date Time Name Price 1 1 asd 1 1 2 asd 2 1 2 sdf 1 1 4 sdf 2 2 1 dfg 1 2 2 sdf 2 3 1 asd 3 3 2 fgh 1 3 3 fgh 2   Table 02 Name Status sdf 1 zxc 2 xcv 1 cvb 1 fgh 2     Now, I want to find duplicate data by Name based on table 02, and then delete them. I mean that the SAS searchs tables to find data with same name and delete them just from table 01, like the table below:   Final table Date Time Name Price 1 1 asd 1 1 2 asd 2 2 1 dfg 1 3 1 asd 3     All variable except Name are numeric.   1. How can I do that? 2. How can I report on deleted data?   Thanks in advance. ... View more

Re: How to read data and time as a numeric variable?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-26-2017 06:27 PM
‎07-26-2017 06:27 PM
ERROR 48-59: The format $TIME was not found or could not be loaded. ... View more

Re: How to read data and time as a numeric variable?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-26-2017 05:41 PM
‎07-26-2017 05:41 PM
Here is my code which is used to convert character variables to numeric: data sampledata01; set sampledata; trd_event_dt = datepart(trd_event_dt); format trd_event_dt date9.; new_var = input(TRD_EVENT_TM,hhmmss.); format new_var time5.; drop TRD_EVENT_TM; rename new_var = TRD_EVENT_TM; run; Explanation: The trd_event_dt is Date. The TRD_EVENT_TM is Time. ... View more

Re: How to read data and time as a numeric variable?

by Lapis Lazuli | Level 10 in SAS Programming
‎07-26-2017 10:45 AM
‎07-26-2017 10:45 AM
Initial date and time variable were character and I formatted them to numeric. ##- Please type your reply above this line. Simple formatting, no attachments. -## ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-29-2020 04:18 PM
  • Contact User via Skype
Likes given to
Likes from
View All
Quick links