Posts

Showing posts with the label sas excel import

Featured Post

Python Set Operations Explained: From Theory to Real-Time Applications

Image
A  set  in Python is an unordered collection of unique elements. It is useful when storing distinct values and performing operations like union, intersection, or difference. Real-Time Example: Removing Duplicate Customer Emails in a Marketing Campaign Imagine you are working on an email marketing campaign for your company. You have a list of customer emails, but some are duplicated. Using a set , you can remove duplicates efficiently before sending emails. Code Example: # List of customer emails (some duplicates) customer_emails = [ "alice@example.com" , "bob@example.com" , "charlie@example.com" , "alice@example.com" , "david@example.com" , "bob@example.com" ] # Convert list to a set to remove duplicates unique_emails = set (customer_emails) # Convert back to a list (if needed) unique_email_list = list (unique_emails) # Print the unique emails print ( "Unique customer emails:" , unique_email_list) Ou...

Write and Read Excel files into SAS Studio

Image
The point is how to import an excel file into SAS. Step by step process given on reading Excel file into SAS and writing Excel file from SAS. SAS vs Excel Files Reading an Excel file into SAS Suppose that you have an Excel spreadsheet called auto.xlsx. The data for this spreadsheet is shown below: MAKE MPG WEIGHT PRICE AMC Concord 22 2930 4099 AMC Pacer 17 3350 4749 AMC Spirit 22 2640 3799 Buick Century 20 3250 4816 Buick Electra 15 4080 7827 Import Wizard Using the Import Wizard is an easy way to import data into SAS. The Import Wizard can be found on the drop-down file menu. Although the Import Wizard is easy it can be time-consuming if used repeatedly. The very last screen of the Import Wizard gives you the option to save the statements SAS uses to import the data so that they can be used again. The following is an example that uses common options and also shows that the file was imported correctly. PROC IMPORT OUT= WORK.auto1 DATAFILE= "C:\auto.xl" D...