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: 
svzplayer
‎06-09-2020
  • 8 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Proc genmod for train and test subsets

by Fluorite | Level 6 in Statistical Procedures
‎06-07-2020 10:01 AM
‎06-07-2020 10:01 AM
Hello everyone, I have a following problem: I have divided dataset for two subsets - train and test. I wanted to perform three analysis, i.e. simple lin.reg., using box-cox and using genmod with gamma distribution. For the first two I have fitted model for train and calculated it later using proc score. However, I'm stuck with genmod. How can I predict values (for dataset test) here? Is there any way to calculate it automatically? Thanks in advance! ... View more

Re: proc import swaps day and month

by Fluorite | Level 6 in New SAS User
‎06-03-2020 08:04 PM
‎06-03-2020 08:04 PM
Thank you very much! ... View more

Re: proc import swaps day and month

by Fluorite | Level 6 in New SAS User
‎06-03-2020 04:05 PM
‎06-03-2020 04:05 PM
Sorry if the link is inaccessible 😞  Yes, date is in format dd/mm/yyyy so I guess it's DDMMYY10. . Here is a funny thing, I followed your instructions and log shows that I have set dmy. However, when I run proc contents, it shows MMDDYY10. in the particular cell. In a reply for a previous answer, I have attached results from proc import and data step. I hope it can help somehow, because I run out of ideas... ... View more

Re: proc import swaps day and month

by Fluorite | Level 6 in New SAS User
‎06-03-2020 04:01 PM
‎06-03-2020 04:01 PM
Alright, I have followed your suggestion writing: data crime; infile "<path>" DLM=',' FIRSTOBS=2; input month $ Total_crimes Serious Huge_damage Ecological Terrorism Extremism Murder Harm_to_health Rape Theft Vehicle_theft Fraud_scam Hooligan Drugs Weapons; format month DDMMYY10.; run; And... Another problem. I attach two photos - first results with proc import and 2nd with this data step procedure. Seems like all years are cut on the first 2 digits.   <sorry for such a long reply, however I could not upload either .png or .jpg> ... View more

proc import swaps day and month

by Fluorite | Level 6 in New SAS User
‎06-03-2020 03:29 PM
‎06-03-2020 03:29 PM
Hello everyone, I am trying to do some regression on datafile from here: https://www.kaggle.com/tsarkov90/crime-in-russia-20032020 However, I encounter a problem. I have tried to import the file using: proc import datafile="<path>" out=crime dbms=csv replace; getnames=yes; run; The problem is, that it seems to swype month and day. I mean there are first 12 days of January and then next year. How can I fix this problem? Also, for further analysis I'd like to retain only month/year. How can I do this?   Many thanks, cheers  ... View more

Re: Contingency table from a dataset

by Fluorite | Level 6 in SAS Procedures
‎05-25-2020 06:41 AM
‎05-25-2020 06:41 AM
Thanks! ... View more

Re: Contingency table from a dataset

by Fluorite | Level 6 in SAS Procedures
‎05-25-2020 05:56 AM
‎05-25-2020 05:56 AM
I am asking how to turn this into another SAS data set which is set up like a contingency table, sorry for ambiguity. ... View more

Contingency table from a dataset

by Fluorite | Level 6 in SAS Procedures
‎05-25-2020 05:50 AM
‎05-25-2020 05:50 AM
Hello, I need help creating a contingency table from a dataset. I have a dataset in a form: A X1 n1 A X2 n2 B X1 n3 B X2 n4 , where ni is number of observations in a group and I need to make a contingency table from this dataset. How can I do that? Many thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-09-2020 01:36 PM
Likes given to
View All
Quick links