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: 
Adi27
‎01-30-2024
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

WHY IS MY TABLE EMPTY

by Calcite | Level 5 in New SAS User
‎11-02-2023 11:57 AM
‎11-02-2023 11:57 AM
/* Sort the Products dataset by review_count in descending order */ proc sort data=Qed.Products; by descending review_count; run; /* Print the top-most record (most reviewed product) */ data MostReviewedProduct; set Qed.Products; if _N_ = 1; run; /* Print the most reviewed product */ PROC PRINT DATA=MostReviewedProduct; TITLE "Most Reviewed Product"; RUN; /* Sort the Products dataset by review_count in ascending order */ proc sort data=Qed.Products; by review_count; run; /* Print the top-most record (least reviewed product) */ data LeastReviewedProduct; set Qed.Products; if _N_ = 1; run; /* Print the least reviewed product */ PROC PRINT DATA=LeastReviewedProduct; TITLE "Least Reviewed Product"; RUN; /* Compare the most reviewed and least reviewed products */ data ProductComparison; merge MostReviewedProduct (in=a) LeastReviewedProduct (in=b); by _all_; if a and b then do; if review_count_1 < review_count_2 then do; message = "Most reviewed product has fewer reviews than the least reviewed product."; end; else if review_count_1 > review_count_2 then do; message = "Most reviewed product has more reviews than the least reviewed product."; end; else do; message = "Most reviewed product has the same number of reviews as the least reviewed product."; end; end; run; /* Print the comparison result */ PROC PRINT DATA=ProductComparison; var review_count_1 review_count_2 message; title "Comparison Between Most Reviewed and Least Reviewed Products"; RUN;   HI THIS IS MY CODE AND THE COMPARISON TABLE IS EMPTY ... View more

Re: converting character value to numeric

by Calcite | Level 5 in New SAS User
‎11-02-2023 09:07 AM
‎11-02-2023 09:07 AM
this is the log: 88 /* Descriptive Statistics for available products */ 89 PROC MEANS DATA=AvailableProducts; 90 VAR grams price rating; ERROR: Variable grams in list does not match type prescribed for this list. ERROR: Variable price in list does not match type prescribed for this list. ERROR: Variable RATING not found. 91 OUTPUT OUT=AvailableStats 92 MEAN=Avg_grams Avg_price Avg_rating; 93 RUN; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.AVAILABLESTATS may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.AVAILABLESTATS was not replaced because this step was stopped. NOTE: PROCEDURE MEANS used (Total process time): ... View more

converting character value to numeric

by Calcite | Level 5 in New SAS User
‎11-02-2023 08:51 AM
‎11-02-2023 08:51 AM
Hi my code is showing an error of not being able to find the values:   /* New dataset for available products */ data AvailableProducts; set Qed.Products; where available = 'T'; run; /* New dataset for unavailable products */ data UnavailableProducts; set Qed.Products; where available = 'F'; run; /* New dataset for converting grams and rating to numeric values */ Data Qed_Converted; Set Qed.Products; rating_num = input(rating, best32.); grams_num = input(grams, best32.); run; /* Descriptive Statistics for available products */ PROC MEANS DATA=AvailableProducts; VAR grams price rating; OUTPUT OUT=AvailableStats MEAN=Avg_grams Avg_price Avg_rating; RUN;   I have converted the character values to numeric still it is showing this! ... View more

Merging datasets with different variable names.

by Calcite | Level 5 in New SAS User
‎11-01-2023 10:19 AM
‎11-01-2023 10:19 AM
Is it possible to merge 2 data sets with different variable names for the same thing? For example, my product sheet has a column product_id which is same as column product in reviews but im unable to join them due to different names. Is it possible to join the two tables.   /* Merge LowRatedProducts with Products to access prices */ data LowRatedProductsWithPrices; merge LowRatedProducts (in=a) Qed.Products (in=b); by product_id;  if a and b; run; /* Print the low-rated products along with their prices */ PROC PRINT DATA=LowRatedProductsWithPrices; title "Low-Rated Products and Their Prices"; RUN;   This shows an error because review doesn't have products_id but product. ... View more

Unable to access more than 30 variables in the dataset

by Calcite | Level 5 in Statistical Procedures
‎10-30-2023 09:49 PM
‎10-30-2023 09:49 PM
Hi, I have a data set with 6 excel sheets and 1 of them is products which has 1069 rows. I am unable to perform my analysis on more than 30 observations. Can some one help me with this issue, i am doing this for my University assignment.     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-30-2024 06:21 AM
Quick links