topic Re: Issue with Code, Data Skipped in SAS Studio

Issue with Code, Data Skipped

vipendra — Sun, 27 Jan 2019 14:21:04 GMT

Hi All,

URGENT !!!

Please check my code where i write code in input format to get the data.

Code gives me the output but there are some information which is skipped.

Please find the attachment of Code, Log & result / Output.

Please look into the result, I am not getting why City, State, Country, Date etc. column data is skipped.

Code:

data get_US_Company_Dataset;
infile '/home/vipendratripathi60/sasuser.v94/Vipen Raw Data Files/US_Company_Dataset.csv' dlm=',' dsd missover firstobs=2 lrecl=50;
length company_name_id $30 company_name city $30 state $2 country $2 company_type $20;
informat date_of_audit mmddyy8.;
input company_name_id company_name year_founded city state country zip_code company_type date_of_audit;
format date_of_audit mmddyy8.;
proc print;
run;

Regards

Vipendra (vipendratripathi6@gmail.com)

Re: Issue with Code, Data Skipped

VDD — Sun, 27 Jan 2019 14:08:22 GMT

Hello @vipendra and welcome to the community. your sample is unviewable.

Please post you SAS code and sample data in the manner that we can view and use it to assist you.

Maxims of Maximally Efficient SAS Programmers
https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers/ta-p/352068

How to convert datasets to data steps
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

The macro for direct download
https://gist.githubusercontent.com/statgeek/bcc55940dd825a13b9c8ca40a904cba9/raw/865d2cf18f5150b8e887218dde0fc3951d0ff15b/data2datastep.sas

How to post code
https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting

Re: Issue with Code, Data Skipped

vipendra — Sun, 27 Jan 2019 14:11:00 GMT

thanks for raising the point, I have added my codes in description box.
Please look into this.

Re: Issue with Code, Data Skipped

VDD — Sun, 27 Jan 2019 14:14:31 GMT

Re: Issue with Code, Data Skipped

vipendra — Sun, 27 Jan 2019 14:22:40 GMT

Edited as suggested, PDF attachment is for your reference as i am unable to attach in HTML file.

Re: Issue with Code, Data Skipped

VDD — Sun, 27 Jan 2019 14:45:13 GMT

in your length statement what is the length of company_name?

length company_name_id $30 company_name city $30 state $2 country $2 company_type $20;

Re: Issue with Code, Data Skipped

vipendra — Sun, 27 Jan 2019 14:50:26 GMT

Its again $30, I have updated in code also.

But my concern is why data is missing or incomplete.

Re: Issue with Code, Data Skipped

VDD — Sun, 27 Jan 2019 15:13:19 GMT

@vipendra you have lrecl = 50. Is that really the length of each record? Or have you not allowed for the 51--?? positions?

Re: Issue with Code, Data Skipped

vipendra — Sun, 27 Jan 2019 15:20:27 GMT

i want full data in output. and I even don't know how LRECL works.

do you mean each record = each cells in excel ?
if yes then each cells does not exceeds the limit of 30 words in my file.

Re: Issue with Code, Data Skipped

VDD — Sun, 27 Jan 2019 16:02:57 GMT

@vipendra try to change the lrecl = 50 to lrecl = 256 or something longer, the lrecl = 50 only allows you to obtain the first 50 positions in the record.

what you are getting is

company_name_id $30 company_name for a length of $20 which equals your record length of 50. if your company_name is $30 then those company_names over 20 in length are being chopped off at the end or truncated as one would say.

in the above you say that company_name is $30 but in this link you have company_name with a length of $40

https://communities.sas.com/t5/SAS-Programming/ERROR-22-322-Expecting-a-name/m-p/530456#M145073

try this:

data get_US_Company_Dataset;
infile '/home/vipendratripathi60/sasuser.v94/Vipen Raw Data Files/US_Company_Dataset.csv' dlm=',' dsd missover firstobs=2 lrecl=256;
length company_name_id $30 company_name  $30 city $30 state $2 country $2 company_type $20;
informat date_of_audit mmddyy8.;
input company_name_id company_name year_founded city state country zip_code company_type date_of_audit;
format date_of_audit mmddyy8.;
run;
proc print;
run;

Re: Issue with Code, Data Skipped

Reeza — Sun, 27 Jan 2019 23:58:42 GMT

LRECL is the length of the record to read. A length of 50 says to read only 50 characters.

You don’t actually need that option. Uploads should be working soon to add attachments, but you can embed an image directly using the ‘photos’ in the editor.

You can also try PROC IMPORT with GUESSINGROWS=MAX and then compare the generated code in the log to yours and find the mistake.

@vipendra wrote:
i want full data in output. and I even don't know how LRECL works.

do you mean each record = each cells in excel ?
if yes then each cells does not exceeds the limit of 30 words in my file.

Re: Issue with Code, Data Skipped

Kurt_Bremser — Mon, 28 Jan 2019 07:15:20 GMT

@vipendra wrote:

Edited as suggested, PDF attachment is for your reference as i am unable to attach in HTML file.

You do NOT need to use an attachment for code, logs or data from a csv file, as all are pure text.

Post the csv into a window opened with the {i} button, and code into one opened with the "little running man" icon.

I cannot open your pdf, there's a "virus scan in progress" next to the attachment.