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: 
Amali6
‎05-17-2021
  • 47 Posts
  • 25 Likes Given
  • 0 Solutions
  • 1 Likes Received

Question on proc sql

by Quartz | Level 8 in SAS Programming
‎05-22-2020 08:52 PM
‎05-22-2020 08:52 PM
Hi Could anyone help on how to create a new column(total) by adding the sum of two numerical variables(var1, var2) from the main table, using proc sql? For example, if i want to add var1 and var2 columns and name the new column as total, from work.project.    Thanks ... View more

Re: Query on Pmenu

by Quartz | Level 8 in SAS Programming
‎05-22-2020 08:48 PM
‎05-22-2020 08:48 PM
sorry for that. ... View more

Re: Question on proc corr output

by Quartz | Level 8 in Statistical Procedures
‎05-22-2020 06:52 PM
‎05-22-2020 06:52 PM
Thank you very much this helps a lot!! ... View more

Re: Question on proc corr output

by Quartz | Level 8 in Statistical Procedures
‎05-22-2020 06:07 PM
‎05-22-2020 06:07 PM
Thank you. Can you explain the condition on correlation how to predict that two variables are correlated or not please? ... View more

Re: Question on proc corr output

by Quartz | Level 8 in Statistical Procedures
‎05-22-2020 05:42 PM
‎05-22-2020 05:42 PM
Sorry this is what i got. Thanks  ... View more

Re: Question on proc corr output

by Quartz | Level 8 in Statistical Procedures
‎05-22-2020 05:23 PM
‎05-22-2020 05:23 PM
Thank you very much for explaining. I have tried with other variables in there i got a line between left and right side of the graph, can you help what kind of relationship to say in that case please? Thanks ... View more

Re: Question on proc corr output

by Quartz | Level 8 in Statistical Procedures
‎05-22-2020 05:03 PM
‎05-22-2020 05:03 PM
Thank you. since mine is big dataset, the plots are showing very close and i cant understand clearly. Could you please explain how to say how to say there is relationship and not related? Thanks. ... View more

Re: Question on proc corr output

by Quartz | Level 8 in Statistical Procedures
‎05-22-2020 04:48 PM
‎05-22-2020 04:48 PM
Thank you very much for the response.  I am trying to understand the correlation so i wanted to know in this scatter graph the p-value is 0.9590 how this is very weak, sorry i cant understand on what aspect to say when a plot correlation graph is strong or weak. I tried with some other variables in my dataset but the output looks like a line between two variables in between. Also could you please explain why the minimum value is 0.    Thank you ... View more

Question on proc corr output

by Quartz | Level 8 in Statistical Procedures
‎05-22-2020 02:54 PM
‎05-22-2020 02:54 PM
Hi all,  I have tried the proc corr for the first time, to find relationship between two variables in my dataset. I used the following code and i got this output. I don't understand is this the increasing trend or decreasing mainly I wanted to check ods graphics on; title'To find relation between variables'; proc corr data=hotel.Hotel_bookings plots(MAXPOINTS=NONE)=all; var lead_time booking_changes; run; ods graphics off; whether is the right output please?  Can someone please explain is this the right plots for this variables and this how it looks like?      Thank you ... View more

Re: Query on Proc corr

by Quartz | Level 8 in Statistical Procedures
‎05-21-2020 08:18 PM
‎05-21-2020 08:18 PM
Thank you very much, with this code now i can see the output with all plots. Could you please help for my other query that i have posted in this community regarding pmenu procedure? i associated my menu created through fsedit but the menu is not appearing so can i try another pmenu linking same dataset and procs using windows application? ... View more

Re: Query on Proc corr

by Quartz | Level 8 in Statistical Procedures
‎05-21-2020 07:28 PM
‎05-21-2020 07:28 PM
Thanks for the reply. I have tried the following code. proc corr data=hotel.Hotel_bookings plots(MAXPOINTS=NONE); var booking_changes adr; run; NOTE: The PLOTS option is ignored unless you also specify suboptions Could you please help on how to get the plots? Thanks ... View more

Query on Proc corr

by Quartz | Level 8 in Statistical Procedures
‎05-21-2020 06:30 PM
‎05-21-2020 06:30 PM
Hello experts, I am trying proc corr between two variables in my dataset, when i run the code i got this warning message in log. WARNING: The scatter plot matrix with more than 5000 points has been suppressed. Use the PLOTS(MAXPOINTS= ) option in the PROC CORR statement to change or override the cutoff  Again I have retried with this code  plots(MAXPOINTS=NONE);  i got a NOTE in log saying that    NOTE: The PLOTS option is ignored unless you also specify suboptions Could you explain what does the log mean? and how to get the output in plots for my variables please?   Thanks in advance!     ... View more

Re: Query on Pmenu

by Quartz | Level 8 in SAS Programming
‎05-21-2020 06:21 PM
‎05-21-2020 06:21 PM
Yes i have referred the "Associating Menu Bar with FSEDIT Session" as well but i got wrong output that i have shared in my previous post. Again i wanted to check, whether can i create another pmenu using window application rather than fsedit please. Thanks ... View more

Query on Pmenu

by Quartz | Level 8 in SAS Programming
‎05-20-2020 08:56 PM
‎05-20-2020 08:56 PM
Hi all, Can you suggest me some queries regarding pmenu ? I have created the menu and i run using fsedit window but the menu didn't appear, i have referenced the sas documentation as well but nothing helped to work it out. I have post that screenshot in my previous post in this community. So now my question is, can i create another pmenu using windows, ie, data_null statement by linking the same dataset and procs? I wanted to know whether it will work? Please provide your suggestions    Thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-17-2021 09:15 PM
Likes given to
Likes from
View All
Quick links