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: 
Wsingh
‎12-01-2018
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS Unzip Problem

by Calcite | Level 5 in SAS Programming
‎11-30-2018 05:30 AM
‎11-30-2018 05:30 AM
Thanks for your reply !   No the zip file name is " filename inzip ZIP "C:\Users\WSingh\Data\diabetes\201809\A201809_diab_ws.zip";" i forgot to add this file name initially in my post .   In this zip file there is a data csv file which i need to import in sas without unzipping it. i am able to do this but there is a blank row created due to some reason which i am trying to find out.   I cannot upload the file because of data security issue.hope you understand this!   Thanks for you help!!         ... View more

SAS Unzip Problem

by Calcite | Level 5 in SAS Programming
‎11-30-2018 01:58 AM
‎11-30-2018 01:58 AM
When i am trying to import a CSV file directly from zipped file(winzip) i get a extra column in the the SAS dataset.I also tried to manually unzip the zip file (winzip)and the import the CSV file the sas dataset created was fine(no extra blank row).I really don't understand why this changes are observed.   eg; after importing data from zipped file data looks below. product substance code A M 1 B N 2 C O 3 D P 4       E Q 5 F R 6 G S 7   Actual table should look like below.   product substance code A M 1 B N 2 C O 3 D P 4 E Q 5 F R 6 G S 7     code:   data check; infile inzip("data.csv") delimiter = ',' MISSOVER DSD firstobs=2 ; length product $20. substance $18. code 6.; input product $ substance $ code; run;   Thanks in Advance! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-01-2018 12:26 AM
Quick links