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: 
Ananyayadav
‎09-24-2018
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

getting missing values while running proc sort

by Calcite | Level 5 in SAS Procedures
‎09-23-2018 03:21 PM
‎09-23-2018 03:21 PM
I am getting missing values in every column of my data set after running this below proc sort code. can anyone help me with this?   Proc sort data=lib.grocery_couponsx out=sorted_freq;  by gender;  run;   data set is created successfully but allover missing values. ... View more

exporting a file

by Calcite | Level 5 in SAS Programming
‎09-09-2018 11:07 AM
‎09-09-2018 11:07 AM
hey..i m getting error in exporting file in sas.   my code was:  proc export data=lib.car_sales outfile='F:\SASUniversityEdition\myfolders\Book1.xlsx' dbms=xlsx; run;   and my error was:   ERROR: DBMS type XLSX not valid for export. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds   Please help me out. ... View more

Facing error in using proc import

by Calcite | Level 5 in SAS Programming
‎08-16-2018 03:19 AM
‎08-16-2018 03:19 AM
I am trying to run IMPORT in one of the excel file but i am facing some error. please have a look:   proc import datafile='/folders/myfolders/Datasets/cars_excel.xlsx' dbms=xlsx out=test.car_dummy; getnames=no; run;   and the error appearing in log is window is:    ERROR: Physical file does not exist, /folders/myfolders/Datasets//cars_excel. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.04 seconds cpu time 0.06 seconds   i have already located excel file i.e., cars_excel.xlsx in above path.can anyone clarify where i am wrong?   ... View more

Getting missing numeric value(.) in gender when i am trying to create ...

by Calcite | Level 5 in SAS Programming
‎08-14-2018 05:30 AM
‎08-14-2018 05:30 AM
My code was this:   data test.ds1; set test.ds; age=23; gender=M; run;   and my log window is showing this message:   NOTE: Variable M is uninitialized. NOTE: There were 1 observations read from the data set TEST.DS. NOTE: The data set TEST.DS1 has 1 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.23 seconds cpu time 0.14 seconds   Can anyone please clarify where i am wrong? ... View more

Error in creating library

by Calcite | Level 5 in SAS Programming
‎08-13-2018 06:20 AM
‎08-13-2018 06:20 AM
OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 libname test '/folders/myfolders/'; NOTE: Libref TEST was successfully assigned as follows: Engine: V9 Physical Name: /folders/myfolders 74 75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;  I am facing above error while creating library. Please help me where i am wrong. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-24-2018 02:42 PM
Quick links