yli33 Tracker
https://communities.sas.com/kntur85557/tracker
yli33 TrackerSun, 14 Jul 2024 17:37:45 GMT2024-07-14T17:37:45ZRe: Exporting a SAS Dataset to .CSV File in SAS 9.4
https://communities.sas.com/t5/New-SAS-User/Exporting-a-SAS-Dataset-to-CSV-File-in-SAS-9-4/m-p/515640#M2959
<P><SPAN>Thank you so much for detecting that error! It works now!</SPAN></P>Fri, 23 Nov 2018 19:19:26 GMThttps://communities.sas.com/t5/New-SAS-User/Exporting-a-SAS-Dataset-to-CSV-File-in-SAS-9-4/m-p/515640#M2959yli332018-11-23T19:19:26ZRe: Exporting a SAS Dataset to .CSV File in SAS 9.4
https://communities.sas.com/t5/New-SAS-User/Exporting-a-SAS-Dataset-to-CSV-File-in-SAS-9-4/m-p/515639#M2958
<P>Thank you so much for detecting that error! It works now!</P>Fri, 23 Nov 2018 19:19:04 GMThttps://communities.sas.com/t5/New-SAS-User/Exporting-a-SAS-Dataset-to-CSV-File-in-SAS-9-4/m-p/515639#M2958yli332018-11-23T19:19:04ZExporting a SAS Dataset to .CSV File in SAS 9.4
https://communities.sas.com/t5/New-SAS-User/Exporting-a-SAS-Dataset-to-CSV-File-in-SAS-9-4/m-p/515633#M2953
<P>Hi, </P><P> </P><P>I have attempted to export a SAS dataset to .csv using the following piece of code but to no avail:</P><P> </P><P>PROC EXPORT DATA=XXX;<BR /> OUTFILE="File Pathname"<BR /> DBMS=CSV REPLACE;<BR /> PUTNAMES=YES;<BR />RUN;</P><P> </P><P>In fact, I received an error message that states the following: </P><P> </P><P>ERROR: FILE= or TABLE= is required and must be specified.</P><P> </P><P>Therefore, I would greatly appreciate it if someone could offer a solution to this issue. Thanks in advance!</P>Fri, 23 Nov 2018 19:04:45 GMThttps://communities.sas.com/t5/New-SAS-User/Exporting-a-SAS-Dataset-to-CSV-File-in-SAS-9-4/m-p/515633#M2953yli332018-11-23T19:04:45ZRe: Unable to View SAS Datasets in SAS Library
https://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/514013#M138578
<P>Hi,</P><P> </P><P>Thank you so much for clarifying the root cause of my SAS issue. I have already concatenated the two folders into a single library and was able to view all datasets located in both folders. Thanks again!</P>Fri, 16 Nov 2018 18:18:55 GMThttps://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/514013#M138578yli332018-11-16T18:18:55ZRe: Unable to View SAS Datasets in SAS Library
https://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/514004#M138574
<P>Hi, </P><P> </P><P>Thank you for suggesting the <SPAN>"sas concatenated library" as an alternative solution to the SAS issue. I will definitely google the specific details involved in this procedure.</SPAN></P>Fri, 16 Nov 2018 17:53:31 GMThttps://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/514004#M138574yli332018-11-16T17:53:31ZRe: Unable to View SAS Datasets in SAS Library
https://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/514002#M138573
<P><SPAN>Hi Suryakiran,</SPAN></P><P> </P><P><SPAN>So, I have just tried to run each SAS code separately instead of both codes simultaneously. When I ran the first set of SAS codes, I am able to see all of the SAS datasets from my first folder within the SAS library. However, when I ran the second set of SAS codes, the datasets from the second folder overrode those from the first folder. Perhaps I should create two different libraries? </SPAN></P>Fri, 16 Nov 2018 17:51:17 GMThttps://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/514002#M138573yli332018-11-16T17:51:17ZUnable to View SAS Datasets in SAS Library
https://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/513992#M138565
<P>Hi, </P><P> </P><P><SPAN>I have encountered a rather odd issue regarding attempting to view the SAS datasets in SAS 9.4 after creating a SAS library. Specifically, I do not see any of the SAS datasets within my first folder when I created a new library in SAS. In other words, I am only able to view the datasets located in the second folder upon assigning it to the same SAS library. Please find below an example of the SAS code that I have used to create the SAS library:</SPAN></P><P> </P><DIV>LIBNAME XXXXXX 'FIRST FOLDER PATHNAME';</DIV><DIV>options validvarname=any;</DIV><DIV>LIBNAME XXXXXX 'SECOND FOLDER PATHNAME';<BR />options validvarname=any;</DIV><DIV> </DIV><DIV>Therefore, I would greatly appreciate it if someone could provide a potential solution to this issue. Thanks in advance!</DIV>Fri, 16 Nov 2018 17:36:20 GMThttps://communities.sas.com/t5/SAS-Programming/Unable-to-View-SAS-Datasets-in-SAS-Library/m-p/513992#M138565yli332018-11-16T17:36:20ZRe: Reasons for Wide 95% Confidence Intervals - Odds Ratio Point Estimates
https://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452340#M114151
<P>Hi Paige,</P><P> </P><P>Yes, I definitely think that inconsistent data in certain categories may be another major reason for the observed wide confidence intervals. Thank you again!</P><P> </P><P>Best, </P><P>Lisa</P>Sun, 08 Apr 2018 17:00:19 GMThttps://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452340#M114151yli332018-04-08T17:00:19ZRe: Reasons for Wide 95% Confidence Intervals - Odds Ratio Point Estimates
https://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452336#M114147
<P>Hi Paige,</P><P> </P><P>Yes, I am employing survey-based binary logistic regression models for the categorical variables in my dataset. Nevertheless, I have not observed any extraneous categories within the either the independent or dependent outcome variable although there are some missing values within both variables. </P><P> </P><P>Regarding my previous questions, I would just like to know whether there may be some alternative explanations for those significant point estimates and relatively larger point estimates for a specific category of the dependent variable but not for the other category. While I have also confirmed the relative sample sizes for each independent/dependent variable category, I was only able to conclude that wider confidence intervals correspond relatively smaller sample sizes since some weighted percentages were greater than 10%. </P><P> </P><P>Best,</P><P>Lisa</P>Sun, 08 Apr 2018 16:30:28 GMThttps://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452336#M114147yli332018-04-08T16:30:28ZRe: Reasons for Wide 95% Confidence Intervals - Odds Ratio Point Estimates
https://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452334#M114145
<P>Hi Paige, </P><P> </P><P>Thank you again for suggesting plausible reasons for the observed wide to extremely wide confidence intervals. However, I would like to seek additional clarification on the possibility of outliers for the categorical variables, in which I have verified based on a descriptive summary statistics analysis that no extraneous category exists. Also, could you perhaps provide some explanations for the observation that certain odds ratio point estimates for exposed group and response group are significant while others for the same exposed group but a different response group are insignificant. I have actually noticed that some of the confidence intervals associated with the significant point estimates are rather narrow, which may indicate relatively larger sample sizes. Nevertheless, I would still like to seek your advice on this observation.</P><P> </P><P>Also, could you possibly attempt to provide some explanations as to another observation in which I observed larger point estimates for the "low/medium" response category but smaller point estimates for the "high" response category. I have noticed that some of the larger point estimates correspond with a slightly wider confidence interval, which may be due to relatively smaller sample sizes. Another possible reason may be that relatively greater odds exist in the "low/medium" response category as opposed to the "high" response category for the same independent exposed group. Yet another rather obvious explanation may be that the log odds ratio estimate is simply higher in the "low/medium" response category with the larger odds ratio point estimate compared to that of the "high" response category with the slightly smaller odds ratio point estimate. Again, I would like to seeks your advice on the stated observations. Thank you!</P><P> </P><P>Best,</P><P>Lisa</P>Sun, 08 Apr 2018 16:06:21 GMThttps://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452334#M114145yli332018-04-08T16:06:21ZRe: Reasons for Wide 95% Confidence Intervals - Odds Ratio Point Estimates
https://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452296#M114134
<P>Hi Paige,</P><P> </P><P>Thank you for providing several possible explanations regarding wide 95% confidence intervals. Since I am only conducting bivariate survey logistic regression using a single categorical predictor and response variable, I do not think that outliers or multi-collinearity would be an issue of concern for my analyses. From my scrutiny of the results of crude odds ratio point estimates and corresponding confidence intervals, it appears that the main reason for the wide to extremely wide confidence intervals may indeed be attributed to relatively small sample sizes within the individual cell of the 2x2 contingency table.</P><P> </P><P>Best,</P><P>Lisa</P>Sun, 08 Apr 2018 06:27:10 GMThttps://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452296#M114134yli332018-04-08T06:27:10ZRe: Reasons for Wide 95% Confidence Intervals - Odds Ratio Point Estimates
https://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452265#M114117
<P>Hi Reeza,</P><P> </P><P>Thank you very much for your suggestions on interpreting the wide confidence intervals. I have just checked the standard error (0.7246) for one odds ratio point estimate (1.82) that corresponds to 95% confidence interval of (0.44, 7.52), which is slightly larger than the standard errors that I have obtained for those point estimates that correspond with narrower confidence intervals. Moreover, I do not think that I have to standardize logistic regression because once I take the antilog of the log odds ratio (e.g. beta coefficient estimate), the point estimates would revert back to the normal scale, correct? Thus, would it be reasonable to conclude that the wide confidence intervals are due to larger standard errors? Thank you again!</P><P> </P><P>Best,</P><P>Lisa</P>Sun, 08 Apr 2018 00:32:11 GMThttps://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452265#M114117yli332018-04-08T00:32:11ZReasons for Wide 95% Confidence Intervals - Odds Ratio Point Estimates
https://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452245#M114112
<P>Hi,</P><P> </P><P>I have recently encountered an issue regarding wide to extremely wide 95% confidence intervals that are associated with odds ratio point estimates. Upon verifying the sample sizes with respect to each exposure/outcome category, I realized that small sample sizes was not the underlying reason (e.g. most categories had at least 10% sample size frequency percentages, which do not appear to be small based on my perspective). Therefore, I would like to seek additional assistance with regard to providing possible alternative explanations for the wide confidence interval issue. Thank you in advance.</P><P> </P><P>Best,</P><P>Lisa</P>Sat, 07 Apr 2018 22:56:47 GMThttps://communities.sas.com/t5/SAS-Programming/Reasons-for-Wide-95-Confidence-Intervals-Odds-Ratio-Point/m-p/452245#M114112yli332018-04-07T22:56:47ZRe: Dilemma: Conducting Statistical Tests Using Proc Surveyfreq Statement on SAS 9.4
https://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408437#M99715
<P>Hi Reeza,</P><P> </P><P>My research group was considering conducting statistical tests such as chi-square tests to determine the association of the selected independent variables and dependent variables. If the p-value is significant (p<0.20 in our case), then we could safely proceed on to conducting logistic regression analyses by using those variables that are associated with each other. Moreover, we have some hypothetical assumptions on the independent variables that are expected to be associated with the dependent variable. Nevertheless, we are actually analyzing secondary survey dataset created by another colleague but did not expect so many cells with 0 frequencies that would not allow for collapsing. </P><P> </P><P>Best,</P><P>Lisa</P>Mon, 30 Oct 2017 00:26:34 GMThttps://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408437#M99715yli332017-10-30T00:26:34ZRe: Dilemma: Conducting Statistical Tests Using Proc Surveyfreq Statement on SAS 9.4
https://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408434#M99712
<P>Hi Paige,</P><P> </P><P>Both attachments that I have sent to you are actual data/cross-tabulation output tables that SAS has created based on the statement proc surveyfreq. Unfortunately, the formatting of the text file is rather distorted, which is why you may not be able to clearly see all the 0 frequencies. Since you do not trust the word attachment that I have sent you, I really do not know of another document format that is acceptable and maintains the original formatting of the output tables (perhaps an excel document though).</P><P> </P><P>Actually, I have already received a rather helpful response from another SAS expert, Reeza, that appears to provide the needed solution for that particular cross-tabulation (sex*lang) only. I believe that my research group may have selected infeasible variables to cross-tabulate, which may mean that the research study itself may be infeasible using the current survey dataset. </P><P> </P><P>Nevertheless, I really appreciated your time and assistance on this dilemma.</P><P> </P><P>Best,</P><P>Lisa</P><P> </P><P> </P>Mon, 30 Oct 2017 00:16:07 GMThttps://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408434#M99712yli332017-10-30T00:16:07ZRe: Dilemma: Conducting Statistical Tests Using Proc Surveyfreq Statement on SAS 9.4
https://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408432#M99710
<P>Hi Reeza,</P><P> </P><P>Thank you for your response. Nevertheless, fisher's exact test cannot be employed with the statement Proc Surveyfreq unfortunately. While I can definitely collapse those individual language groups into a single group "Other", that would only allow me to conduct wald chi-square test for sex by language only. Unfortunately, I realized that many other variables have distinct groups such as "yes" and "no", "always", "frequently", "sometimes"...etc in which there would be no good method to collapse any of the groups together when cells have 0 frequency since each group is distinct, unlike the language groups which could easily be collapsed into an "Other" group. </P><P> </P><P>I am rather sure that the commands that I have used for conducting statistical tests on survey data is correct such as the following:</P><P> </P><P>proc surveyfreq data=wdp.newzhang;</P><P> </P><P>tables heat_1*water/ wchisq;</P><P> </P><P>weights weight_3;</P><P> </P><P>run;</P><P> </P><P>Perhaps I just have selected infeasible variables to cross-tabulate and conduct statistical tests. Nevertheless, thank you very much for your time and assistance on this dilemma.</P><P> </P><P>Best,</P><P>Lisa</P>Mon, 30 Oct 2017 00:06:07 GMThttps://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408432#M99710yli332017-10-30T00:06:07ZRe: Dilemma: Conducting Statistical Tests Using Proc Surveyfreq Statement on SAS 9.4
https://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408414#M99701
<P>Hi Paige,</P><P> </P><P>I am actually referring to the attachments that I have sent to you previously (e.g. in particular the word document since the text file may not show all the values for the female group by different types of languages). I guess I would just like to know whether there is a another statistical test(s) that I can conduct with 0 frequencies or is this dataset (sex*lang) not capable of being analyzed by any type of statistical tests (p-values included)? Thanks again!</P><P> </P><P>Best,</P><P>Lisa</P>Sun, 29 Oct 2017 21:21:45 GMThttps://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408414#M99701yli332017-10-29T21:21:45ZRe: Dilemma: Conducting Statistical Tests Using Proc Surveyfreq Statement on SAS 9.4
https://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408397#M99687
<P>Hi Paige,</P><P> </P><P>Please find below the exact error message shown on the SAS log.</P><P> </P><P>NOTE: Chi-square tests cannot be computed for the table of SEX by LANG because at least one table</P><P>cell has 0 frequency.</P><P> </P><P>Also, there are several missing weighted frequency cells (0 frequency cells) for the female group. I think perhaps the text document is not clearly showing all the missing values in a table format as opposed to viewing the dataset through a word doc.</P><P> </P><P> </P>Sun, 29 Oct 2017 19:14:47 GMThttps://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408397#M99687yli332017-10-29T19:14:47ZRe: Dilemma: Conducting Statistical Tests Using Proc Surveyfreq Statement on SAS 9.4
https://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408393#M99683
<P>Hi Paige,</P><P> </P><P>I apologize for missing your questions earlier. Nevertheless, the table with Sex by Lang does show the error message that at least one table cell has 0 frequency. Thanks!</P>Sun, 29 Oct 2017 18:58:50 GMThttps://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408393#M99683yli332017-10-29T18:58:50ZRe: Dilemma: Conducting Statistical Tests Using Proc Surveyfreq Statement on SAS 9.4
https://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408386#M99676
<P>Hi Paige,</P><P> </P><P>I have converted the word document into a text document. Thanks!</P><P> </P><P>Best,</P><P>Lisa</P>Sun, 29 Oct 2017 18:42:11 GMThttps://communities.sas.com/t5/SAS-Programming/Dilemma-Conducting-Statistical-Tests-Using-Proc-Surveyfreq/m-p/408386#M99676yli332017-10-29T18:42:11Z