data NPOz; *[1]* input ID name source_url status category fax postal_address physical_address phone $reg_no $reg_date email_address category1 category2 category3 ; datalines; 143.655 Umusa_Wenkosi_Gospel_Ministries www.npo.gov.za Registered Development_and_Housing 113354483 P\B_X28_Johannesburg_2006 "33Church_Street""Alberton""Johannesburg""2006" .............. 156.666 Mcmillan_House_of_Care www.npo.gov.za Application_Declined Health_Care 124568895 ........................... ; run; I tried my best to recreate the data in the data step but the actual data set is imported from an excel spreadsheet.
... View more
Please help: Using version 9.3 I have a dataset which is a list of NPO's around South Africa and is named NPOz. From the 26 variables one is named Address and as the name suggests it contains the physical addresses for all the observed NPO's. From the address variable, I want to extract the name of the city so as to keep those that are from Johannesburg and Pretoria and delete the rest. Please help me with the right code for this job.
... View more
This works in a way, it only displays the names of the files. I believe the next move is to write a code that imports the files and create datasets, am I correct? Please explain the "tmp" in the code. Thank you for the response.
... View more
Dear SAS Users I'm asked to research on "how to read a text file in SAS when a folder name is known but the file name is unknown". I checked all my notes but nothing is coming from there.
... View more
Hello SAS users I have the attached kind of data: I want to create a new variable, "date" which is a combination of the year and the number corresponding to the month (like this, 200810 to represent Oct 2010) please assist me.
... View more